SQL Server auditing is a hidden gem. Learn how to change the audit location after it is created, for example when a network share fails.
SQL SERVER – Fix – Msg 230, Level 14, State 1 – The SELECT permission was denied on the column of the object , database , schema
Hide a sensitive column like SSN with GRANT and DENY, and users who query it get Msg 230, SELECT permission was denied. Here is a simple walk-through.
SQL SERVER – User Defined Audit with SQL Server
Bank security checks taught me patience about audits. Here is how a user defined Audit in SQL Server lets you write your own events to the audit log.
SQL SERVER – Filtering CPU Bound Execution Plans with Extended Events
Profiler captures every plan or none. With query_post_execution_showplan, Extended Events can capture only CPU bound execution plans in SQL Server 2012.
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 – FIX – Msg 4864, Level 16, State 1 – Bulk load data conversion error
Readers of my BULK INSERT post hit Msg 4864, Bulk load data conversion error, and Msg 4860. I show how to reproduce and fix these errors.
SQL SERVER – What is Hypothetical Indexes?
Why does sys.indexes show 7 indexes when Object Explorer shows only one? The answer is hypothetical indexes. Here is what they are.