Episode 22: Eight Years of sp_whoisactive
In what has to be one of the most downloaded SQL Server scripts on the planet with over 73,000 downloads, sp_whoisactive has been providing active session information to data professionals for eight y...
16 Des 201530min
Episode 21: Azure Data Factory
As one of the newest Azure offerings, Azure Data Factory can at first thought be compared to SSIS. I don't think we are quite there yet with the comparisons; however, I talk with MVP Reza Rad and dis...
9 Des 201531min
Episode 20: the Role of Mentors
We all start somewhere and if you can find a mentor who will help you on your way by pointing you in a direction you had not considered, you are a lucky person indeed. This episode I chat some fellow...
2 Des 201534min
Episode 19: How Solid State Disks Can Help SQL Server
A hard drive is a hard drive, right? Storage has come a long way, but is probably still the biggest bottleneck in your system. Solid State Drives (ssd) have changed the rules in terms of performance...
25 Nov 201534min
Episode 18: BIML
I learn stuff every day. In this episode I tackle a new subject for me and one I am hearing a lot about--BIML. BIML is a markup language you can use to build your SSIS packages. I met up with Bill ...
18 Nov 201526min
Episode 17: Partitioning
Do you find you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered...
11 Nov 201525min
Episode 16 SQL Server Agent
I learn things every day. One of the great things about the SQL community is the willingness to share their learning experiences and today's episode is an example of this. I chat with Mark Wilkinson...
4 Nov 201529min
