Home - Page 7

SSRS non-ugly #3: Chart styles

This is the third post in a new series on non-ugly SSRS reports. As I stated in the opening post: SSRS doesn’t have to be ugly This week, lots of folks are tweeting and blogging about the new SSRS 2016. Exciting stuff, looks really great! But what about when you’re still stuck with one of the RTM versions of […]

Read More

Creating non-ugly SSRS reports #2: formatting tables

This is the second post in a new series on non-ugly SSRS reports. As I stated in the opening post: SSRS doesn’t have to be ugly In part 1 (the use of typography & fonts), we focused on using typography (and avoiding borders) and some colors to get rid of the Office 2003-styling SSRS has by default. One […]

Read More

Package generation with SSIS – an overview

Although you can hardly ignore BIML (with bloggers like Cathrine Wilhelmsen and Bill Fellows sharing good stuff), there are still other options for package generation in SSIS. While enjoying a small conversation on LinkedIn about the automation options, I suddenly remembered still having a slidedeck from a presentation I gave early 2014. Please note that these are my […]

Read More

Visual Studio Eror Messages

Yes, that typo was intended. Remember when I said this? [Using Google to find a solution to] Error messages? Be sure to include the exact message – “in quotes” Recently I encountered a occasion where this helped especially well. A colleague emailed me with the question why his VS2010 install didn’t load his SSRS Preview correctly. The ‘Run’ functionality worked, but the […]

Read More

Gathering knowledge and keeping up

When training and coaching Microsoft Business Intelligence developers and analysts, people sometimes ask how to keep up with all the new stuff developing. Or, how to start building your knowledge inside your profession. Here are some thoughts about that.

Read More

SQL Server MONEY datatype limitations

Be very, VERY careful when using SQL Server’s MONEY datatype. It’s okay for storage of money things (offers some nice features too), and has an accuracy of 0.0001. Once you start calculating with that, beware. 1/10000th is quite a limitation.

Read More