|
|
|
|
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.
February 2010 - Posts
-
Last week, Microsoft released Cumulative Update #8 for SQL Server 2005 SP3. The build # is 9.00.4285. You can read the blog post from the Release Services team here: http://blogs.msdn.com/sqlreleaseservices/archive/2010/02/15/cumulative-update-8-for-sql-server-2005-service-pack-3.aspx Read More...
|
-
In my last post in this series , I talked about inconsistent table aliasing. Today I was reminded of another behavior that DBAs and developers alike can be lazy about: keeping Books Online current. There are always going to be mistakes in any set of documentation, Read More...
|
-
I've been invited to speak at SQLSaturday #33 in Charlotte at the beginning of next month. There are 9 tracks and a total of 54 sessions, with a great variety of sessions and a superb speaker lineup. You can check out the schedule here: http://www.sqlsaturday.com/33/schedule.aspx Read More...
|
-
I was tagged by David Stein, a.k.a. Made2Mentor [ blog | twitter ], to talk about " MacGyver Moments " in my career - times when I've turned nothing into something. One clearly comes to mind, though it was more like keeping a dying server on life support Read More...
|
-
Simon Sabin has asked for better usability in the SQL Server Agent log viewer: specifically, to allow you to get to job / step properties directly from the history viewer. #531889 : Allow access to job details from the log file viewer to improve manageability Read More...
|
-
In my last post in this series , I wrote about ignoring the principle of least privilege, since a lot of people fall into the trap of following the path of least resistance. This time I wanted to touch on a topic I've touched on before: aliasing. Over Read More...
|
-
Just wanted to drop a quick note to let people know that I will probably be pretty quiet on here for the next two weeks. We leave tomorrow for Vancouver to spectate at several events at the Olympics, and won't be back until the end of the month. This Read More...
|
-
In my last post in this series , I talked about "blind SQL Server installs" and some of the potential consequences of making uninformed choices during setup (or of just accepting all of the defaults). Today I wanted to touch on security a bit. I frequently Read More...
|
-
In my last post in this series , I talked about some problems associated with relying on undocumented behaviors and commands. This time I wanted to touch on SQL Server configuration, and some of the items I see where more thought should have been put Read More...
|
-
In my last post in this series , I talked about the common habit of creating an IDENTITY column on every single table. Today I want to talk about a more broad concept: relying on undocumented (and therefore probably undefined, and certainly far from guaranteed) Read More...
|
-
Back in October, I started a series of blog posts called " Bad Habits to Kick ," and thought I would revive the theme. I've worked with developers that dabble in SQL, and they tend to have a few common traits. I'm not sure where they come from, but one Read More...
|
-
I think anybody even remotely involved with databases these days has seen the xkcd comic about Bobby Tables : http://xkcd.com/327/ Basically, the comic warns against SQL injection, and reminds you to sanitize your database inputs rather than blindly append Read More...
|
-
Upgrading a database with read-only filegroups Earlier today, I complained that I should be able to upgrade a database with read-only filegroups. In this case an upgrade from, say, 2000 to 2005 is blocked because the engine can't update the system schema Read More...
|
-
Over the years I have largely been amused by the variance in error messages that come out of SQL Server. Some are very verbose and some even border on provide too much information, but the ones that irk me are the ones that leave you scratching your head. Read More...
|
-
Brent Ozar ( blog | twitter ) recently made some comments about the FusionIO SSD drives . Basically, he was able to break three drives in a row - simply by doing load testing against them ( using SQLIO ). The symptom is simple: the drives go offline and Read More...
|
|
|
|
|
|