The Problem Not too long ago I was assisting a client with an issue they were experiencing whilst running some compliance software to check for sensitive data. Sensitive data was picked up in the SQL Server data file but when the DBAs checked, the data was nowhere to be found in the database. It’s fairly …

  With the recent update to PowerBI which enables developers to embed PowerApps directly into reports, I feel the adoption of PowerApps will accelerate  greatly when people start to realise the potential of this union of technologies.   I’ve been fortunate enough to be able to work with PowerApps on a large enterprise scale project …

“The best time to plant a tree is twenty years ago, the second-best time is now” Chinese Proverb The download count of the tSQLt unit testing framework (http://tsqlt.org) is surprisingly low: Yet this outstanding open-source software can revolutionise your SQL Server development process. Hopefully, this post will show the benefits of test-driven development and including automated …