Invitation for T-SQL Tuesday #005- Reporting
Spring Break or not, time marches on and so does T-SQL Tuesday. I’ll be your host this month and we are going with “Reporting”.
The Post must go live between 00:00:00 GMT on Tuesday the 13th of April and 00:00:00 GMT on Wednesday the 14th (also known as 8pm EDT, 5pm PDT).
You Don’t Know What T-SQL Tuesday Is Yet?
Adam Machanic (Also on twitter as @AdamMachanic) had a great idea 5 months back – Invite new and existing SQL Server bloggers to post about the same topic on the same day. The results have been excellent – diverse skill sets and data related job roles all posting from differing perspectives on the same issue.
Since this is still early in the game, a quick list of the post roundups from the first 4 topics:
- #001 Adam Machanic started this off with a topic of Date/Time tricks
- #002 Adam then wanted to hear about your Puzzling Situations
- #003 Rob Farley got romantic on us and asked about Relationships
- #004 Mike Walsh wanted to glean the ins and outs of IO
Reporting
Reporting is a potentially huge topic so here are just a handful of ideas that might get you started:
- Server Performance Reporting
- Technologies to help offload reporting
- Reporting services tricks
- T-SQL tricks for presentation and formatting
- Database design considerations for reporting
- Self-service reports
- Reports for executives
- Reporting from Oracle in SSRS
Don’t forget that the DMVs are pretty much qualified as ‘Reports’ so those count too!
Pesky little rules…
Once again, please note the time is in GMT (occasionally called UTC). I also echo earlier encouragements to feel free to write your post ahead of time and schedule it. The rules are around when the post publishes, not when it is written.These rules are the same as the previous couple of T-SQL Tuesday’s but I’ll recap:
- The Post must go live between 00:00:00 GMT on Tuesday the 13th of April and 00:00:00 GMT on Wednesday the 14th (also known as 8pm EDT, 5pm PDT). If it isn’t, it can’t be included in the round up post.
- Your post must link back to this post (Trackback or Comment).
- “T-SQL Tuesday #005” MUST be in the title of the post.
- It is your responsibility to verify the trackback or comment appears here on this post. If you don’t see your trackback add your own comment with a link back to your T-SQL Tuesday post and it will be included in the roundup.
Not a rule but a great idea. A lot of the folks who read and participate are on twitter. Follow the hashtag #TSQL2sDay and when your post goes live, tweet a link to it with that tag.
Want To Host?
All you have to do is participate in at least two events and let Adam Machanic know. You can tweet him or leave a comment on his blog, all described in his first T-SQL Tuesday Invitation.
If you need any more clarification, leave a comment. I will respond in the comments or update this post if necessary. Have fun thinking of a topic and I look forward to reading the posts!
62 Responses
http://andrekamman.com/t-sql-tuesday-005-book-index-styled-ssrs-report
T-SQL Tuesday #005 SQL Server Report Services Basic Parameter Tips
T-SQL Tuesday #005 SQL Server Report Services Basic Parameter Tips
http://extofer.blogspot.com/2010/04/t-sql-tuesday-005-sql-server-report.html
In case the trackback does not work.
http://jasonbrimhall.info/2010/04/13/blob-report-t-sql-tuesday-005-reporting/
My entry, an essay entitled “On Technical Reporting”:
http://sqlblog.com/blogs/adam_machanic/archive/2010/04/13/t-sql-tuesday-005-on-technical-reporting.aspx
Heres my entry entitled SSRS Parameters and MDX datasets:
http://sqlblogcasts.com/blogs/blakmk/archive/2010/04/13/t-sql-tuesday-005-ssrs-parameters-and-mdx-data-sets.aspx
Looks like my track back isn’t here. I posted “Reporting For Duty” here: http://www.straightpathsql.com/archives/2010/04/t-sql-tuesday-005-reporting-for-duty/
Hey Aaron – here’s my post:
A DBA myth a day: (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)
http://www.sqlskills.com/BLOGS/PAUL/post/A-DBA-myth-a-day-(1330)-you-cannot-run-DMVs-when-in-the-80-compat-mode-(T-SQL-Tuesday-005).aspx
Cheers
Here’s my post for T-SQL Tuesday #005
http://michaeljswart.com/?p=668
It’s called “Focus on Users when Reporting”
Cheers,
T-SQL Tuesday #005: Smart Card Login Breaks SQL Server Reporting Services 2008: http://www.sqlservercentral.com/blogs/robert_davis/archive/2010/04/13/TSQL-Tuesday-5-Smart-Card-Login-Breaks-SQL-Server-2008-Reporting-Services.aspx
Link to my rather hurried attempt:
http://phelabaum.com/archive/2010/04/t-sql-tuesday-monitoring-reports-with-ssrs/
Here’s my post for T-SQL Tuesday #005
http://insanesql.blogspot.com/2010/04/t-sql-tuesday-005-vertical-tables.html
Enjoy.
Pat
Here’s the link to my T-SQL Tuesday post this month:
http://wiseman-wiseguy.blogspot.com/2010/04/t-sql-tuesday-005-dont-send-blank.html
http://stephenspanos.wordpress.com/2010/04/09/update-tables-with-reporting-services-t-sql-tuesday-005/
http://englishtosql.squarespace.com/blog/2010/4/13/t-sql-tuesday-005-changing-your-isolation-level.html
http://adventuresinsql.com/2010/04/t-sql-tuesday-005-self-service-performance-information/
http://www.jasonstrate.com/index.php/2010/04/tsql-tuesday-005-wait-stat-report-tsql2sday/
“T-SQL Tuesday #005: The Report Interview”: http://jesborland.wordpress.com/2010/04/13/t-sql-tuesday-005-the-report-interview/
Thanks for hosting this month, Aaron!
Here’s my effort at this months TSQL2sday:
http://blog.gre-sqlserver-solutions.com/2010/04/t-sql-tuesday-005-offloading-reporting.html
Just a quick link in case trackback doesn’t work: http://barnz1984.spaces.live.com/blog/cns!3AA0B4302AF9B8E3!751.entry
MDX and SSRS
Not seeing the trackback… so here it is: (HTML Tables in email)… and a POLL for the day. (will post back results tomorrow if there are enough responses to make it worth-while).
http://stef-bauer.com/2010/04/13/t-sql-tuesday-005-cleanup-your-notification-emails-with-html-tables/
Report Viewer 2010
Hi Aaron,
This is great idea. I am not sure if track back worked or not. I have included the link to this post in my very first line/paragraph.
Here is my take on reporting:
Post 1: http://blog.sqlauthority.com/2010/04/13/sql-server-configure-management-data-collection-in-quick-steps-t-sql-tuesday-005/
Post 2: http://blog.sqlauthority.com/2010/04/13/sqlauthority-news-three-posts-on-reporting-t-sql-tuesday-005/
Many many thanks for this great idea.
Kind Regards,
Pinal
One of the new things released along with Visual Studio 2010 was the Report Viewer 2010 control – http://david.gardiner.net.au/2010/04/t-sql-tuesday-005-visual-studio-2010.html
-dave
http://sqlblog.com/blogs/rob_farley/archive/2010/04/13/exploding-maps-in-reporting-services-2008-r2.aspx
Well, looks like it’s just after midnight in London, so here is my entry:
http://bradsruminations.blogspot.com/2010/04/t-sql-tuesday-005-reporting.html
–Brad
Don’t trust trackbacks :), so here’s a comment with a link to my contribution: http://bit.ly/czJ50X
I think I will do a new one. Plenty of people have already read that article and thus *sheepishly* I will take the lumps for the booboo.
It would seem odd to me to retract the article and then republish it next week (I would also have to delete it from SSC).
I think you might be able to just edit it and schedule it (again, *I think*).
D’oh – I was just told that I was a week early. I got the dates mixed up on my calendar and missed the 13th above somehow.
Looks like I will create another one and retitle my early submission.
My entry is now available at http://jasonbrimhall.info/?p=426
As one of the slack-jawed yokels who messed up the trackback last month, I’d like to thank Mike for letting me have a pass and including my post. I already have one in mind for reporting since I finally got it working in production this morning. Will write up (and link properly) tonight 😀
Great idea and thanks for hosting, Aaron!
I really want to echo the whole “YOUR RESPONSIBILITY TO VERIFY” part of the rules. It isn’t good enough to make sure that you included a link, it needs to appear back on this blog post. If it doesn’t – It does NOT count. I ended up missing a couple last month because the original authors didn’t do the verify part. They properly linked but for whatever reason, the trackback/pingback didn’t come through.
Now to think of a post 🙂