Blogs

May 2006 - Posts

• FREE Intellisense add-in for SQL editors

  Here is their description: Red Gate Software has purchased SQL Prompt, an addictive add-in that provides Intellisense for Query Analyzer , Visual Studio 2005 , VS 2003 and Management Studio . For the summer months, while SQL Prompt undergoes further development, Read More... Posted Tuesday, May 23, 2006 2:30 PM by Jason | 1 Comments

• Disabling Export Options in Reporting Services

  The other day, I was asked how to disable export options for one of the reports I am developing at my current client. Having not fielded this request previously, I checked the around found you are able to disable export options for each reporting services Read More... Posted Wednesday, May 10, 2006 9:38 AM by Jason | 5 Comments

• This blog entry brought to you by the procedure "sp_MSForEachDB"

  My undocumented stored procedure of the day is sp_MSForEachDB . This procedure allows SQL statments to loop through all database names on a server with a dynamic SQL string. The procedure accepts the variable @command1 for the dynamic SQL string, and Read More... Posted Tuesday, May 09, 2006 10:21 AM by Jason | 0 Comments

• How to Sort SSMS Project

  Well, contrary to the title you can't... I felt empty inside the other day and it was all because I kept adding queries to my SQL Server Management Studio (SSMS) project and they weren't sorting at all. They just sat there in the order in which I added Read More... Posted Monday, May 08, 2006 9:00 AM by Jason | 0 Comments

• Room with a View

  Every so often someone will get me on the topic of why "Select *" is an offical Bad Practice . There are various arguements against "Select *" but one that a lot of programmers may not be aware of is the relationship between "Select *" and views. When Read More... Posted Saturday, May 06, 2006 9:00 AM by Jason | 0 Comments

• Understanding Query Filters and Clauses

  On a few occassions in the past query filters and clauses have bitten me and reviewing how they work every now and then is always a good idea. Itzik's article for SQL Mag is a great refresher for anything forgotten. Understanding Query Filters and Clauses Read More... Posted Friday, May 05, 2006 9:00 AM by Jason | 0 Comments

• Naming Conventions

  Recently I read Ajarn's blog on Separate Your Singular From Your Plurals , where he discusses naming tables as a singular rather than a plural. I'll have to agree that the article struck a chord with me and he was preaching to the choir. One beef I have Read More... Posted Thursday, May 04, 2006 10:33 AM by Jason | 0 Comments

• PASSMN May Meeting

  PASSMN Meeting is coming up and I have my second speaking engagement there. I'm really excited by the topic and hope that all who attend see the value in Notification Services over custom built notification engines. Topic Report Builder – Model Creation Read More... Posted Wednesday, May 03, 2006 4:16 PM by Jason | 0 Comments Filed under: SQL NS

• Reporting Services Exports

  My current client wants to restrict the export options for reports to those that work best with the reports that they are delivering. When looking into this request I found the following article by Roman Rehak that covers exactly how to accomplish this. Read More... Posted Tuesday, May 02, 2006 4:53 PM by Jason | 0 Comments Filed under: SQL RS