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
4,044 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,685 reads
2018-01-26 (first published: 2015-10-15)
7,176 reads
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
9,492 reads
A checklist to help optimize the performance of SQL Server
2014-12-29
8,727 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,261 reads
2013-09-17 (first published: 2013-02-08)
668 reads
2013-09-12 (first published: 2013-02-08)
1,884 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,845 reads
This script will produce a report on the status of the Always On replication.
2013-03-05 (first published: 2013-02-08)
4,060 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers