How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know. This editorial was originally published on Feb 28, 2008. It is being re-run as Steve is on holiday.

Monitoring and Recording DDL changes on SQL 2005 (NARC)

by James Greaves

SQLServerCentral.com

Auditing

Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.

Practical Methods: Naming Conventions

by Michael Lato

SQLServerCentral.com

Naming Standards

Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.

Check List for Performance Optimisation in SQL Server Analysis Service 2005

by Additional Articles

SQL Server Performance

Analysis Services (SSAS)

This article is a step-by-step checklist to help ensure that you are obtaining the maximum performance possible from SQL Server Analysis Services.

Enabling Drillthrough in Analysis Services 2005

by Additional Articles

TechNet Blogs

Analysis Services (SSAS)

Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.

My Projects Have Never Failed

by Janet Wong

SQLServerCentral.com

Miscellaneous

As a SQL Server DBA or developer, how do you measure the success of your projects? What about your users? Here is an interesting look by Janet Wong at a few of her projects and how their success was perceived. See if any of your experiences are similar.