If your shop is even close to the typical Micosoft SQL Server environment there are several people that can (and do!) make changes to the production environment, a change management system is in place, that change management system uses Source Safe to store database scripts, and what's in Source Safe does not match what's on the SQL Server. This utility by Bill Wunder will archive your SQL scripts and DDL into Source Safe easily and efficiently. All for the price of $0 (yes, free!).

Pro Developer : This is Business

by Christopher Duncan

SQLServerCentral.com

Miscellaneous

In his travels, Christopher Duncan has come to recognize a great many similarities between programmers and musicians. Both have the fire, passion and soul of the artist. And all too often, both are aweful when it comes to the business end of things. Business - you know, that aspect of your work where they actually pay you at the end of the day?

Auditing Your SQL Server - Part 1

by Steve Jones

SQLServerCentral.com

Administration

A new series that examines how you audit activity in SQL Server. The first part looks at simple data auditing in a table.

Saving Space To Increase Performance

by Neil Boyle

SQLServerCentral.com

Performance Tuning

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.

A Lookup Strategy Defined

by David Sumlin

SQLServerCentral.com

Basics

Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.

Reusing Identities

by Dinesh Priyankara

SQLServerCentral.com

T-SQL

Ever wanted to know how to reuse identity values after they're deleted? In this example by Dinesh, he shows you two methods to reuse the wholes in identity rows.

Y2K Strikes Again

by Steve Jones

SQLServerCentral.com

T-SQL

Steve Jones recently got bit by a bug the reminded him of the Y2K fiasco. Read about the problem and how Steve solved the problem.

Free Utility : EnforcePass

by Additional Articles

SQLServerCentral.com

Administration

These sets of scripts will add minimum password enforcement when a login is created or its password changes.

Managing Jobs - Part 2

by Andy Warren

SQLServerCentral.com

Administration

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!

Squeezing Wasted Full Scans out of SQL Server Agent

by Bob Musser

SQLServerCentral.com

Administration

This article by new contributing member Bob Musser shows you how to reduce the amount of scans that SQL Server Agent does against databases. Not for the faint of heart.

Freeware : DDL Source Safe Archive Utility

Pro Developer : This is Business

Auditing Your SQL Server - Part 1

Saving Space To Increase Performance

A Lookup Strategy Defined

Reusing Identities

Y2K Strikes Again

Free Utility : EnforcePass

Managing Jobs - Part 2

Squeezing Wasted Full Scans out of SQL Server Agent

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

SWAG Saves the Day

Upgrading SQL Server Containers on the Laptop

Forums

Increase Deadlock Detection

A Tool is Better than a Script

Understanding Deadlock Victim Selection in SQL Server

Question of the Day

Increase Deadlock Detection