The new SQL Server 2016 release is just around the corner (June 1st) and we’re really looking forward to it at Pragmatic Works! It’s also a busy time for the Software team, as we have to make sure all of our products play well with the new SQL Server 2016 features. We have just released the 2016.2 build of all of our products, which is compatible with SQL Server 2016 RC3 and will also work with the 2016 RTM release when it is available.
I’ve been a big advocate of testing for applications, databases, data warehouses, BI and analytics for a while now. Not just any testing, but real tests that help you truly verify the state of your code, applications and data. I like Test Driven Development, but really any approach that focuses on automated, repeatable tests that verify meaningful functionality I find hugely beneficial. And almost no one I’ve ever talked to about this topic has disagreed with me. (There was that one guy, but he was a FoxPro developer, so...) But there’s often a point where the conversation goes sideways. Usually, it starts something like this: