Episode 279: SQL Server Migrations Demystified

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 from Reporting Services. The guidance however, was to continue building paginated reports in Power BI. In the fourth quarter of 2019, more information emerged about paginated reports and in this episode we drill into the offering of paginated reports in Power BI and...shhh...we won't spoil it, but an old friend just might play a role in this 'new' offering. The show notes for today's episode can be found at http://sqldatapartners.com/2019/11/13/episode-181-paginated-reports-in-power-bi. Have fun on the SQL Trail!

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 it has really come of age with SQL Server 2019. Our very own Kevin Feasel talks about some of the improvements of the feature and we discuss some of the use cases of when it will be useful and some of the pitfalls you might run into as you implement it. We discuss how PolyBase can help you reduce storage and other costs by avoiding the need for ETL processes that duplicate data in order to make it accessible from one source. Kevin is putting the final touches on his book PolyBase Revealed, and if you are looking for a deep dive into the subject, we invite you to check out his book.   The show notes for today's episode can be found at http://sqldatapartners.com/2019/11/06/episode-180-polybase-in-sql-server-2019. Have fun on the SQL Trail!

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 and what the future will hold for our event. While there is plenty to be excited about with our event, we couldn't help ourselves and get into a discussion about Power BI and purchasing options.   The show notes for today's episode can be found at http://sqldatapartners.com/2019/10/24/episode-179-sql-trail-recap-buying-power-bi. Have fun on the SQL Trail!

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 at http://sqldatapartners.com/2019/10/16/episode-178-database-design. Have fun on the SQL Trail!

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 down to discuss this policy option.   The show notes for today's episode can be found at http://sqldatapartners.com/2019/10/09/episode-177-lock-pages-in-memory. Have fun on the SQL Trail!

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 how the version of Power BI can affect storage.   The show notes for today's episode can be found at http://sqldatapartners.com/2019/09/25/episode-176-power-bi-storage-options/. Have fun on the SQL Trail!

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 to welcome Rick Lowe to the show and he gives his take on working with AWS. We explore what it means to move to the cloud, our experience helping companies get there, why companies would want to consider cloud options, and how you can keep up with all the craziness of new technologies in the cloud.   The show notes for today's episode can be found at http://sqldatapartners.com/2019/09/19/episode-175-migrating-to-the-cloud. Have fun on the SQL Trail!

18 Sep 201930min

24 Juli 20191min