SQL Server System Audit Report Rudy Panigas, 2018-05-25 (first published: 2016-02-02) With every technology, security is in the forefront of the minds of professionals around the world. Ensuring that your SQL Server is secure is the job of every Database Administrator (DBA). The DBA(s) needs to configure the system to minimize the “attack surface” (reducing […]
2019-04-18
2,681 reads
Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.
2019-04-11 (first published: 2016-02-02)
7,937 reads
2018-01-26 (first published: 2015-10-15)
6,871 reads
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
7,945 reads
A checklist to help optimize the performance of SQL Server
2014-12-29
8,584 reads
This script was designed to provide you with all the information needed to rebuild your server in case of a disaster. Current version work with 2005, 2008, 2008R2 and 2012.
2014-09-30 (first published: 2012-09-21)
7,982 reads
2013-09-17 (first published: 2013-02-08)
628 reads
2013-09-12 (first published: 2013-02-08)
1,814 reads
This article will show you how to scan SQL Server Error Logs with ease and track important information that is stored there.
2013-09-06 (first published: 2011-02-14)
15,622 reads
This script will produce a report on the status of the Always On replication.
2013-03-05 (first published: 2013-02-08)
3,774 reads
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty...
I've noticed in one of our applications a cursor uses operation 40 and that...
Ok, need someone to talk me off the cursor ledge on this one. I...
Comments posted to this topic are about the item Better Communication Through Less Messaging
Ask SSC