At SQL Server Live last November, I demonstrated enabling SQL Audit for Azure SQL Database. During the class discussion I explained you must use Powershell to modify SQL Audit for Azure SQL Database. So, that’s my post today, showing you how it is done. By default, SQL Audit for Azure SQL Database will enable the … Read more
I came across this “Sequence contains no elements” error when using Always Encrypted a while back and wanted to write a quick post. In this case, I was trying to encrypted a computed column. Here’s the underlying error message: The full list of supported columns are found here. I can clearly see ‘Computed columns’ as … Read more
Last month, SolarWinds completed the purchase of VividCortex, a database performance monitoring solution for popular open source systems such as PostgreSQL, MongoDB, MySQL, Amazon Aurora, and Redis. I was fortunate to visit Austin about a week after the purchase. During my visit I met with members of the VividCortex team. We had deep discussions about … Read more
For years I have written a year end post about things that didn’t happen to me for the previous twelve months. This year I’ve decided to pivot that theme. Instead of a post all about me, it’s now a post about you. Well, you and all the stupid and horrible things you do all year … Read more
My final event of the year will be Black Hat Europe in London, the first week in December. This will be my second Black Hat event; the first was this past August when me and 20,000 of my closest security professional friends invaded Las Vegas. I know it may seem odd for a career database … Read more
I’ve already written a post about how dashboards are a horrible way to communicate. I’m here today to remind you that your dashboards still suck. Let’s start with the most recent example. This image is a useless piece of information. I’m certain somewhere there is a developer proud of how they took a donut chart … Read more
