Mladen Prajdić just released SSMS Tools PACK 1.0. SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express. Here are some of the features Uppercase/Lowercase keywords.Run one script on multiple databases.Copy execution plan bitmaps to clipboard.Search Results in Grid Mode ...

This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer.  Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

SQLCLRProject is an alternative to the built-in support in VS for deploying SQLCLR objects. Check it out at: http://nielsb.wordpress.com/sqlclrproject/

(See my part 1 article about non-trusted constraints in general: http://sqlblog.com/blogs/tibor_karaszi/archive/2008/01/12/non-trusted-constraints.aspx) The optimizer is a pretty smart little animal. It can even use constraints to eliminate some data access or part of a query. That assumes however that the constraint is trusted. For example, for ...

When an issue comes up more than once in a short period of time, I figure it is a message from the Universe. I might even assume it is a gift of blog fodder. So I won't turn down the gift, even if it means another juicy post before the end of year, much to Denis' disappointment. The issue is SQL Server 2005 ''Included Columns''. There was a post ...

Have you ever needed to find your most expensive queries and quickly grew weary of writing T-SQL against trace tables to try to ferret them out?  Have you ever had to wade through gigabytes of trace data just to find one ill-behaving query?  Have you ever struggled to decide what performance metrics really matter when analyzing Profiler ...

  I first heard about the possibility of database cloning way back in version 7.0 and thought it sounded like a great idea. Who wouldn't love to have a bunch of identical little databases running around, of smaller size and easier manageability? Cloning a database means creating a statistics only copy of it, so that you can examine ...

  Last July, I posted about a way to run a batch multiple times when you use GO as the batch separator. I usually take advantage of this technique when I am loading test data into a table. I was mentioning this feature to my class last week in Minneapolis, and one of the students thought that this feature had another use. He thought it ...

  At first I thought I would just add another sentence to my previous post, but then I realized that this feature is not even documented anywhere, and it might be useful to mention it in its very own post.  I have no idea why it is undocumented, but it has been part of all command interfaces to TSQL that I have used for the last 20 ...

At least, I think it might become my new favorite tool.  J One of my readers created a tool to graphically display database storage internals, like allocation information, actual page contents, etc. This is just the tool I would have wanted to write if I ever got back to doing any programming. Here's what the author, Danny ...