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
3,800 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)
8,452 reads
2018-01-26 (first published: 2015-10-15)
7,114 reads
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
9,143 reads
A checklist to help optimize the performance of SQL Server
2014-12-29
8,675 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)
8,199 reads
2013-09-17 (first published: 2013-02-08)
649 reads
2013-09-12 (first published: 2013-02-08)
1,869 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,795 reads
This script will produce a report on the status of the Always On replication.
2013-03-05 (first published: 2013-02-08)
4,013 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...