Episode 276: Dynamic SQL and Testing in Isolation

Platform as a service has finally arrived to Microsoft's Azure offering.  With the release of Azure SQL Database Managed Instances--quite the mouthful--there is now an option to explore database servi...

24 Okt 201838min

Today we, the SQL Data Partners team, celebrate our 150th podcast episode! We introduce ourselves, talk about what we're doing, our goals for the coming year and answer the SQL Family questions. Come ...

19 Okt 201831min

Do you ever feel like you have too many databases to manage?  Managing lot of databases can get tricky and in this episode we explore some of the techniques you can use when you need to manage lots of...

11 Okt 201836min

SSRS is great -- it comes with SQL Server, provides quite a bit of functionality, but sometimes doesn't always perform well. In this episode we welcome back Bert Wagner as he chats with us about some ...

3 Okt 201839min

Security is always important to data folks and when a new feature like Always Encrypted comes along, it gets your attention. In this episode, we discuss this feature introduced in SQL Server 2016. We ...

19 Sep 201835min

So what is SQL Trail all about? In this episode we invite our MVPs to discuss some of the topics they are ready to share on SQL Trail. We know there are lots of options for training and networking -...

12 Sep 201823min

In this episode we finish up our conversation with Jason and Cathrine and talk about how they keep up with all the changes in data conversions.  The advent of Azure services is great, but can be trick...

5 Sep 201825min

Moving data with SSIS is a forgone conclusion for most of us -- it is part of SQL Server, it has a interface we are somewhat familiar with, and connects to lots of common data sources like csv, excel,...

29 Aug 201844min