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 55: The new and improved SQL Server Reporting Services

Episode 55: The new and improved SQL Server Reporting Services

SQL Server reporting services hasn't changed in what seems like 10 years.  The rest of the reporting environment at Microsoft has seen some MEGA changes and it seems like we could use a few updates to...

3 Aug 201641min

Episode 54: An Executive Panel Interview

Episode 54: An Executive Panel Interview

What is the leadership of your company thinking about the future of data and the role you will play?  To help give some insight into that question we have and executive pane on episode 54.  Andrew Ros...

27 Jul 201638min

Episode 53: THE Argenis Fernandez interview on storage

Episode 53: THE Argenis Fernandez interview on storage

In Episode 53 Steve Stedman and I chat with THE Argenis Fernandez, storage guru and PASS Director-at-Large about what else? Storage.  Steve and I learn something new from Argenis every time we talk to...

20 Jul 201646min

Episode 52: Statistics are coming to the DB R you ready?

Episode 52: Statistics are coming to the DB R you ready?

Since Microsoft purchases the R language they have been baking it into their products and SQL Server is on the list.  SQL Server 2016 now has support for R and I know I have had people approach me abo...

13 Jul 201631min

Episode 51: A PowerShell Story

Episode 51: A PowerShell Story

I am always amazed at how people can use technology to solve different problems and in today's episode, my friend Jana shares with us a problem he solved with PowerShell.  The setup of this is differe...

6 Jul 201626min

Episode 50: SQL Server Settings

Episode 50: SQL Server Settings

As database administrators, we want to get as much performance as we can out of our SQL Servers.  Microsoft has provided a few knobs for us to tweak in the Operating System, the local security policy,...

29 Jun 201637min

Epsidode 49: Temp Tables VS Table Variables

Epsidode 49: Temp Tables VS Table Variables

When you code and you need to use a temporary object what do you use in SQL Server--temp tables or a table variable?  There is plenty of conventional wisdom out there and my guest Wayne Sheffield and ...

22 Jun 201635min

Episode 48: Is the Data Warehouse Dead?

Episode 48: Is the Data Warehouse Dead?

Over the last few years we have seen an explosion of new technologies and processes to manage data. Episode 48 asks the question--Is the Data Warehouse dead? I chat with MVP Tim Mitchell about the s...

15 Jun 201633min

Populært innen Fakta

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