Database Snapshots is an Enterprise feature introduced in SQL Server 2005, and represent a database and … Database Snapshots IntroRead more
Management Studio
Multi Server Query
In SQL Server Management Studio, it is possible to execute a multi server query against several … Multi Server QueryRead more
Script schema and data
Ever needed to generate insert statements for the data in a table? This feature is actually … Script schema and dataRead more
Line numbers in t-sql error messages
When you run scripts in SSMS and get an error, the error references a line number … Line numbers in t-sql error messagesRead more
Zero footprint Server/Database DDL Trigger
Aaron Bertrand has written a great introduction to server/database DDL triggers in his article SQL Server … Zero footprint Server/Database DDL TriggerRead more