Audit Database Offline Events

Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when...

T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108

Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a...

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...