Deleting Your Entire Production Database by Accident

Most of us have made a mistake that has required the use of a backup. When that mistake affects a production environment, it makes it that much worse. And when that mistake is accidentally deleting your entire production database, it has to be one of the worst nightmares a DBA or developer can have. It happened […]

JSON Support in SQL Server 2016

Since JSON (JavaScript Object Notation) is such a popular and lightweight data interchange format, support for it has been one of the most requested SQL Server features. Microsoft has now added this support to SQL Server 2016. I’m currently using SQL Server 2016 Release Candidate (RC) 0 to experiment with the new JSON features, and […]