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,325 reads
Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.
2009-06-18
6,513 reads
Learn how to get deadlock graphs from the SQL Server 2008 default system_health session with Extended Events.
2009-02-23
39,363 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,321 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,893 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers