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,493 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,362 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,596 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,393 reads
Managing many SQL Servers?
Here's an article from Rudy Panigas on how to more effectively manage multiple servers.
2009-01-15
8,934 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
6,192 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
11,007 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)
776 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...