T-SQL Tuesday #73 - Not Running CHECKDB is Naughty!

This month T-SQL Tuesday is hosted by Bradley Balls (blog/@SQLBalls) and his topic of choice is “Naughty or Nice.”
(If you...

What Do You Mean There is No Current Database Backup?!?

Yet another late night/early morning tale...

The LOG backups for multiple databases on a server failed overnight (not all databases, but...

We Are All Responsible

Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):

PASS Anti-Harassment Policy ReminderIt is unfortunate that I have...

CHECKDB - The database could not be exclusively locked to perform the operation

…so the job failed….again…you know the one – that darn Integrity Check job: Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete ...

SQL Server Training

Brent Ozar’s group (http://www.brentozar.com/) just announced a pretty crazy set of “Black Friday” deals:
http://www.brentozar.com/archive/2015/11/announcing-our-2015-black-friday-sale-on-sql-server-training/
Insane sales if you can be one...

T-SQL Tuesday #72 - Implicit Conversion Problems

This month T-SQL Tuesday is hosted by Mickey Steuwe (blog/@SQLMickey) and her topic of choice is “Data Modeling Gone Wrong.”
(If...

PASS Summit 2015 Recap

Last week was the annual PASS Summit in Seattle.  The Summit is the predominant educational and networking event for SQL...

Deleting Files Older than X Hours with PowerShell

(aka "OMG I can't believe I am actually finally writing a #PowerShell blog post").

--

I currently have a situation at a...

Availability Groups - Where Did My Disks Go?

The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!
--At a client recently two availability groups on...

POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!

UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11...