Look inside Query Store to see what it does and how it works
Learning DAX can be tricky, especially if you have a background in SQL.
The FILTER function does not create a new filter context but a row context. The ROW function is executed in a filter context without creating a row context. To demystify this and all the other DAX Gotchas that I bumped into is the goal of my session.
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
Everyone that has been involved in Software Development can notice how huge the impact of a bug can be, and Databases are not the exception. In this session, you will learn how to test your SQL Server projects using Visual Studio and SQLUnitTesting.
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
A stream of handy tips, tricks, and ideas to boost your PowerShell skills and productivity.
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
Azure Cosmos DB has many use-cases, and not all of them are clear to Azure Cosmos DB newcomers. If you're a relational expert and have been wondering about graph, how you'd survive without a schema, and scale out databases this session can help.
If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you an end-to-end Data Science project covering the core technologies in Microsoft Data + AI stack.
Best bractices in DAX formulas from real world experience.
Hierarchies and graphs are the bread and butter of most business applications. SQL Server 2017 comes now with a different approach: Graph Database. You will learn best practices, have fun and will leave with handy scripts.
Session deals with the database maintenance problems (like defragmentation) in situation of 24/7 system. As we walk through the basic maintenance we keep in mind that our database is big and it takes a lot of time to do the proper maintenance.
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
Row Level Security based on related tables
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
Use temporal support in SQL Server and add what is missing out of the box.
In this session we will discuss about the Azure SQLDW and how we can use it to help on our day to day.
<<1234567>>