Episode 47: Helping Your Data Find A Home
The expansion of data sets and increased expectations of businesses for analysis and modeling of data has led developers to create a number of database products to meet those needs. As data profession...
8 Jun 201646min
Episode 46: Unraveling Code
Have you ever looked at some tsql code and thought--How does even run? I know I have and it can be daunting to take a piece of code and review it for performance or to make a change to it. I enlist t...
1 Jun 201633min
Episode 45 Service Broker
Compañeros, we are going to get back into the engine this episode and go back to a feature that has been available since 2005--Service Broker. I chat with Wolf about how he uses it, the major compone...
25 Mai 201630min
Episode 44: Azure SQL Data Warehouse
Episode 44 takes us into a new service in the Microsoft cloud--Azure SQL Data Warehouse. While still in preview, the Azure SQL Data Warehouse looks to help level the playing field for organizations t...
18 Mai 201637min
Episode 43: Why is ETL so hard?
Why is ETL so hard? All we want to do is move data from system A to system B. Perhaps that is the problem, says my guest Rafael Salas, and more time should be given to thinking about the architectur...
11 Mai 201629min
Episode 42: Who made that change? Find out with Auditing
How did that get changed--do you ever get that question? In this episode I talk with Brad McKuhen about how you would answer that and how you might need more than just enabling the auditing feature i...
4 Mai 201630min
Episode 41: Index Maintenance
Compañeros, you know good care and feeding of your indexes is VITAL to a healthy database. In this episode of the SQL Data Partners Podcast, I talk to Sean McCown about the best practices for index m...
27 Apr 201650min
Episode 40: SQL Server Compression
In this episode of the SQL Data Partners Podcast I chat with Jason Brimhall, about SQL Server compression and his experience with it. He also answers your compression questions: Why is it a bad idea t...
20 Apr 201635min
