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.
SQL SERVER – Common Sense Data Security – Notes from the Field #055
Kevin Hazzard explains common sense data security for sensitive user information, with humor and real world examples you will recognize.
SQL SERVER – Validation Rules: Code or Database? – Notes from the Field #054
Should validation rules live in the .NET app layer or in the database? G. Andrew Duthie looks at this common argument between developers and DBAs.
SQL SERVER – Using Bitwise And (&) Instead of a Junction Table – Notes from the Field #053
Stuart Ainsworth shows a cool trick: using Bitwise And (&) instead of a junction table to get more performance with fewer code changes.
Linked Server Logins: Stop Mapping Everyone to sa
Audit linked server logins for blanket remote sysadmin mappings, test with a low-privilege identity, and replace broad access safely.