Can someone quietly edit your audit table? With an append-only ledger and a stored digest, the answer becomes no, and you can prove it.
SQL SERVER – How to Find Weak Passwords Using T-SQL?
After a hacker got in through the sysadmin account, a reader asked for help. Here is how to find weak passwords for SQL logins using T-SQL.
OPENROWSET vs Linked Servers: Querying Another Server Safely
Compare OPENROWSET and linked servers, inspect login mappings, keep filtering remote, and review authentication and encryption before use.
SQL SERVER – Iterating over Metadata with BimlScript – Notes from the Field #061
Reeves Smith continues his Biml series and shows how iterating over metadata with BimlScript helps automate repetitive SQL Server BI work.
SQL SERVER – Performance Tuning – Is It Really A Top Skills for a SQL Server Consultant? – Notes from the Field #059
The world needs more Performance Tuning consultants, but is tuning really the top skill for a SQL Server consultant? Brian Moran answers from a business view.
Operating System Error 5 on Backup: Fix Access Denied
Operating system error 5 means Windows refused the SQL Server service account access to a backup folder. This post reproduces the error, shows how to find the account with a query, grants the permission, and explains the look-alike errors for missing paths and mapped drives.
SQL SERVER – Beginning with SQL Server Security Aspects
A high-level overview of SQL Server security aspects and best practices, starting with the often overlooked physical security of the server itself.