Brad M McGehee

September 2007 - Posts

  • An Online Search Engine for SQL Server 2005 Books Online

    If you prefer using the Internet version of SQL Server 2005 Books Online instead of the local version, there is now a dedicated search engine available that allows you to search only against the web version of SQL Server 2005 Books Online. You may find this faster than using a general search engine if you know what you are looking for is most likely located in Books Online.

    The custom search engine is located at: http://search.live.com/macros/sql_server_user_education/booksonline

  • Need an Excuse to Visit Canada? Check Out DevTeach/SQLTeach in Vancouver, BC

    DevTeach, and its accompanying SQLTeach conference, will be taking place in Vancouver, BC this upcoming November 26-30, 2007.    This conference offers 119 different sessions (75 min. each) presented in 7 rooms over three days. The sessions include both .Net development and SQL Server topics. This means that you can only see 17 sessions out of 119 because 6 sessions are given daily in each room. With these numerous choices of subjects, you can build your schedule with the subjects that are more relevant to your job. Each session provides you with downloadable material and code sample. 

    I will be presenting at SQLTeach myself, and you can check out my sessions at:  http://www.sqlteach.com/Speaker.aspx

     For more information on the event, check out: http://www.sqlteach.com Just because the event is held in Canada should not keep you from coming. The event is attended by many people from the United States. In fact, when I attended SQLTeach last time, I meet a DBA from Hawaii who flew all the way just to attend. It is definitely an international event.
  • PASS Summit 2007 a Smashing Success

    I have been attending the annual PASS Summit since 2000, and each year I am very happy I attended. This year's event, held in Denver this September, had about 2,300-2,400 participants and about 114 different sessions. While there are several different SQL Server conferences available to DBA, the PASS Summit is by far the bigget and the best.

    While the annual Summit is the highlight of PASS, PASS is more than just a conference. It is a world-wide group of over 25,000 SQL Server DBAs and developers, including many local user groups. If you live in a large city, most likely there is a PASS chapter where you can attend monthly educational events where you can listen to speakers and ask your difficult technical questions.

    If you are not familiar with PASS, and I am surprised how many DBAs and developers are not familiar with PASS, please check them out at www.sqlpass.org. The next Summit will be held in Seattle in November 2008, and it is not too early to begin planning to attend. And if you can't make the Summit, at least check out the website to see if there is a PASS user's group close to where you live.

    Keeping up with the latest knowledge in SQL Server is tough, and by participating in PASS, you can make this task a little easier.

    Posted Sep 22 2007, 03:34 PM by bradmcgehee with no comments
    Filed under:
  • Learn More About Column Statistics from Microsoft Whitepaper

    I just ran across the whitepaper on MIcrosoft's website called "Statistics Used by the Query Optimizer in Microsoft SQL Server 2005" available at: http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx.

     If you have every wondered about how statistics are used inside SQL Server, you should read this paper.

  • Running SQL Server 2005 Under Vista

    While I delayed doing it as long as possible, I finally had to rebuild my laptop. Like all computers, after time, they begin to run slower and are more subject to problems. It was about 10 months along since my last rebuild, but I just couldn't wait any longer, I had to rebuild.

    The hardest decision to make was to reinstall Windows XP Workstation, which I have been running for years, or to upgrade to Vista. It was a tough call, but I decided to upgrade to Vista Ultimate. Afterall, as a Microsoft MVP, I felt somewhat obligated to use Vista, or at least give it a try.

    After backing up all my data (in three different places) I rebuilt my laptop with Vista, and to my surprise, everything went well. I had absolutely no problems reinstalling all of my old software, except for one: SQL Server 2005.

    Yes, my best buddy (yes, I know I lead a lonely life), SQL Server 2005, would not install correctly. Of course, the RTM version had to be installed first (which is not Vista compatable). My problem was that whenever the SQL Server service would try to start, it locked up so bad that I couldn't even kill it without rebooting. After several uninstalls and reinstalls, it finally installed the RTM version. I didn't do anything different between install attempts, but the third one was a charm and installed. I then installed SP2, some hotfixes, and the SP2 SQL Server provisioning tool for Vista and SQL Server. After about 8 hours of work, it was finally running. See http://www.microsoft.com/technet/community/columns/sectip/st0807.mspx for more information on SQL Server 2005 and Vista.

    This kind of surprised me. Generally, I fight with a lot of different software when rebuilding a new computer. But this time, it was only SQL Server 2005 that was the problem. Who would have guessed?

    Overall, I like Vista. And if you haven't made the move yet to Vista, I suggest you give it a try. I was going to wait until SP1 for Vista came out, but I didn't want to wait until early 2008 to do so. But in any event, there were plenty of Vista drivers available for my hardware, and everything is much better now. My computer is faster and working without problems. I just hope this rebuild lasts at least another 10 months. Rebuilding your computer can be a big job, and I would rather spend my weekend at the beach instead of in front of my computer.

    I'll be at PASS next week. If you see me, please stop me and say hello.

    Posted Sep 10 2007, 04:01 PM by bradmcgehee with 1 comment(s)
    Filed under:


© 2000 - 2007 vDerivatives Limited All Rights Reserved.