SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2010

How Many DBAs Use the Maintenance Plan Wizard/Designer?

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… Read more

2 comments, 2,072 reads

Posted in SQL Aloha on 31 March 2010

An Introduction to SQL Server 2008 Audit

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… Read more

11 comments, 2,564 reads

Posted in SQL Aloha on 31 March 2010

SQL Server Social Group a Fresh Perspective on User Group Meetings

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… Read more

0 comments, 430 reads

Posted in SQL Aloha on 27 March 2010

Need to Persuade Your Manager or Co-Worker to Your Point of View?

At one time or another, each of us has been in a position where we need to persuade a manager, a fellow worker, or anyone for that matter, to our point-of-view. For example, you might want new server hardware, to upgrade an existing instance of SQL Server, the help of… Read more

0 comments, 511 reads

Posted in SQL Aloha on 18 March 2010

Want to Learn More About How to Master Microsoft Technologies?

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… Read more

0 comments, 1,263 reads

Posted in SQL Aloha on 18 March 2010

Start Planning to Attend devLINK 2010

devLink 2010 will be held in Nashville, TN August 5-7 on Lipscomb University. This three day, 140+ session event costs only $100, and is a great investment in your career. Registration for the event begins April 1, 2010, and you will want to register as soon as possible, as attendance… Read more

0 comments, 473 reads

Posted in SQL Aloha on 16 March 2010

PASS European Conference in April

While it is probably out of reach for most DBAs in the United States to attend, the PASS European Conference is a great opportunity for those DBAs in Europe, who are unable to attend the PASS Community Summit in United States, to improve their skills and make new contacts within… Read more

0 comments, 371 reads

Posted in SQL Aloha on 11 March 2010

Keeping Up with PASS

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… Read more

0 comments, 354 reads

Posted in SQL Aloha on 10 March 2010

An Introduction to Data Compression in SQL Server 2008

This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008.

There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups grow, and it never stops. The more data we have, the more work SQL… Read more

5 comments, 1,162 reads

Posted in SQL Aloha on 9 March 2010

Taking Advantage of SQL Server Tools

Reprinted from my editorial in Database Weekly.

An important question I think you should be asking yourself, when it comes to your professional development, is "Are You Taking Full Advantage of the SQL Server Tools Available to You?" I think it’s important enough that, when I make presentations at… Read more

0 comments, 316 reads

Posted in SQL Aloha on 9 March 2010

SQL Saturday Schedule Update

In January, I blogged about the upcoming SQL Saturdays for 2010, and since then, many more events have been scheduled, so I thought I would do a quick update. I wish I could attend more of the events, but so far, I am scheduled to speak at: 

SQLSaturday #31 –… Read more

2 comments, 556 reads

Posted in SQL Aloha on 5 March 2010

Please Provide PASS with Feedback on its Speaker’s Resource Pages

The PASS Program Committee is gearing up for the 2010 PASS Community Summit “Call for Speakers”, and it would like your feedback on its Speaker’s Resource and its Online Speaker Resources web pages. (Yes, I know the names of these pages are confusing, and this is something that will be… Read more

2 comments, 898 reads

Posted in SQL Aloha on 4 March 2010

How Not to Write a Resume Cover Letter

Although I am not currently a hiring manager, I occasionally receive unsolicited resumes from people looking for work. I just received a resume attached to an e-mail with the following cover letter. I have masked some of the content so that it is not personally identifiable, but otherwise, I have… Read more

1 comments, 1,386 reads

Posted in SQL Aloha on 3 March 2010

Winner of the February SQL Aloha Contest

In February, I started a monthly contest at www.bradmcgehee.com to help spur some sharing of best practices among DBAs. The February Question of the Month was:

What is one of your best practices for making full backups and transactions log backups of your production databases?

I want to thank everyone… Read more

0 comments, 350 reads

Posted in SQL Aloha on 2 March 2010

Tsunami in Paradise

Not a tsunami, but high surf on the Kohala Coast, near where we live.

We received the first phone call at 4:35 AM Saturday morning. My wife answered the phone, and I figured that it was a wrong number or some friend or family calling from the mainland, forgetting about… Read more

2 comments, 646 reads

Posted in SQL Aloha on 1 March 2010

March Question: What is the biggest mistake/problem you have ever found on a SQL Server instance, and how did you fix it?

Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). And don’t forget to enter your e-mail address when you post your response, so I can contact you if you win.

I’ll… Read more

9 comments, 916 reads

Posted in SQL Aloha on 1 March 2010