Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2010

Besides Being a DBA, Do You Also Happen to be an Exchange Administrator?

I know a lot of DBAs fall into the category of part-time DBAs, because they work in small IT shops and they often have to wear many hats. I have actually never shared this secret before, but I was an Exchange Administrator before became becoming a full-time DBA, back in… Read more

0 comments, 209 reads

Posted in SQL Aloha on 23 April 2010

Results of Microsoft Certification Poll

In a recent poll at www.bradmcgehee.com, I asked website visitors if they had any Microsoft SQL Server certifications, and if so, which certification. I also asked how many people who weren’t certified wanted to become certified, and how many people who weren’t certified didn’t have any interest in… Read more

3 comments, 449 reads

Posted in SQL Aloha on 23 April 2010

An Introduction to SQL Server 2008 Change Data Capture

This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008, which can be downloaded here.

As DBAs, one of our goals is to separate OLTP (On-Line Transaction Processing) and OLAP (On- Line Analytical Processing) activity, preferably onto different servers. This is because performing… Read more

0 comments, 963 reads

Posted in SQL Aloha on 22 April 2010

Missing European PASS

As most of you know, the Icelandic volcano has played havoc with travel plans for speakers coming from the US to speak at European PASS, and many of us will not be able to attend in person, including myself. Fortunately, I have found someone to take over my presentations for… Read more

0 comments, 432 reads

Posted in SQL Aloha on 19 April 2010

Missing European PASS (Updated)

As most of you know, the Icelandic volcano has played havoc with travel plans for speakers coming from the US to speak at European PASS, and many of us will not be able to attend in person, including myself. Fortunately, I have found someone to take over my presentations for… Read more

0 comments, 180 reads

Posted in SQL Aloha on 19 April 2010

Three Speaking Events in Six Days

AlantaMDF SQL Server Users Group. Photo courtesy of www.sqlvariant.com.

I have just finished up a three event speaking tour that, which unfortunately, should have been a four event tour, but my flight to Germany (via London) was cancelled, and I was unable to attend European PASS as I had… Read more

5 comments, 256 reads

Posted in SQL Aloha on 18 April 2010

SQLBits to be Held this Friday in London

Just as a reminder, if you have registered to attend SQLBits this Friday, April 16, at the Church House Conference Centre in Westminster, London, be sure to confirm your registration if you have not done so already. And if you have registered and been confirmed, but now can’t attend, please… Read more

0 comments, 163 reads

Posted in SQL Aloha on 14 April 2010

How to Avoid Some Common Developer and DBA Mistakes

In March, I ran a Question of the Month that asked, “What is the biggest mistake/problem you ever found on a SQL Server instance, and how did you fix it.” There were so many great responses that I thought I would summarize many of them here, as this list provides… Read more

1 comments, 492 reads

Posted in SQL Aloha on 14 April 2010

Northwest Arkansas TechFest Set for July 18

David Walker, the organizer of the popular Tulsa TechFest, is organizing the first annual NWA TechFest, to be held Thursday, July 18, in Rogers, AR. The event will cover numerous Microsoft technologies, including SQL Server. The call for speakers is now open, and registration will begin… Read more

0 comments, 165 reads

Posted in SQL Aloha on 11 April 2010

Learn How Vendors Price Their Software

As DBAs, we are often put in the position of purchasing software from third-party vendors. If you are like me, you are probably amazed at the wide variation in software prices, and how the price of a product seems to bear little relationship with its actual cost. For example, why… Read more

0 comments, 457 reads

Posted in SQL Aloha on 9 April 2010

24 Hours of PASS Registration Now Open

Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00 GMT on May 19, and include 24 live presentations on a wide variety of topics, with a special emphasis on SQL Server 2008 R2.

Speakers include Adam Machanic, Andy… Read more

1 comments, 201 reads

Posted in SQL Aloha on 6 April 2010

Winner of the March SQL Aloha Contest

The March SQL Aloha contest had a total of 25 entries, and all of them were great responses to this month’s question, which was:

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

If you haven’t read them… Read more

0 comments, 131 reads

Posted in SQL Aloha on 2 April 2010

Speaking Seven Times in April

April will be a busy month for me as I will be speaking seven different times, on seven different topics, at four difference user group and conferences. Here’s my lineup:

Baltimore SQL Server Users Group
Monday, April 5, 2010, 7:00-8:00PM
”How to Use the SQL Server 2008 Performance Data Collector… Read more

1 comments, 157 reads

Posted in SQL Aloha on 2 April 2010

April Question: What advice would you offer a novice DBA in order to help them along in their career?

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

0 comments, 186 reads

Posted in SQL Aloha on 1 April 2010