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,166 reads
Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.
2009-06-18
6,474 reads
Learn how to get deadlock graphs from the SQL Server 2008 default system_health session with Extended Events.
2009-02-23
39,015 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,231 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,864 reads
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers