Use SQLMap to Connect Directly to Azure SQL Database

Use SQLMap to connect directly to azure SQL database

I’ve written before about using sqlmap to perform sql injection testing against a website. It is also possible to use sqlmap to connect directly against a database. In this post I will show you how to use sqlmap to connect directly to Azure SQL Database. Once connected you can enumerate objects, open a shell, or … Read more

Modify SQL Audit for Azure SQL Database

Modify SQL Audit for Azure SQL Database

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

Why AWS and Azure Benchmarks Don’t Matter to Me

AWS and Azure benchmark

Last October I wrote a review of the Gigaom SQL Transactional Processing Price-Performance test. That post references the original data warehouse test also published by Gigaom. I believe both Gigaom reports were funded by Microsoft. I found the first report on data warehousing to be of good quality. The SQL transaction report had some weak … Read more

Sequence Contains No Elements

Sequence contains no elements

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

Thoughts on the VividCortex Acquisition

VividCortex and SolarWinds

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