SQL Server Magazine

The Event Log Query Utility

Don't Let Daylight Saving Time Sneak Up on You

By simply double-clicking GetDLSDates.vbs, you can get a reminder of when daylight saving time begins and ends in the current year. Without having to change any code, this script will work the same year after year.

Optimize the Size of Your Indexed Integer Columns

Together, the suggestIntType and scanIntIndex procedures search for indexed integer columns in a database and determine whether the optimal data type is used for those columns.

Stored Procedures Work in Concert to Import and Export Data

Here’s a simple yet generic solution for exporting or importing data. This solution consists of two stored procedures: BCPObject and ExpOrImpDB.

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.

Boost Support for Large Object Data Types

Enhancements to the MAX specifier in SQL Server 2005 let you manipulate large object data types in a much easier and more flexible fashion than in previous SQL Server versions.

Extract Information from a Web Page

If you need just one item from a page and have consistent unique text before and after the item, you can use the GetWebXml, CleanTaggedText, and GetSubString functions to get the information.

Gather Failed Logon Attempts

Here's a way to quickly discover failed Kerberos-related logon attempts on your DCs without having to go to each machine individually.

Querying Installed Software Remotely

Simplify software audits by easily and quickly querying a registry subkey to display a list of installation applications and hotfixes.

Home-Brewed Hardware Inventory

Use this two-pronged solution to create rich, verbose hardware inventory reports.

How the Inventory Agent Works

Get information about how HrdWrInv.vbs collects hardware inventory data.

How the Report Agent Works

Get information about how BuildReport.vbs creates an inventory report.

Using Excel to Parse the Input File

Use Excel to overcome the shortcomings of CSV files.

AD and WMI Reporting

Don't settle for simply extracting information from AD or WMI. Use Csvde, the Scriptomatic, and Excel to create clear and easy-to-read reports.

Formatting the Reports

Learn how to determine which code to use to automate Excel from within VBScript.

Event-Log Auditing, Part 2

Use this script to generate logon and logoff reports for a particular user for a specified time interval.

Event-Log Auditing, Part 1

Auditing event logs is a tedious but important task. This simple script will make the job easier by automating event log archival

Testing Replication with a Simple Script

Use this simple Perl script to test replication and verify data flow among domains.

Modifying the URL Checker to Run Automatically

In “Creating a URL Checker for Databases” (June 2000), you learned how to use Visual Basic (VB) to create an application that tests URLs. Now learn how to modify that application to run either interactively from a desktop or from the command prompt.

Automating Excel to Create Trend Charts

Learn how you can create a Windows Script Host (WSH) script that regularly gathers data from Windows 2000's (Win2K's Active Directory (AD), updates a Microsoft Excel 2000 spreadsheet with that data, and creates charts showing trends.