SQL Aloha

Articles

Take a look at articles I’ve written on a range of SQL Server database administration and career topics. Clicking each article will usually take you to a page outside of bradmcgehee.com.

Articles categories:
SQL Server | Database Maintenance | Indexing | Performance Tuning

Articles about SQL Server

Management Studio Improvements in SQL Server 2008

SQL Server Management Studio in SQL Server 2005 has faced some tough criticism from DBAs over the years. Microsoft has tried hard to make up for the troubles of the past, bringing a multitude of improvements in SSMS 2008 that I go through in this article. Read more…

Introduction to Policy-Based Management in SQL Server 2008

If SQL Servers are treated as ‘islands’, each with their own subtly different configurations, managing multiple instances of them can be a frustrating experience for the DBA. SQL Server 2008’s policy-based management aims to help us enforce policies for SQL Server instances throughout an organization. In this article, I look at what policy-based management is, how to implement it, and how to check it is running. Read more…

Articles about Database Maintenance

Database Maintenance Plans in SSMS: An Overview

SQL Server provides two tools, built into SSMS, which make the process of creating database maintenance plans much easier and faster: the Maintenance Plan Wizard and the Maintenance Plan Designer. In this article, I’ll examine what these critical tasks are, and discuss the pros and cons of using the Wizard and Designer to implement them, in contrast to using of T-SQL or PowerShell scripting. Read more…

Brad’s Sure DBA Checklist

We DBAs are busy people. Sometimes all we need (and want!) is a handy reminder of best practices, dos and don’ts for our SQL Servers. So I’ve put together a comprehensive checklist that covers a wide range of best practices, including those for the general DBA, high availability, performance tuning and application design. Read more…

Articles about Indexing

Brad’s Sure Guide to Indexes

There are many different types of index that exist in SQL Server. In this guide, I look at what a table and index are, before exploring how SQL Server 2005 and 2008 indexes work, including those that are filtered, special and compressed. Read more…

Don’t Forget to Maintain Your Indexes

So long as data is inserted, updated and deleted from tables, indexes will become fragmented over time, and performance will suffer. Index maintenance is vital to keeping databases and their users happy. In this article, I go through the key index maintenance tasks and identify more essential areas that are a DBA’s duty to maintain. Read more…

Articles about Performance Tuning

SQL Server 2008: Performance Data Collector

SQL Server 2008’s Performance Data Collector lets us create a central repository to store performance data and includes three built-in Data Collection sets that can be used to collect and store this data. Three built-in reports can then be used to access the stored data, so we can identify and troubleshoot SQL Server performance problems. Want to find out how the Performance Data Collector works and how it can help you? Read more…

---