My friend Sergey Syrovatchenko shares how Delayed Durability helped speed up autotests from 11 to 2.5 minutes on a SQL Server 2014 project.
What Breaks If I Drop This Column? sys.sql_expression_dependencies
Use sql_expression_dependencies and referencing-entity queries before a column change, then check module text and external callers for gaps.
SQL SERVER – Identifying If Database Supports InMemory OLTP Functionality
I had recently received an email about InMemory OLTP Functionality in Email when I was having a vacation with my family in the Australia.
How to Change Fill Factor in SQL Server – Interview Question of the Week #080
It is surprising to see that lots of people do not know that SQL Server Fill Factor 0 (which is the default value when SQL Server is installed) is equal to value as 100.
SQL SERVER – Inspecting Historical CPU Ring Buffer Samples
CPU Usage History helps me establish when a reported problem began. It gives a timeline rather than identifying the responsible query.
Life Lessons – Are There Rules for Interacting With Customers?
I personally don’t claim to know everything and most of my soft skills, learning/techniques has got seasoned over the years. Interacting With Customers
Encrypt PII Data in SQL Server 2016: Notes from the Field #132
To encrypt PII data in SQL Server, first decide where each value must stay readable. Mike Lawell’s guest lesson is kept, and tested examples now show what masking hides, what cell-level encryption protects, and why Always Encrypted rejects plaintext sent from a query window.