Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.
2009-12-17
10,482 reads
Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.
2009-06-18
6,550 reads
Learn how to get deadlock graphs from the SQL Server 2008 default system_health session with Extended Events.
2009-02-23
39,636 reads
When excessive blocking occurs in SQL, performance degrades. Learn how to use the Blocked Process Report to rapidly resolve excessive blocking scenarios in SQL Server 2005/2008.
2008-10-30
22,397 reads
This short article shows how to run the same query against multiple servers and aggregate the results into one set with SSMS 2008
2008-08-14
5,917 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
You want the short answer? Well, the only antidote to knowledge stagnation is probably...
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
Comments posted to this topic are about the item Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers