Restricting access to contained databases: a DBA friend wanted to limit which users can connect, and logon triggers can do that. Here is how.
SQL SERVER – How to Chang Audit Location?
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 – 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 – 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.
Why SELECT 28F3 Returns 28: Float Literals and Hidden Aliases
Explain float literals, why SELECT 28F3 creates an alias, how 28E3 uses scientific notation, and why explicit AS prevents confusion.










