Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm and I am very glad. Many users are also waiting for SQL Server 2005/2008 support (2008 R2 is only supported version now) and I will release it soon. I received… Read more

Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL Server. My colleague recently needed to log something from within function so we were searching for solution how to do that with least work. There is one option to call… Read more

SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read about another new functions in Denali’s Books Online. I am missing those functions, I will write about, really for years. They’re filled under “Analytical function” and they are close to… Read more

I’ve just finished promised SSMS add-in which enables creating of custom folders directly in SSMS Object Explorer. Idea for add-in came from fact that I was dealing with hundreds of SQL objects and was fed up of browsing for correct one in SSMS standard folders. I tried also many “quick… Read more

SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous versions of SQL Server support reading metadata from system catalog but it is possible only for fixed objects. With following new procedures you can do similar thing but for dynamic… Read more

SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than in previous versions. It is IIF and CHOOSE. These two function are very simple but it’s good to know they’re there.

IIF Function
Any developer should be aware of… Read more