February 2011 - Posts

• What types of objects are useful in SQL CLR?

  I've had a number of people over the years ask about whether or not a particular type of object is a good candidate for SQL CLR integration. The rules that I normally apply are as follows: Database Object Transact-SQL Managed Code Scalar UDF Generally Read More... Posted Friday, February 25, 2011 3:32 PM by Greg Low | 3 Comments

• Should vendors have an express queue for people who have a clue? What passes for support today?

  It's good to see some airports that have queues for people that travel frequently and know what they're doing. But I'm left thinking that IT vendors need to have something similar. Bigpond (part of Telstra) in Australia have recently introduced new 42MB/sec Read More... Posted Tuesday, February 22, 2011 10:00 PM by Greg Low | 3 Comments

• Slow in the Application but Fast in SQL Server Management Studio - from Erland

  Our MVP buddy Erland Sommarskog doesn't post articles that often but when he does, you should read them. His latest post is here: http://www.sommarskog.se/query-plan-mysteries.html It talks about why a query might be slow when sent from an application Read More... Posted Tuesday, February 22, 2011 10:22 AM by Greg Low | 3 Comments

• SolidQ Journal for January (free and available now)

  I've been travelling in Tasmania for a week or so and didn't get to post about the SolidQ Journal for January. It's our free monthly journal at: http://www.solidq.com/sqj . I promised to write a part two on controlling the security context of stored procedures Read More... Posted Saturday, February 12, 2011 4:17 PM by Greg Low | 0 Comments

• 新年快乐 Happy new year to the Chinese blog readers!

  It's that time of the year again with the start of the year of the rabbit. So for all the Chinese folk, happy new year! 新年快乐 Read More... Posted Thursday, February 03, 2011 6:19 PM by Greg Low | 1 Comments