The-Death-of-SQL-Server-Service-Packs-Thumbnail

The Death of SQL Server Service Packs

SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs, and the process of updating SQL Server. No time to watch right now or read the transcript below? Listen in podcast format on iTunes , on Google Play, or plug this […]

love-and-hate-for-ssms

Love and Hate for SSMS

People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week’s episode, I talk about why people have such conflicting feelings about SSMS, and how to work it all out. No time to watch right now or read the transcript below? Listen in podcast format on iTunes , on Google […]

how do i analyze a sql server execution plan

How Do I Analyze a SQL Server Execution Plan?

A query is slow, and you figure out how to collect the query execution plan. Now what? In this video, I talk “big picture” about what execution plans are, what “cost” is, why to collect “compiled for” values, and the steps I take to analyze execution plans while performance tuning queries. No time to watch […]

do-i-need-to-master-powershell

Do I Need to Master PowerShell?

As a SQL Server DBA, do you need to be a master of PowerShell scripts? In this 9 minute episode, I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell. This episode is part of TSQLTuesday. This month, our topic is hosted by […]

Dear SQL DBA-SQL PASS Summit 2017-Thumbnail

SQL PASS Summit 2017: Why I’m Excited, and Tips on Attending

I’ll be attending and presenting at the SQL PASS Summit in Seattle Washington this year from Oct 31-Nov 3. In this week’s 19 minute episode, I share why I’m excited about going, and why I’ve purchased a seat for a pre-conference session. (Spoiler: pre-cons are awesome!) I also give my tips on how to get […]

Dear-SQL-DBA-How-Do-You-Stay-Motivated

How Do You Stay Motivated? (Dear SQL DBA Episode 47)

Over the years, readers have asked me: “How do you stay motivated?” Sticking with a learning plan, blogging, or becoming a public speaker isn’t easy. In this 15 minute episode, I share how I think about motivation and what keeps me going. No time to watch right now or read the transcript below? Listen on […]