SQL Server – DDL vs. DML Triggers

Although, DML and DDL triggers are used for different purposes, there are some similarities and differences between these.
 
Similarities between DDL...

The Importance of Regular Blogging

Between my old website, which I started back in 2007 (which has since disappeared) and my blog, which I switched...

Unsubscribing

One of the things I’ve been doing lately is pruning (again) the number of newsletter type emails I get. Some...

Denali – Day 27: System Center Advisor (aka ‘Atlanta’)

Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis...

Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)

Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent)   If you are good with: Xls Pivot table Power...

New built-in functions in SQL Server 2012

Introduction:
Microsoft SQL Server 2012 Release Candidate 0 introduces 14 new built-in functions. These functions will make the migration path for...

SQL Saturday #132 Pensacola and Wheeling, WV PASS UG

I have 2 upcoming speaker opportunities in June and am very excited about presenting this material.
June 9th is in...

Backup duration statistics

Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...

Building a Presentation Map

This idea came up during a critique of a presentation. I may have re-invented (or re-labeled) something that is already...

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

MDS and Best Practice Analyzer new features were introduced in sql...