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 :)
Comments | 166 views
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 SSIS [...]
Comments | 1,597 views
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 good [...]
Comments | 819 views
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 [...]
Comments | 2,586 views
