Aaron is a senior consultant for
SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a
Microsoft MVP since 1997; tweets as
@AaronBertrand; and speaks frequently at user group meetings and
SQL Saturday events.
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 of the May version.) This has
happened for every Books Online update that I can remember -- it just
takes time to publish and distribute; I don't know what else to tell
you.
- To make item 1. even more confusing, the "New and Updated Topics"
topic is actually dated "March 30, 2009." Again, please don't
nit-pick. While I am quite happy to use the easier-to-update web
interface for most things, I am also happy that they are dedicated to
pushing these releases out to us, even if it does take 45 days to
actually go from "done" to "installed." (Now where is the mobile version for my iPhone?)
- There is a new example in the topic "CREATE USER" that shows how
to create and use a user without a login. I had no idea you could
create a user without a login behind it. If it weren't for this update
(and the fact that they have committed to documenting changes in a
sensible way - just check the "Change History" section at the bottom of any page), I would never have been looking at this topic.
- The sp_configure option 'user instance timeout' has been added to the list of deprecated instance options. Initially I thought this had to do with SQL Server Express Edition's user instances option, but apparently this specifically involves just the Compact Edition.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About AaronBertrand
...about me...