Monday, June 3, 2013

Reports are Dumb

Really, reports are dumb. This is not to say that people that use them are dumb, not at all. This is really about the fact that reports, as we have come to know them, don't do much for us or our business partners.We can make some seriously pretty data output with Crystal Reports, Business Objects Webi, or SQL Server Report Builder (well, maybe not that last one) that answer key business questions. That sounds important, and it is, but the problem is that the usefulness of the report ends with the answer.

Thursday, May 30, 2013

sp_Blitz Features for BI Admins

I recently discovered the sp_BLITZ™ – SQL Server Takeover Script via the SQL Server Central Daily Newsletter. (You need to sign up for this if you don't already.) You can find sp_BLITZ™ at I took a quick look at it and found several features that would be very useful in a SQL Server BI environment.

Friday, May 24, 2013

Request Addition of Code Analysis Extensibility to SSDT DB Projects

I really like the SSDT database projects and I have recently convinced our BI team to start using them to maintain our smaller databases. I am working on creating a database projects for our Staging and Data Warehouse projects and have run into a shortcoming in the SSDT DB Project capabilities.