DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.  Read more...

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...  Read more...

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.  Read more...

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...

In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...  Read more...

Use this script to search for SQL Server logins who use weak password  Read more...

Easily manage operations against large data sets, be able to stop and start operations at a whim and throttle them up or down to manage system performance.  Read more...

Learn the basics of Event Notifications from MVP Jonathan Kehayia. This article will show you how to create customized responses to events in SQL Server 2005/2008.  Read more...

New author Nigel Maneffa brings us a look at SQL Server 2008 and its new features, trying to decide if it's worth the upgrade.  Read more...

Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.  Read more...

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...  Read more...

The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.   Read more...

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...  Read more...

Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...  Read more...

From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.   Read more...

Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?  Read more...

Whether practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself and increase your knowledge.  Read more...

Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005? This question was asked on a technical discussion group. My reply follows.  Read more...