Brad M McGehee

February 2008 - Posts

  • Cumulative Update Package 6 Now Available for SQL Server 2005 SP2

    Microsoft recently released the newest cumulative hotfix package for SQL Server 2005 SP2. If you want a copy of it to install it, you must specifically request it from Microsoft. You can not just download it. Find out more at:

    http://support.microsoft.com/kb/946608/en-us

  • SQL Server 2008 February CTP Available to Public

    If you want to get started learning SQL Server 2008, you can load the latest CTP at the following link.

    http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en

  • Installing Windows 2008 to Dual Boot with Vista Ultimate

    I must be crazy, but I recently decided to install Windows 2008 on the same physical server where I already have Vista Ultimate installed. The reason I did this was that I had an extra 500 GB drive on the server that was not being used, and I thought it would be a good place to install Windows 2008 so I could learn more about it. In addition, it was my goal to run several SQL Server instances in virtual machines in order to have several different SQL Server instances available for experimentation.

    Wow, I was in for a surprise. It can be done, but it is not explained very well anywhere I could find.

    Here's what I learned:

    1) First, be sure that the drive you have available in install Windows 2008 on has already been setup and formatted from within Vista. In my case, this was drive E. This drive should be recently formatted and empty.

    2) Next, you have to go through a convoluted procedure to prepare drive C of your Vista installation so that the Windows 2008 installation process understands that drive C exists. Apparently, Windows 2008 doesn't automatically know that it can use drive C for the initial installation process (temporary files) before the installation actually occurs on drive E. To find out about this process, see http://support.microsoft.com/kb/928232.

    3) Once you have completed the above process, then reboot to Vista then startup the Windows 2008 installation program and following the instructions. Be sure that you specify the empty drive (drive E in my case) where you want to install Windows 2008. Once you are done installing Windows 2008, you can now dual boot between Vista and SQL Server 2008.

    Have fun!

  • What Kind of Boss Do You Have?

    I recently visited a large organization, taking a look at how they managed their SQL Servers. I spent most of my time with the production DBAs, but in one short section of the meeting, the production DBA's boss came in for a short visit. In the less than 10 minutes he spent talking to us, it was very apparent he was the boss from Hell. He even made Dilbert's boss look like a good guy.

    This got me thinking about some of the bosses I have had as a DBA, and then I started thinking about what makes a good boss. Here is what I came up with.

    1. The boss should know how the organization runs, inside and out.
    2. The boss should know IT technology, inside and out.
    3. The boss should be very familiar with SQL Server, even though the boss may not be a DBA.
    4. The boss should be a leader, the kind of person people look up to.
    5. The boss should be a good manager, knowing how to get the best out of his or her available resources. This would include great project management.
    6. The boss should treat this staff with respect and professionalism, and help his staff grow in their career development.

    The boss I met failed each of the above points, and it was so bad, that anyone who just spent a few minutes with him would agree. I would never be able to work for such a boss.

    The problem is, that when you start a new job as a DBA, you may or may not be able to speak to your new boss. And if you do, it is often hard to tell much about him or her, unless you run across one like I just met that is so obviously terrible that you can tell virtually immediately. So what can you do? If at all possible, I think it is important that you interview your potential boss before you accept any new DBA position. Often, you can do this at the same time he is interviewing you, or if you aren't interviewed by him, ask if you can speak to him or her before you decide to accept any job offer. Another option is ask his staff what they think of him or her (this may be difficult, but sometimes possible). And last, be sure to do an Internet search on the boss to see if you can find out anything about him or her on the Internet that might give you a clue.

    In other words, it is very important to check out any future new boss. There is nothing worse than starting a new job and finding out that the boss is a jerk. It causes a lot of unnecessary stress and takes all the fun out of the job. But if you strive to be an Exceptional DBA, then you will need a boss that will support you, so it's worth making the effort to find a great boss.

    If you do get stuck with a terrible boss, either because you couldn't find out about him or her before accepting the position, or because your old boss was replaced by a new boss after already going to work for an organization, I suggest you begin looking for a new job. I know this is tough for many people, but it can be done. Working for a terrible boss is just not worth it. Period.

    Let me know what you think.

  • What Features are You Most Looking Forward to in SQL Server 2008?

    I am currently writing a book for Simple-Talk Press on the top 10 new features in SQL Server 2008 that are of the most interest to DBA administrators.

    As you probably know, there are many more than 10 new features, and picking the top 10 is not an easy task. Below is a list of what I consider are some of the top new features, and I want to know what you think. Take a look at the following list, and then post your comments, letting me know what your top 10 favorites are. I have listed more than 10 below because I still haven't made a final decision on which 10 features to include in the book.

    • Policy-Based Management
    • Performance Data Collection with Performance Studio
    • Data Compression
    • Resource Governor
    • New Data Types
    • Transparent Data Encryption
    • Database Mirroring
    • Auditing
    • Change Tracking and Change Data Capture
    • LINQ
    • Multi-server script execution
    • Intellisense
    • Extended events
    • Integrated Full-Text Search
    • Sparse columns
    • New index types
    • PowerShell integration

    If I have not listed your favorite new feature of SQL Server 2008, please let me know what it is.

  • Attend SQLTeach/DEVTeach in Toronto This May

    If you would like to learn more about SQL Server or .Net development, and at the same time sample some Canadian culture, consider attending the upcoming SQLTeach and concurrent DevTeach in Toronto this upcoming May 12-16, 2008.

    The conference is divided into two sections. SQLTeach (www.sqlteach.com) is for SQL Server administrators and developers, while DevTeach (www.devteach.com) focuses on .Net. Of course, you can attend sessions from both events if you like.

    I will be making three presentations this year. They include:

    • DBA 101: Best Practices for DBAs
    • Introduction to the SQL Server 2008 Performance Studio
    • How to use SQL Server Hints

    I hope to see you there.



© 2000 - 2007 vDerivatives Limited All Rights Reserved.