Category Archives: Tips

SSRS Tip: Hide a tablix if no rows returned

Posted on January 19, 2012 by Jen McCown

I have a tablix in an SSRS report, populated by a query that might or might not return any rows.  What I want to do is make that tablix invisible if there are no rows returned. First off, to set … Continue reading →

Posted in sqlserverpedia-syndication, SSC, SSRS, Tips | 2 Comments

Another reason that T-SQL beats the GUI

Posted on November 14, 2011 by Jen McCown

In IT, we have a few very solid and universal principles that no one ever argues with.  The first of these is Cover Your Ass (CYA). CYA is so universal and popular because things go wrong, blame gets thrown, and … Continue reading →

Posted in sql server, sqlserverpedia-syndication, SSC, Tips, TSQL | 4 Comments

Great Tools for Formatting T-SQL

Posted on September 12, 2011 by Jen McCown

I have a big rant I add to….well, to every single SQL session I give. That rant is on formatting code. You see, (I say,) you can’t even begin to understand or optimize a query if it’s not formatted…and by … Continue reading →

Posted in Random helpfulness, sqlserverpedia-syndication, SSC, Tips, TSQL | Tagged | 7 Comments