December 2011 - Posts

• SQL Server Upgrade Advisor should check Database db_compat levels, not server version

  We have a very common customer scenario where the customer decides to upgrade to a new version (in this case let's say SQL Server 2012). They run upgrade advisor and note that there are a whole lot of problems. They think "Hey that's way too much to deal Read More... Posted Saturday, December 24, 2011 11:36 AM by Greg Low | 0 Comments

• New SQL Down Under Podcast with Roger Doherty on SQL Server 2012

  Well it's been a while since I've posted up a new podcast. (I know, I know). But I've just started a new series for SQL Server 2012. First out of the gate is Roger Doherty (Senior Program Manager in the SQL Server team) with an overview of all the key Read More... Posted Wednesday, December 21, 2011 11:58 PM by Greg Low | 0 Comments

• SQL Azure DB size limit increased to 150GB

  Nice to see the increase in maximum database size on SQL Azure kicked up to 150GB. In most enterprises I go into, there are a few databases that wouldn't fit but now the vast majority of databases would fit in SQL Azure. Also included in the November Read More... Posted Tuesday, December 13, 2011 7:46 PM by Greg Low | 1 Comments

• SSIS: The package failed to load due to error 0xC0010014

  Over the years, I've seen several causes of this error in SQL Server Integration Services but today I came across another one. You can get this error if you've used 3rd party components (particularly data sources) and the licensing for those components Read More... Posted Tuesday, December 13, 2011 12:35 PM by Greg Low | 0 Comments