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,453 reads
2018-01-26 (first published: 2015-10-15)
7,118 reads
A checklist to help optimize the performance of SQL Server
2014-12-29
8,677 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 article will show you how to install SQL Server on to a Windows Core Server host.
2011-11-15
4,307 reads
Using linked connections you can collect system information on your Oracle server from SQL server.
2011-06-06
3,456 reads
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
2011-03-11 (first published: 2009-11-03)
30,450 reads
How to rebuild your master database quickly and safely.
2011-02-03
12,284 reads
My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.
2009-12-31
7,596 reads
Here's an article from Rudy Panigas on how to more effectively manage multiple servers.
2009-01-15
8,934 reads
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
Comments posted to this topic are about the item The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers