Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Rudy Panigas

SQLServerCentral.com profile

   Items 1 to 15 of 15   
 

Analyzing Dangerous Settings in SQL Server

Analyzing dangerous settings in your SQL Server.   Read more...
By Rudy Panigas 2013/09/12 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 288 reads

SQL 2012 Always On Status Report

This script will produce a report on the status of the Always On replication.  Read more...
By Rudy Panigas 2013/03/05 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,085 reads

Analyzing Dangerous Settings in SQL Server

Analyzing dangerous settings in your SQL Server.   Read more...
By Rudy Panigas 2013/09/12 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,514 reads

Top 10 Wait State Issues Reporter

This script will produce the top 10 wait state issues along with their descriptions.  Read more...
By Rudy Panigas 2012/11/22 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,526 reads

SQL Server Documenter

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.  Read more...
By Rudy Panigas 2014/01/02 | Source: SQLServerCentral.com | Category: documentation
Rating: |  Discuss |   Briefcase | 5,224 reads

Calculate the values for MAX Memory for SQL Server

Use this script to calculate MAX memory setting on a dedicated SQL server.   Read more...
By Rudy Panigas 2012/01/27 | Source: SQLServerCentral.com | Category: max memory setting
Rating: |  Discuss |   Briefcase | 2,690 reads

Query Active Directory to Display Login Information

Query Active Directory to get information on user logins.  Read more...
By Rudy Panigas 2011/05/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,066 reads

Show SQL authentication login information

View login information for all accounts that use SQL authentication.   Read more...
By Rudy Panigas 2011/05/12 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,587 reads

SQL Server Port Number Identifier

Find SQL server port number for SQL 2000, 2005, 2008 and 2008 R2  Read more...
By Rudy Panigas 2011/01/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,634 reads

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.  Read more...
By Rudy Panigas 2010/11/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,010 reads

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.  Read more...
By Rudy Panigas 2010/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,260 reads

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,218 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  Read more...
By Rudy Panigas 2009/05/08 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 1,232 reads

Remove SQL Logins from All Databases and SQL Server

Locate and remove/delete user logins from all databases and even SQL server.  Read more...
By Rudy Panigas 2008/08/08 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,731 reads
   Items 1 to 15 of 15