I've been working on a team with Roger Doherty building parts of what's now become the SQL Server 2012 Early Adoption Cook Book . So, if you work on the bleeding edge of SQL Server and are keen to get your head around what's coming, this is a seriously...(read more)

If you have Chinese friends, it's time to say 新年快乐 to them! (Xīnnián kuàilè -> Pronounced like Shin Nien Kwai Ler) They are welcoming in the year of the dragon....(read more)

Temp tables are visible within the scope where they are declared but also in sub-scopes. This means that you can declare a temp table in one stored procedure but access it in another stored procedure that is executed from within the first stored procedure....(read more)

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)

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)

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)

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)