Today, after migrate a SQL Server 2012 server we faced a situation where all databases were in
Browsing the web we found the commands needed to put databases back to online state again Read on →
Working primarily with software development, this is the second time I am working in a Business Intelligence project and since the first time I missed some techniques and processes that I was used to.
Things like source control/revision, automated deployment and tests aren’t common in a BI project. Most of the testing is done by hand, so imagine a bunch of records, thousands to millions and all the validation using excel or another manual approach to compare tables status. Read on →