SQL Server Magazine

		Options
Simplify Large-Scale Server Shutdowns Issuing shutdown/restart commands to your entire server environment simultaneously can cause obvious problems. GroupedShutdowns.bat's two-tiered approach ensures that resources remain online on at least one node throughout the reboot process.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Don’t Let Resource-Intensive Sessions Consume All Your Resources and Time

The getMaxResourceConsumeSessions stored procedure lets you quickly identify the sessions that are consuming most of a SQL Server machine's resources.
By Eli Leiba 

How to Find Constants and Their Values

Because of the COM technology behind scripting objects, scripts don’t get access to any constants’ values embedded in those objects. Here are several ways to obtain those crucial values.
By Alex K. Angelopoulos 

Scripting Sequenced Shutdowns

This handy script takes the hassle out of multiple-server shutdowns by shutting down groups of servers sequentially and verifying that they've actually shut down and restarted.
By Dick Lewis 

WSH, Part 1: File Types

Get up to speed on the powerful WSH script-execution environment and the file types it uses.
By Bill Stewart 

Forcing VBScript Files to Run in CScript Mode

If you use the CScript script host often, you’ll want to check out the checkengine subroutine. This subroutine determines the script host currently being used and automatically changes it to CScript if necessary.
By James Lim 

Rem

Get answers to your scripting questions.
By Bill Stewart 

The Write Stuff

This simple VBScript function lets you write a string to a file without making you jump through hoops.
By Various Authors