Audit Database Offline Events

Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we...

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