Let’s face it, using SQL PowerShell prior to SQL Server 2016 was like installing training wheels on a Ducati. But things have massively changed.
I’m going to explain what DevOps is, where it came from, and its implications for SQL Server. We’ll cover the human and technical basics of database DevOps - and I’m going to discuss some changes that data folk need to make.
In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance.
While we will briefly discuss advice you've probably heard before, like avoid SELECT * and don't use NOLOCK, you will also learn some subtleties in SQL Server that might surprise you, how some shorthand can bite you in the long run, and a very easy way to improve cursor performance.
In this session, we will walk through various features of Power BI, how Power BI can transform your company's data into rich visuals, and easy yet powerful analytics solutions for your whole organization.
This rapid-fire session goes over my learnings from the past six years of developing high performance SSRS reports, including topics like multivalue parameter efficiencies, how to best utilize subreports, and performing SQL CRUD operations with SSRS.
Discover how not to torture a SQL Server instance and how to avoid making choices that turn out to be not so smart in the long run.