Episode 276: Dynamic SQL and Testing in Isolation

The very first podcast episode I recorded was about Extended Events. We've had several new versions of SQL Server since that time, so I thought it was time to bring up the subject again. We are joined...

21 Nov 201938min

In the second quarter of 2019, it was announced that Power BI would support paginated reports--at first this was assumed to be connected to an announcement that Power BI would support the RDL files fr...

13 Nov 201920min

This week we heard the news of the release for SQL Server 2019 and a major focus of this release is data virtualization. In this episode, we discuss PolyBase--a topic we covered in Episode 95; however...

6 Nov 201937min

SQL Trail continues to be an experiment in the making and year three proved no different. Eugene joined us this year and we discuss some of the changes, how the vision has changed for the conference a...

24 Okt 201925min

After 170 episodes, we bring back Louis Davidson to talk about database design and get his thoughts on how we can get better at planning for our data. The show notes for today's episode can be found a...

17 Okt 201947min

The Lock Pages in Memory policy came up in our internal discussions. I wanted to chat about it a bit more and I couldn't think of a better person than Rick Lowe. After our recent SQL Trail, we sit dow...

9 Okt 201921min

Creating reports in Power BI is awesome, but once you are ready to publish the reports--where are you going to store all the data? In this episode, we discuss storage options for Power BI and discuss ...

25 Sep 201919min

Are you in the cloud? Lots of folks are talking about moving to the cloud; however, as we find in today's episode this can be tricky to quantify what people mean by being "in the cloud". We are happy ...

18 Sep 201930min