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 http://www.brentozar.com/blitz/. 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.