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...

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

A quick how-to on configuring SQL Server Agent alerts to manage file space usage.  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...

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...

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...

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...

Is there a way I can automate a file deletion process from within SQL Server?  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...