I agree, Event Notifications work for Deadlocks and so much more. Here's my blog posting on how I created a "generic" event notification service for all of my SQL...

Well written article. Have you looked at using Event Notifications since I believe the default trace was deprecated since the release of SQL 2012? Event Notifications can...

That's true Youri, but I'm pretty sure that was fixed at some point in the 2005 and 2008 builds. Somewhere between SP3 and SP4 for 2005 if I remember...

The only time I've seen an actual process take 6 months was right after we changed our reseller and leasing partners and had to have hardware in place on foreign...

How about using Powershell instead of creating linked servers to every SQL Server in your environment? I like the logic you have, a table with the list of servers,...

Filenames can contain a colon on the NTFS file system. It signifies an Alternate Data Stream and is perfectly valid. If you backup to a file that has...

What exactly do you mean when you say the fields would be dynamic? You can't dynamically set up field names in Pivot or UnPivot... they need to be defined.

UNPIVOT...

Great article! This is the type of information that DBA's should learn. Knowing that your DB Server is connected to a SAN / NAS system shouldn't be the...

I have taken a Merge Replication subscriber database offline to move datafiles while the snapshot was being applied, and once bringing the DB back online and restarting the Synchronization job...

I run something very similar as an SSIS package and pull all the log files from all my servers into a master table. I use xp_readerrorlog with the following...