Mark V SQL

I think it’s clear to anyone with half an eye open that the #SQLHelp hastag has been, and continues to be, a huge boon to the SQL community. It is a fantastic way to get assistance with SQL Server. If I were a DBA, it would be perfect for me. I just returned from the [...]

I have been lax in promoting my local SQL users group, so here goes. Oh, by the way, it’s Lara’s fault that I am a SQL Server consultant. Thanks Lara! June PASSMN Meeting & Newsletter Sponsored by Magenic There will be books, shirts and other swag at the end of the meeting! Location:    8300 Norman [...]

I have been to two different presentations on SQL Server 2008 R2 Reporting Services enhancements over the past month or so. In both of those presentations, the presenter said just about these exact words: “Now, you can view a report’s properties without having to run it first.” I decided to check Microsoft.com to see if [...]

Two households, both alike in dignity, In fair Verona, where we lay our scene, From ancient grudge break to new mutiny, Where civil blood makes civil hands unclean.           ~ Romeo and Juliet, William Shakespeare   Those Montagues and Capulets don’t do so well with the sharing thing. They fight. A lot. This causes a [...]

SQL Server Reporting Services provides a great way to allows report users to select more than one value from the available values list in parameters, creating a multivalue parameter. SSRS dynamically creates a comma separated list of the values selected by the user to pass in to the data source. Great. It also dynamically creates [...]

This summer I built an SSRS 2008 Report Model for a client. The end users report against the model using Report Builder 2.0. I shall pause here for a rave. <rave> Report Builder 2.0 is just outstanding, in my humble opinion. I built a SQL 2005 Report Model for a different client a few years [...]

When we link from one entity to another entity in SSRS 2005 Report Builder, we get an INNER JOIN between the two entities. The Report Builder tool does not natively support OUTER JOIN functionality. However, there is a way to create OUTER JOINs in Report Builder models and overcome this limitation. We have two tables, [...]