Under which user your SQL Agent Job run : SQL Agent Service Account or SQL Agent Job Owner ?

Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account...

#SQLSaturdayExeter–Superb SQL Server Event

#SQLSaturday194 is coming to Exeter on the 8th – 9th March.

What is SQL Saturday?  The brain child of Steve Jones,...

Rename the SQL Server Management Studio shortcut

Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...

Day 10 of 31 Days of Disaster Recovery: Monitoring for Corruption Errors

31 Days of Disaster Recovery
It’s day 10 of my 31 Days of Disaster Recovery series, and I want to...

DBCC Memorystatus SQL2012 – A quick observation for node Process/System Counts

This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the...

SQL Bits XI Registration is Now Open

Hi all,
registration to attend SQL Bits is now open.
http://www.regonline.com/Register/Checkin.aspx?EventID=1163518
There’s a 600 capacity limit and they anticipate it to fill rather quickly. More details can be found here:
http://sqlbits.com/
Hope to see...

Talking on Purpose

Last year I stepped into the intimidating (and slightly effervescent) waters of the consulting world, and found great success. This...

MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade

After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only...

SQL Server Virtualisation and Consolidation

Come and join me in London this March for a 3 day course on SQL Server virtualisation and consolidation.The course...

sp_Blitz, v16, on SQLServerCentral

Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and...