March 2011 - Posts

• A system view to return a list of reserved words?

  There was a discussion on our internal mailing list today about how to get a list of reserved words for SQL Server. It strikes me that there should be a system view that returns this. It could also return details of the version of the product where the Read More... Posted Friday, March 25, 2011 11:08 AM by Greg Low | 2 Comments

• Warning: Don't apply VS2010 SP1 (yet) if Intellisense in SSMS matters to you

  This one is a bit annoying. When you apply SP1 for Visual Studio 2010 (VS2010), one of the side effects seems to be that you lose Intellisense in SQL Server Management Studio 2008 R2 (SSMS). If Intellisense matters to you, you might want to wait for a Read More... Posted Wednesday, March 23, 2011 2:33 PM by Greg Low | 4 Comments

• Updated T-SQL Quiz

  Great to see Jacob and the guys updating their T-SQL Quiz. It's free and it's fun. Get involved: http://beyondrelational.com/quiz/SQLServer/TSQL/2011/default.aspx Read More... Posted Monday, March 21, 2011 2:46 PM by Greg Low | 0 Comments

• SolidQ Journal - free SQL goodness for February

  The SolidQ Journal for February just made it out by the end of February 28th. But again, it's great to see the content appearing. I've included the second part of the article on controlling the execution context of stored procedures. The first part was Read More... Posted Wednesday, March 09, 2011 2:17 PM by Greg Low | 0 Comments

• The need for user-defined index types

  Since the removal of the 8KB limit on serialization, the ability to define new data types using SQL CLR integration is now almost at a usable level, apart from one key omission: indexes. We have no ability to create our own types of index to support our Read More... Posted Wednesday, March 09, 2011 1:59 PM by Greg Low | 2 Comments

• Skype, add-on applications, UAC and "Unable to respond"

  Just posting this blog tonight hoping it might save someone else a bunch of time. For call recording on Skype, I use a program called Pamela. Lately, when I'd first installed it, it would work fine. Later, however, it would come up and say: "Another application Read More... Posted Thursday, March 03, 2011 9:44 PM by Greg Low | 4 Comments