Monthly Archives: March 2010

How Many DBAs Use the Maintenance Plan Wizard/Designer?

Posted on by

image When I wrote my most recent free eBook, Brad’s Sure Guide to SQL Server Maintenance Plans, some of the DBAs I know asked me why I wrote it. After all, “real” DBAs don’t use the Maintenance Plan Wizard/Designer built into SQL Server 2005/2008 Management Studio (SSMS) to maintain their databases, they write Transact-SQL or PowerShell scripts instead. The reason I wrote the book is because there are many DBAs, many more than you think, who use this tool.

In a recent survey on my website (www.bradmcgehee.com) I conducted the following poll:

image 

Continue reading →

An Introduction to SQL Server 2008 Audit

Posted on by

Excerpted from Brad’s Sure Guide to SQL Server 2008, which is available as a free eBook.

Previous versions of SQL Server have included a variety of built-in ways to audit activity inside SQL Server. These included:

Login Auditing: Only tracks user login successes and/or failures. Results are sent to the OS Application Log.

SQL Server Profiler (SQL Trace) Audit and Related Events: Profiler includes over 40 specific audit events, and over 130 additional events that can be traced. Results are stored in trace files.

DDL Triggers: DDL triggers can be added to a database to identify when any DDL event occurs.

C2 Audit Mode: This former auditing standard (now superseded by Common Criteria Compliance) uses SQL Trace to capture audit events, which are stored in trace files.

Common Criteria Compliance: A new international auditing standard which also uses SQL Trace to capture data, which are stored in trace files.

None of the above methods offer much granularity, most are not easy to administer, and with the exception of Login Auditing, they can add a large amount of overhead to running SQL Server, hurting its performance.

To help overcome these problems, SQL Server 2008 includes a feature called SQL Server Audit. SQL Server 2008 Enterprise Edition includes all of the features described in this article, which includes both the SQL Auditing Foundation and Fine Grained Auditing. SQL Server 2008 Standard Edition only provides the SQL Auditing Foundation. Continue reading →

SQL Server Social Group a Fresh Perspective on User Group Meetings

Posted on by

IMG_0877_dxo-2

The Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type of boat) used to navigate the Cam.

I must have attended at least 25 different SQL Server and .NET user groups over the past couple of years, and most of them have a familiar format: food and drinks combined with some socializing, a formal presentation, and a prize drawing. I have seen a few other minor variations, but it is hard to tell one user group meeting from another. That is, until I recently spoke at the SQL Server Social Group in Cambridge, England this past month.

Continue reading →

Want to Learn More About How to Master Microsoft Technologies?

Posted on by

If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This website includes blog, forums, and an event calendar to keep you up to date on how Microsoft can help you in your career. While anyone can view the site’s contents, you have to register in order to participate in the forums and social networking aspects of the website.

Continue reading →

Keeping Up with PASS

Posted on by

image I have often found it a little hard to keep up with PASS news, but after a little research, I found out that PASS offers many different sources of information about its activities, but it sometimes can be hard to find, as its news and information is dispersed over many different locations. If you want to keep up with what PASS is doing, then check out these links.

Continue reading →