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 » Documentation » books online   (RSS)
  • Differences in documentation for sys.dm_exec_requests

    I've already complained about this on Connect (see #641790), but I just wanted to point out that if you're trying to make sense of the sys.dm_exec_requests document and what it lists as the commands supported by the percent_complete column, you should check which version of the documentation you're reading.  I noticed the following ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 7, 2011
  • What permissions are required for SET IDENTITY_INSERT ON?

    SQL Server 2000's SET IDENTITY_INSERT ON topic says: Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner. While the SET IDENTITY_INSERT topic for SQL Server 2005 (and up) says: User must own the object, or be a member ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 14, 2010
  • SQL Server v.Next (Denali) : Books Online

    There are posts elsewhere that go through the whole rigamarole (for example, this post from Don Gill, SQL Server's Group Content Publishing Manager).  I just wanted to highlight the key bullet points: if you want to use Books Online locally, you will need to: install Books Online from Denali setup. Note that Management Studio is now ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 13, 2010
  • 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. =============================================== Setup messes with authentication mode I was ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 9, 2009
  • 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 29th).  The download has not been made available as of yet; this usually takes several ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 7, 2009
  • 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 received one private message asking me why they got the April version instead ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 22, 2009
  • 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 saw this happen.  This week someone else came across the issue, where they had a SQL ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 16, 2009
  • 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 to do this, especially ones like today where the weather is crappy.  While I can't ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 18, 2009
  • 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 thanking you for downloading says: Thank You for DownloadingSQL Server 2005 Books Online ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 11, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement