SQL Server Service Check Utility
Script will display current status of SQL server services and even show if not installed. Works on SQL 2005,2008 2008R2. Both 32 and 64 bit servers.
2010-11-15 (first published: 2010-11-09)
3,222 reads
Rudy Panigas
T-SQL generator for sp_configure
The purpose of this code is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from.
2010-10-14 (first published: 2010-10-05)
1,346 reads
Pre Check List for 64 BIT SQL Server 2008 Cluster Installation
My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.
2009-12-31
7,160 reads
Cluster Information
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
2009-05-08 (first published: 2009-04-15)
1,325 reads
Managing many SQL Servers?
Here's an article from Rudy Panigas on how to more effectively manage multiple servers.
2009-01-15
8,609 reads
DAC - What to Execute when Connected?
SQL Server Issues? Connect with Dedicated Administrator Connection (DAC), then what? Execute this stored procedure to get some understanding on what is going on in the SQL server.
2008-12-19
5,869 reads
Remove SQL Logins from All Databases and SQL Server
Locate and remove/delete user logins from all databases and even SQL server.
2008-08-08
5,705 reads
Execution of Code on Multiple Servers Remotely
Do you have more than 10 sql servers you must manage? Most DBA s do, I have over 120 sql instances to manage. Before I used to use ISQL/OSQL in a batch to execute a command on all these instances. It works but not very nice. Below is the code I use to collect information […]
2006-12-28 (first published: 2006-10-16)
732 reads
Blogs
SQL Server Quick Tips
By Bert Wagner
Earlier this year I made a series of videos that were played before the...
The 2019 State of DevOps Report–Webinar
By Steve Jones
Tomorrow I get to chat with another giant in the world of DevOps: Jez...
An Effective Solution to Resolve SQL Database Corruption
By nelsonaloor
I am a SQL Administrator and today I will share my experience about an...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Solve HASH MATCH in query plan
Hi, This is SQL Server 2016, by the way. I'm trying to optimize a...
Dynamic - Row Level Masking.
Hi, I have looked into Dynamic Data Masking and Row Level Security, Is there...
Ask SSC