Episode 180: PolyBase in SQL Server 2019

Episode 180: PolyBase in SQL Server 2019

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!

Episoder(287)

Episode 39: Set statistics and StatisticsParser.com

Episode 39: Set statistics and StatisticsParser.com

Today on the SQL Trail I talk with Richie Rump, the podcaster, blogger, and now new hire at Brent Ozar. He and I discuss measuring query performance, using SET STATISTICS, and the story behind his Sta...

13 Apr 201630min

Episode 38: SQL Server 2016 Feature Review

Episode 38: SQL Server 2016 Feature Review

Compañeros! You heard rumblings about how awesome SQL Server 2016 is, right?  I talk with Rick Heiges about the wins he's seen for his clients using SQL Server 2016, including how one client's move fr...

6 Apr 201628min

Episode 37: PowerBI and the DBA

Episode 37: PowerBI and the DBA

In this episode of the SQL Data Partners podcast I sit with Patrick LeBlanc during SQL Saturday RVA. We chat about Microsoft PowerBI. PowerBI is a business intelligence tool that easily connects dispa...

30 Mar 201627min

Episode 36: SQL Server Virtual Machines in Azure

Episode 36: SQL Server Virtual Machines in Azure

You can host SQL Server on Azure Virtual Machines in a variety of configurations, ranging from a single database server to a multi-machine configuration.  In this episode of the SQL Data Partners Podc...

23 Mar 201631min

Episode 35: Position Yourself to Better Opportunities

Episode 35: Position Yourself to Better Opportunities

On Episode 35 of The SQL Data Partners Podcast, I talk with Philip Morgan of The Positioning Manual for Technical Firms. Philip’s book has influenced my work at SQL Data Partners, so I wanted to bring...

16 Mar 201634min

Episode 34: In-Memory Tables

Episode 34: In-Memory Tables

Hello, compañeros! You’ve heard of Hekaton and in-memory tables before, but what does in memory really mean for your database? Perhaps you have questions like I did, like how does in memory OLTP diffe...

9 Mar 201643min

Episode 33: From Developer To DBA

Episode 33: From Developer To DBA

Many developers will make the transition to the DBA role and in this episode I chat with Amy Herold about making that very move.  Amy started as a C#/.NET developer and moved into the database world a...

2 Mar 201629min

Episode 32: Up Your Game With PowerShell!

Episode 32: Up Your Game With PowerShell!

PowerShell, isn't that a Windows Administration tool?  This is certainly how it is positioned by Microsoft, but why should the DBA community give it more than a passing glance?  My guest is Mike Fal a...

24 Feb 201631min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
mikkels-paskenotter
foreldreradet
rss-strid-de-norske-borgerkrigene
treningspodden
rss-bisarr-historie
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
rss-sunn-okonomi
hverdagspsyken
tomprat-med-gunnar-tjomlid
gravid-uke-for-uke
fryktlos
hagespiren-podcast
level-up-med-anniken-binz
rss-kull
rss-bak-luftfarten