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.
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.
SQL SERVER – Beginning Table Valued Constructors – Notes from the Field #052
Kathi Kellenberger explains Table Valued Constructors, a relatively unknown topic, in the 52nd episode of my Notes from the Field series.