Yesterday has been published my Q&A interview on my Pre-Conference Workshop at SQL Pass 2012. It’s a good way to understand what will be discussed in the workshop, so if you’re interested or you’re into the Data Warehouse / Business Intelligence field and want to understand how the Agile approach can help you, you can read it ...

I received an email from a database professional asking about re-executable T-SQL. I directed the developer to my series at SQL Server Central on Test-Driven Development: An Example of Test-Driven Development An Example of Test-Driven Development, Part 2 An Example of Test-Driven Development, Part 3 An Example of Test-Driven Development, Part ...

Test-Driven Development (TDD) is a software development practise that has been around for a few years. Wikipedia describes it as: Test-driven development (TDD) is a software development process that relies on the repetition of a very short development cycle: first the developer writes a failing automated test case that defines a desired ...

Many thanks to all who attented to my webcast on Monday. I really appreciated your feedbacks and I already got some very interesting suggestion that I’ll surely implement. If you have more feedbacks you can leave them here: http://speakerrate.com/talks/4577-adaptive-bi-engineering-a-bi-solution  I must say that I would have liked to have ...

On the next 20th Semptember I’ll deliver a session on a topic that is IMHO really important but is not yet covered enough: Adaptive BI: Engineering a BI Solution Are you starting to create a BI solution....but where do you begin with? How to setup everything correctly so that you'll be able to handle new features required by the customers ...

I’ve always stated that creating a software solution is half and art and half an engineering process. Just like building an house, or a car, or any mechanical or electrical device, the art is that part of the work where someone has to create something new to satisfy the customer need. Architects are the figures that plays the artistic role. ...

Yesterday I’ve release an updated version of QueryUnit, the version 0.0.0.8. QueryUnit now supports AreNotEqual, Greater, and Less assertions and is more capable of managing strings results. I must say that I cannot live anymore without a proper Unit Testing of a BI solution. Just yesterday happened that one of the unit tests at a customer site ...

One of the main steps in the process we internally use to develop a BI solution is the implementation of Unit Test of you BI Data. As you may already know, I’ve create a simple (for now) tool that leverages NUnit to allow us to quickly create Unit Testing without having to resort to use Visual Studio Database ...

Yesterday I released a new version of QueryUnit, a tool I've created to easily perform unit testing on SQL Server and Analysis Services databases. The main feature of this new version is the ability to automatically launch the NUnit GUI so that it’s even simpler to do unit testing. You can download it ...

While I was working on a package to incrementally load a dimension in the DWH I’m developing for a customer, I stumbled upon a tricky little bug (I think, I still have to have a response from MS) that had – and will have – a little impact on how I create my packages. I’ve found that, when working on an empty table that has an identity column, if ...