Learn how to use SQL Server Agent alerts and jobs to fix policy incompliance automatically.

SQL Code Layout and Beautification

by Additional Articles

SimpleTalk

Naming Standards

William Brewer takes a look at the whole topic of SQL Code layout and beautification, an important aspect to SQL programming style. He concludes that once you are tired of laying SQL out by hand, you had better choose a tool with plenty of knobs to twiddle, because nobody seems to agree on the best way of doing it.

Innovation

by Steve Jones

SQLServerCentral.com

Editorial

This Friday's poll from Steve Jones looks at the value of marketing and innovation.

SQLServerCentral Friday Crossword No 2

by Ravi Nangunoori

SQLServerCentral.com

crossword

Pit your wits against the SQLServerCentral.com Friday crossword...

The Hazards of IT

by Michael Coles

SQLServerCentral.com

Miscellaneous

Are you taking care of yourself as an IT professional? We try to cover all aspects of your SQL Server career here, not just the technical stuff. Longtime SQL Server guru Michael Coles brings us some health tips in an interview with Dr. Jerry Sanders

Upgrading SQL Server 2000 DTS Packages to SSIS

by Brian Knight

SQLServerCentral.com

Integration Services (SSIS)

If you're like Brian Knight, you probably have dozens if not hundreds of DTS packages running around that you're terrified to touch. SQL Server 2005 has some interesting methods to upgrade your packages to SSIS with minimal effort. This article shows you a few ways that you can use to upgrade and some of the drawbacks.

Database Audit Logs, Joel on Software, Code Handouts, and More

by Additional Articles

Microsoft MSDN

Database systems like Microsoft® SQL Server® have long supported triggers—developer-created scripts that automatically execute after or in place of INSERT, UPDATE, and DELETE statements. Because triggers can access the data modified by INSERT, UPDATE, or DELETE, they are an excellent tool for recording data changes to an audit log.

Lengthy SQL Server Queries Will Consume Your CPU

by Additional Articles

MSSQLTips.com

Performance Tuning

The SQL (Structured Query Language) language is a declarative language that became the "Data Language" used for describing "what I need" and "where to fetch it from" in most organizations. OOP (Object Oriented Programming) languages became the most common practice among developers widely adopted by R&D organizations around the world. So how do we bridge the gap?