Episode 255: Automate Complex CRUD with sp_CRUDGen

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 Kesä 201646min

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 Kesä 201633min

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 Touko 201630min

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 Touko 201637min

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 Touko 201629min

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 Touko 201630min

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 Huhti 201650min

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 Huhti 201635min