Explain database risk to managers by turning backups, patching, and capacity into clear impact, likelihood, cost, and action choices.
SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON – A Transactional Behavior
When is IGNORE_DUP_KEY = ON useful? Jacob Sebastian and I built an example that shows its transactional behavior when you insert only nonduplicate rows.
SQL SERVER – SQL Server RDL Specification
The RDL Specification describes Report Definition Language, the XML schema behind SQL Server reports. I list the 2000, 2005 and 2008 versions.
SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database
My students got Msg 262, SHOWPLAN permission denied, when they tried to view an execution plan. One GRANT SHOWPLAN statement fixes it.
SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON
What does IGNORE_DUP_KEY = ON do on a unique nonclustered index? Duplicate inserts give a warning instead of an error, and my example shows both options.
SQLAuthority News – TechDays Session at Infosys Mysore 2009 – Change Data Capture and PowerPivot
Notes from my TechDays session at Infosys Mysore in December 2009, where I presented Change Data Capture and PowerPivot to a smart, curious crowd.
SQL SERVER – Find Location of Data File Using T-SQL
A short T-SQL script that finds where your SQL Server Data File folder is on disk, using master.sys.master_files. Handy when you forget where the files live.