Rohan_Kumar_keynote

SQL PASS Summit 2017: Day 1 Keynote Thoughts and Memories

Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going to see some great presenters this morning. Memories: my first Summit, that time I was too shy to say “Hi” to Mr. Denny The very first […]

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 […]