THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Showing page 4 of 7 (62 total posts)
  • SMO Changes from SQL 2005 to SQL 2008

    A year ago in anticipation of publishing a book on SMO (which never came to be) I wrote a number of chapters demonstrating how to manage specific sets of objects, and I provided examples in VB.Net, C# and PowerShell. As should be expected, I thoroughly tested all of the code samples to make sure they worked. This year I've been part a couple of ...
    Posted to Allen White (Weblog) by AllenMWhite on February 20, 2009
  • Did You Know? A New SQL Server 2008 Books Online Update is Available

    When I searched for ''sql server 2008 books online update'', the first non-advertising hit I got was labeled August 2008, and I already have a Books Online download for August.     However, when I clicked on the link I was taken to a page to download a brand new January 2009 Update::     So here's the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 2, 2009
  • Geek City: Too Many Indexes!

    I wrote about ''Too Many Columns'' last September, and along with changes in SQL Server 2008 that allow lots of columns, there is also the ability to create more than the old maximum of 249 nonclustered indexes on a table. I knew this fact, but somehow I overlooked it when updating the chapter on table structures in my new book. My omission also ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 18, 2009
  • Did You Know? I just submitted my last chapter!

    Less than an hour ago, I sent my last chapter of my next book ''SQL Server 2008 Internals'' to my editor! Note that I said ''my'' last chapter, not ''the'' next chapter, as two of my co-authors still need to complete their chapters. But I've finished my chapters! Now this is still more to do, in addition to the waiting for the other two chapters ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 5, 2008
  • PASS Demonstration Errors

    Errors occur. (I'm sure that's someone's corollary to Stuff Happens.) Errors occur, and that's why we write error handling code in our applications. My least favorite time for the occurrance of errors is when I'm doing demos, and that's what happened in a presentation I did at PASS last week. I try to test everything before giving the demos, ...
    Posted to Allen White (Weblog) by AllenMWhite on November 24, 2008
  • Did You Know? You can search the web-only Books Online

    You might be aware (from other bloggers on this site) that there is a new web-only Books Online for SQL Server 2008 available at http://msdn.microsoft.com/en-us/library/dd239407.aspx.  Like Tibor, I prefer a downloadable BOL, partly because I do a lot of research and writing while traveling and I don't always have an internet connection, ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 11, 2008
  • Geek City: Clearing a Single Plan From Cache in SQL Server 2008

      I just today found out about something that was in plain sight in the Books Online... but the documentation is so vast, I haven't discovered everything yet. I blogged about clearing a single plan from cache in SQL Server 2005 a while back, and mentioned a rumor that there would be a new way to do this in SQL Server 2008. And then just ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 31, 2008
  • SQL Server 2008 SMO Library Changes

    While preparing for a presentation at PASS next month I tested my PowerShell script to back up user databases on a server. This script has been running flawlessly against SQL Server 2005 for a couple of years, so I was really surprised when PowerShell returned a screen full of errors and no backups. What slipped my mind was something I'd ...
    Posted to Allen White (Weblog) by AllenMWhite on October 18, 2008
  • [Ohio] A Day in the Life of the DBA 2008

    We are pleased to invite you to the October 9th 2008 meeting of the Ohio North SQL Server Users Group (ONSSUG). The meetings are held on the 2nd Thursday of every month at 5:45 in the Cleveland Microsoft office. The address of the office is below: Microsoft Corporation 6050 Oak Tree Blvd. Suite 300 Cleveland, OH 44131 Agenda: 5:00 - 5:45 ...
    Posted to Allen White (Weblog) by AllenMWhite on October 6, 2008
  • Did You Know? It's SQL Know How!

    I am very excited to be part of a new SQL Server Training Group, which was organized in the UK by 4 SQL Server MVPs (current and former).  I know this is a shameless plug, but I am not apologizing. I am actually going to the UK for the benefit of the SQLKnowHow guys, and I'm just trying to help them out even more by telling you all about ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 26, 2008
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Privacy Statement