Will DBAs need to perform more complex financial analysis of the options they consider when building and tuning software systems? Steve Jones thinks it might be a skill needed in cloud computing.

Security Auditing Matching Up Logins And Users

by Brian Kelley

MSSQLTips.com

Security

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?

The Semantics of NULL in SQL Server 2008

by Adolfo J. Socorro, Ph.D.

SQLServerCentral.com

T-SQL

Learn the basics of NULL, what it is, and how to query for it in your databases from Adolfo Socorro. What NULL means, how to account for it, and how are expressions involving NULL evaluated

Tracy Hamlin, Exceptional DBA of 2010, on what it means to go the extra mile

by Press Release

SQLServerCentral.com

Exceptional DBA

An interview with the Exceptional DBA of 2010, Tracy Hamlin.

When To Touch

by Steve Jones

SQLServerCentral.com

Editorial

When can you modify a database that supports some third party product? Steve Jones has a few thoughts and warns you to be careful.

Executing SSIS Packages Using DTExec

by Additional Articles

Database Journal

Integration Services (SSIS)

Learn how the DTExec and DTExecUI utilities give you the ability to assign values to arbitrary properties of components within a SQL Server Integration Services package, when invoking its execution.

DMVs: are they worth the effort?

by Tony Davis

SQLServerCentral.com

Editorial

Many of the SQL Server DMVs still have a wild, unfinished feel but they are an incredibly useful tool for DBA, well-worth the sweat and toil required to learn and query them effectively.