stevienova.com

You can whip out reports in SSRS (SQL Server Reporting Services) very quickly with the report builders (2.0 and 3.0 are money). But what should you remember to do each time, or information to get? Where does the data come from (GL, Sales, etc) – we could use a cube or datawarehouse, or staging, or [...]

So, I previously blogged about using PivotViewer in your Web Applications, but you can also just consume Pivot collections using the “Pivot” tool from Microsoft Live Labs You can download it here What does this tool offer? Well first it has a library/homepage of collections you can browse You can do some slicing and dicing [...]

Figured out today that in SSRS, if you add a filter to your dataset, and you want to use “Like”, that the operand for everything is * instead of % like you might be used to in SQL, sometimes it is just the little things :)

Today I received an email asking to some extent best practices on development with SQL Server Integration Studio (SSIS) and Business Intelligence Developer Studio (BIDS) in a team environment. Here is part of the email: Me and another DBA belong to the same team, we have a SQL server with SSIS running. We use the [...]

Last week I was in a heated discussion about Business Intelligence, and it came up that “Business Intelligence is just writing reports, what is the difference from just writing some reports?” I tend to disagree. Writing reports is, well, writing reports. You can write reports off of tons of data, and yeah, probably get some [...]

Setting up a new instance of SQL Server Reporting Services (SSRS), and getting things configured. What I noticed is that the first time I hit the SSRS site, it would take forever to load, then it would be fine as I used it, and then later after no use, I could come back and it [...]