Ever need to automatically stop a long running job? Ever need to find which named Schedule is the currently running version of your job? There's simple code that'll let you find out.  Read more...

Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it through three steps by writing T-SQL scripts, adjusting configuration files and the change log, before generating a full build script containing all schema objects.  Read more...

Automate test database restorations from your production system.  Read more...

This article will show you how to automatically generate insert, update, and delete procedures for tables in your database  Read more...

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.  Read more...

This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.  Read more...

This script helps you to constitute insertion procedures for tables in a millisecond.  Read more...

A quick how-to on configuring SQL Server Agent alerts to manage file space usage.  Read more...

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...

Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.  Read more...

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...

Steve Jones talks about the idea of an automated DBA and disputes the notion that it will come to pass anytime soon.  Read more...

Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go  Read more...

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.   Read more...

Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it   Read more...

Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go  Read more...

This article will show you how to automatically generate insert, update, and delete procedures for tables in your database  Read more...

Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.  Read more...

A way to handle application releases involving multiple scripts and/or multiple databases.  Read more...