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,564 reads
Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.
2009-06-18
6,562 reads
Learn how to get deadlock graphs from the SQL Server 2008 default system_health session with Extended Events.
2009-02-23
39,770 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,456 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,939 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Jl. Raya Mojoagung No.184, Pekunden, Kademangan, Kec. Mojoagung, Kabupaten Jombang, Jawa Timur 61482
Jalan Sholeh Iskandar.5-6 Ruko, Kel Blok B, RT.007/RW.007, Kedungbadak, Tanah Sareal, Bogor City, West...
Tambun, Kec. Tambun Sel., Kabupaten Bekasi, Jawa Barat
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers