Tune Workloads, Not Queries
Ask three DBAs about their preferred performance tuning methodology and you will get back seven distinct answers.
SQL MVP
101 Ways to Say NO to SysAdmin Requests
As an admin, you often get requests from developers asking for elevated permissions on servers and systems. Inside of SQL Server, this is called ‘sysadmin‘ access. As you can imagine, it is not a good idea to give this level of access to just anyone. I thought I would write a post to help you … Read more
Microsoft Data Platform MVP – Still Crazy After All 12 Years
This past week I received another care package from Satya Nadella. Inside was my Microsoft Data Platform MVP award for 2020-2021. I am happy, honored, and humbled to receive the Microsoft Data Platform MVP award for the twelfth straight year. I still recall my first MVP award and how it got caught in the company … Read more
SQL Plan Warnings
There are many methods available for optimizing the performance of SQL Server. One method in particular is examining your plan cache, looking for query plan warnings. Plan warnings include implicit conversions, key or RID lookups, and missing indexes to name a few. Each of these warnings is the optimizer giving you the opportunity to take … Read more
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
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
