Why did my execution plan change?

As a SQL Server DBA it is important to understand why and how the SQL engine works.  Understanding as much...

Bert & Pinal Troubleshoot a Slow Performing SQL Server

What happens when you run into performance tuning expert Pinal Dave?  Talk about how to troubleshoot a slow performing SQL...

Bert & Pinal Troubleshoot a Slow Performing SQL Server

Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave?  Talk about how to troubleshoot a slow performing SQL Server of course!
This week...

Bert & Pinal Troubleshoot a Slow Performing SQL Server

Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave?  Talk about how to troubleshoot a slow performing SQL Server of course!
This week...

Drive space check SQL server steps and scripts

AdvertisementsFollowing is the script used for drive space related issues.
--SQL 2000
-- select name,(size/128.0) as size_mb,* from master.dbo.sysaltfiles order by size_mb...

Random Pix from the 2018 PASS Summit

A few memories from me. First, a beautiful late arrival view.

My first session feels a little lonely

It started to fill...

Part 1: Predictive Modeling using R and SQL Server Machine Learning Services

To R or not to R? A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research,...

Part 1: Predictive Modeling using R and SQL Server Machine Learning Services

To R or not to R?
A few months ago, I asked myself an important question – which language to learn first...

Load and run custom T-SQL scripts in SSMS via Snippets

If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have...

Speaking At SQL Saturday DC

I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018. I will be presenting two sessions, What is Power...