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!

Avsnitt(287)

Episode 247: Pushing the Boundaries or Pushing Your Luck

Episode 247: Pushing the Boundaries or Pushing Your Luck

IT workers will generally claim they like learning new technology—it is almost a required attribute.  Why then is bringing in new technology so hard?  In this episode, we explore how new technologies ...

15 Juni 202235min

Episode 246: Microsoft Build 2022 Announcements

Episode 246: Microsoft Build 2022 Announcements

While we continue to review the new features of the CTP preview of SQL Server 2022, we turn our attention to the recent Microsoft Build conference and talk about some of the announcements made. We tr...

8 Juni 202229min

Episode 245: Tooling Updates

Episode 245: Tooling Updates

SQL Server Management Studio (SSMS) version 18 was introduced to support SQL Server 2019 and in this episode of the podcast, we discuss some of the new updates available in SSMS and Azure Data Studio....

20 Apr 202239min

Episode 244: Extended Events vs SQL Server Audit

Episode 244: Extended Events vs SQL Server Audit

Who made that change?  It is one of those questions that can send chills down the spine of those responsible for databases.  In this episode, Josephine Bush talks with us about how we can use a combin...

30 Mars 20221h 6min

Episode 243: Choosing What Content To Focus On

Episode 243: Choosing What Content To Focus On

Conferences are on the uptick as COVID restrictions lift and we are excited for the upcoming year. After Eugene's return from SQLBits my thoughts revolved around what I wanted to learn this year at co...

16 Mars 202242min

Episode 242: Upgrading Your SQL Server

Episode 242: Upgrading Your SQL Server

SQL Server 2012 is end of life later this year. I feel too young for this to be happening—it seems like only last year SQL Server 2005 came out. In this episode of the podcast, we talk about upgradi...

2 Feb 202250min

Episode 241: Replicating Data with Azure SQL Data Sync

Episode 241: Replicating Data with Azure SQL Data Sync

Do you find you need to keep SQL Server tables in sync across multiple systems?  After several projects involving syncing data, we return to the topic of Azure SQL Data Sync with some real world examp...

20 Jan 202238min

Episode 240: Azure Synapse Link

Episode 240: Azure Synapse Link

Azure Synapse Link is a feature coming to SQL Server in the next release. While there are few details on what the new feature will look like, we discuss how this same service is implemented in other A...

5 Jan 202234min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
harrisons-dramatiska-historia
allt-du-velat-veta
nu-blir-det-historia
johannes-hansen-podcast
roda-vita-rosen
rss-viktmedicinpodden
rss-foraldramotet-bring-lagercrantz
sektledare
i-vantan-pa-katastrofen
not-fanny-anymore
sa-in-i-sjalen
rss-max-tant-med-max-villman
rss-sjalsligt-avkladd
rss-basta-livet
rss-traningsklubben
rikatillsammans-om-privatekonomi-rikedom-i-livet
alska-oss