SQLServerCentral - Scripts by Rudy Panigas

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 | 569 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,268 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 2012/12/25 | Source: SQLServerCentral.com | Category: documentation

Rating:

|

Discuss |

Briefcase | 3,345 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,275 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 | 2,926 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,461 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,536 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 | 2,861 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,225 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,054 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,167 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 2013/06/19 | Source: SQLServerCentral.com | Category: security

Rating:

|

Discuss |

Briefcase | 4,349 reads