Archives: March 2010
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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