SQL Vulnerability Assessment Available in SSMS
The SQL Vulnerability Assessment (VA) feature in now available in SSMS (SQL Server Management Studio)!
The SQL Vulnerability Assessment (VA) feature in now available in SSMS (SQL Server Management Studio)!
You are looking at SQL Server, running on Linux, in a Docker container, on my iMac, connected through SQL Operations Studio.
Last week at the annual PASS Summit I served as emcee for the Speaker Idol contest. As a result, this was the first time I would attend all four Speaker Idol sessions. In fact, before last week, I had never attended even one full Speaker Idol session.
Every DBA wants to become an expert in query performance troubleshooting. Not every DBA is willing to put in the time and effort it takes to become an expert.
It was then, right then, at that moment in a hotel lobby piano bar in Barcelona, that I decided I would focus on SQL Server as a career.
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.