Browse by Tags

• authentication
• authentication mode
• bol
• books online
• cart before the horse
• connect
• cumulative updates
• date handling
• deadlocks
• deferred name resolution
• DMVs
• Downloads
• error messages
• General
• hofixes
• knowledge base
• locking
• New Features
• product enhancements
• scripting
• service packs
• SQL Server 2005 updates
• SQL Server 2008
• SSMS
• sysprocesses
• table designer

• Some updates to SQL Server 2008 SP1 CU4 you may not have noticed

  Back on September 21/22, Microsoft released its most recent cumulative updates for SQL Server 2008. For RTM, this was Cumulative Update #7 (10.00.1818), and for SP1, this was Cumulative Update #4 (10.00.2734). However, if you have requested the SP1 CU...( Read More... Posted Monday, November 09, 2009 6:18 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, SQL Server 2008, cumulative updates, knowledge base, cart before the horse

• Connect Digest : 2009-08-22

  I rounded up a few interesting items this week. Does "1/10/1900" mean January 10th, or October 1st? This item demonstrates that Microsoft isn't all that concerned about publishing sample code that uses ambiguous or troublesome formats for date literals....( Read More... Posted Saturday, August 22, 2009 1:18 PM from Aaron Bertrand | (Comments Off) Filed under: Documentation, SSMS, connect, SQL Server 2008, deferred name resolution, scripting, date handling

• Connect digest : 2009-08-09

  Sorry, I've been trying to keep this to a regular Saturday installment, but it was a beautiful weekend here and I just couldn't pass up on non-computer-related activities. I have a short list of Connect items to draw your attention to this week. ===============================================...( Read More... Posted Monday, August 10, 2009 6:04 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, connect, DMVs, books online, error messages, sysprocesses, authentication mode

• SQL Server 2008 Books Online update is available

  Well, let me be more precise: there is an updated version of Books Online online. As reported earlier by Buck Woody , the online version of SQL Server 2008 Books Online has been updated (we are seeing the updates now but the content was refreshed June...( Read More... Posted Wednesday, July 08, 2009 2:36 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, SQL Server 2008, books online

• Connect Digest : 2009-06-05

  As I mentioned in last week's digest , I want to make it clear that I am not presenting Connect issues in this format in an attempt to tip the scales or pimp influence votes. I am merely creating exposure for Connect items (bugs or suggestions) that you Read More... Posted Saturday, June 06, 2009 1:00 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, SSMS, locking, connect, deadlocks, table designer

• More info on the May 2009 update to SQL Server 2008 Books Online

  I finally got around to installing this update today, and thought I would mention a few things. Don't be surprised that "Books Online (May 2009)" actually says "April 2009" in the application's title bar and on any page which states the version. (I already Read More... Posted Saturday, May 23, 2009 5:50 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, SQL Server 2008, books online

• New version of SQL Server 2008 Books Online is available

  Yesterday Microsoft released a new downloadable version of Books Online for SQL Server 2008: http://www.microsoft.com/downloads/details.aspx?FamilyID=765433f7-0983-4d7a-b628-0a98145bcb97 Share this post: email it! | bookmark it! | digg it! | reddit! | Read More... Posted Friday, May 22, 2009 12:45 PM from Aaron Bertrand | (Comments Off) Filed under: Downloads, Documentation, SQL Server 2008

• Connect Digest : 2009-05-16 : please vote!

  Here are the items from this week that I feel deserve some attention. ==================== Hotfixes / service packs should leave authentication mode alone I may have talked about this issue here before, I'm not sure, but I thought I was the only one who Read More... Posted Sunday, May 17, 2009 1:33 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, connect, authentication, New Features, books online, service packs, product enhancements, hofixes

• Come on, it's Saturday, get out and vote!

  I was encouraged by some fellow MVPs (well, mostly Alexander Kuznetsov ) to periodically post a set of Connect items to encourage voting for items that I found relevant but that are maybe being largely ignored. Saturday is probably my best opportunity Read More... Posted Sunday, April 19, 2009 4:07 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, connect, New Features, books online, product enhancements

• SQL Server 2005 Books Online update (December 2008) now available

  Don't be fooled by the poor title on the page, which still says "SQL Server 2005 Books Online (September 2007)" (clearly a leftover from an earlier BOL update). The text under the overview section also mentions the September 2007 update. And the page Read More... Posted Friday, December 12, 2008 3:18 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, bol, books online, SQL Server 2005 updates

• New (web) update for SQL Server 2008 Books Online

  Fire up your SQL Server 2008 Books Online (BOL) and check the date. You should find this in any article (except for the very start page). RTM of SQL Server 2008 shipped with a BOL which has ... hmm,... doesn't have a date (just checked in a virtual machine). Read More... Posted Wednesday, November 05, 2008 6:19 PM from Tibor Karaszi | (Comments Off) Filed under: Documentation, SQL Server 2008

• Error messages in 2008 Books Online

  I just learned from Gail E. at MS that the system error messages are all documented in the SQL Server 2008 Books Online. For instance, search for 823. See the hits? Now, for instance, select the "Errors 1 - 999" page. Press the "Sync with Table of Contents" Read More... Posted Tuesday, September 09, 2008 5:44 PM from Tibor Karaszi | (Comments Off) Filed under: Documentation

• Want to get rid of "Compact Edition" from Books Online?

  I'm sure that some of you have been annoyed when searching or using the index and found a hit, thinking it looks strange, only to realize that you are looking at a "Compact Edition" topic. This has happened to me more than once. We just had a discussion Read More... Posted Saturday, July 14, 2007 4:17 AM from Tibor Karaszi | (Comments Off) Filed under: General, Documentation