Browse by Tags

• analysis services
• authentication mode
• backup
• books online
• clarity
• Connect
• connection pooling
• distributed transactions
• DMVs
• documentation
• partitioning
• read-only filegroups
• restore
• shrinkfile
• sorting
• SSMS
• statistics
• sysprocesses
• trace
• usability

• Connect Digest : 2010-02-06

  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... Posted Saturday, February 06, 2010 7:32 PM by AaronBertrand | 1 Comments Filed under: SSMS, Connect, error messages, restore, backup, read-only filegroups, sorting

• When bad error messages happen to good people

  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... Posted Thursday, February 04, 2010 11:27 AM by AaronBertrand | 16 Comments Filed under: usability, error messages, clarity

• 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 Sunday, August 09, 2009 5:04 PM by AaronBertrand | 1 Comments Filed under: Connect, DMVs, books online, documentation, error messages, sysprocesses, authentication mode

• Connect digest : 2009-06-20

  Here are the Connect items I'd like to draw your attention to this week. I have abandoned the idea of trying to keep track of vote counts and overall rating. Being lazy might be a small part of it, but it is mostly because I just don't think it makes Read More... Posted Saturday, June 20, 2009 12:11 PM by AaronBertrand | 2 Comments Filed under: Connect, usability, partitioning, statistics, shrinkfile, error messages, trace, connection pooling, distributed transactions, analysis services