Restoring SQL Server Database on Linux Using SQL Operations Studio
You are looking at SQL Server, running on Linux, in a Docker container, on my iMac, connected through SQL Operations Studio.
MSSQL
Becoming a Query Performance Troubleshooting Expert
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.
Using sqlmap to Test For SQL Injection Vulnerabilities
I use sqlmap to test websites for SQL injection vulnerabilities. The tool is quite versatile, too. Here’s just a brief list of capabilities.
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 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.
Killing the “SQL Server is a Memory Hog” Myth
At least once a week I read or hear the familiar refrain, “SQL Server is a memory hog,” or “SQL Server uses all the memory.”
