Audit SQL Server Jobs
In this post I will show you how to audit SQL Server jobs. If anyone adds, deletes, or modifies a job you can track who did what, and when.
SQL Azure
SQL Vulnerability Assessment
Data is the most critical asset that any company owns and Microsoft is making every effort to help protect your data in every possible way.
Why I’m Learning Data Science
When Microsoft announced they were partnering with edX to offer a certificate in Data Science I decided it was the perfect time to dust off my Z-tables.
Azure Cosmos DB Rising in Latest DB-Engines Monthly Rankings
The latest DB-Engines Database Rankings are available, and it shows that Microsoft continues to gain ground on Oracle/MySQL: I’ve been following the DB-Engines ranking for a few years and would encourage you to do the same. The rankings are not an exact science. You can read for yourself how they are calculated. One thing … Read more
The Future For Database Transaction Units
It was just over three years ago that Microsoft introduced the concept of Database Transaction Units (DTUs). To those of us familiar with SQL Server and SQL Database we all had one question: what the hell is a DTU?
View BACPAC Files Using This One Weird Trick
I did not think it was possible to view the contents of a BACPAC file. However, last month while at SQL Bits I was reminded about this one weird trick to view the contents of a BACPAC file.
