Join us at PASS 2010!
Please join as at the 2010 global summit for the Professional Association for SQL Server in Seattle. The conference is…
Product Review: SnagIt 10
Screen captures have become part of our computer culture… “I’ll send you a screen shot of the window so you…
Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using a dataset filter rather than the WHERE…
Project Phoenix: a Chance to Support the Community and Build a Career
Do you know someone with an IT background who could use a break, is passionate about technology and wants to…
2010 Microsoft BI Conference: Directions in Microsoft BI
The combined Microsoft BI Conference and TechEd in New Orleans last week was a great experience. The shear magnitude of…
Portland SQL Saturday / Code Camp 2010
Today was the Portland SQL Saturday and Code Camp at the University of Portland and it was a great experience. I didn’t hear what the final attendee count was but many of the session rooms were full… 700-800 maybe?
BI Conference Grocery Shopping Demo
Help enter demonstration data for the Microsoft BI Conference.
Go to the shopping demo web form and enter some transactions.
Presenting at 2010 European PASS – Sort Of
I was so looking forward to the trip to Germany to speak at the European PASS Summit on April 22nd.
Hitachi Consulting’s Announcement About by MVP Award
Being named an MVP this year is very exciting news for me. As I was trying to come up with…
Report Recipe Book Released
Our SQL Server Reporting Services Recipe book was released in April. This is a cookbook style book for experienced SSRS designers with 63 individual report recipes, each addressing a specific business requirement or scenario. My co-author, Robert Bruckner, is a technical lead on the SSRS product team and a prolific blogger on the topic. The book is about 630 pages long and took about a year to write. The book takes a unique approach by providing recipes and step-by-step instructions to solve specific business problems.
Return the Value of a Specified Dataset Row Outside a Data Region
I want to return the field value for a specific row to a textbox below a table in my report. To pull this off, I have to be a little creative as there isn’t a simple way to return a value from a specific row in a dataset
How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including the TOP statement.
User is prompted to login when viewing a report
A user has been added to a SSRS role for the report folder or report but is still prompted to login. This can happen if Internet Explorer isn’t configured to persist the user’s Windows login to Intranet sites.
Displaying a Check Mark for a Row When a Related Record Exists
Let’s say that you have a column named some_id in an outer-joined table that will return a value if a record exists and will return null if a record doesn’t exist…