Episode 23: IO, IO, It's Off to Tune We Go
If I were a betting man, I would wager your disk IO system is probably the biggest bottleneck in your SQL Server right now. Sure, there are lots of moving pieces, but if you can tame the IO situation...
23 Des 201528min
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 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
