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.
SQL SERVER 2016 – Encrypt Your PII Data – Notes from the Field #132
Mike Lawell found a client storing personal information in clear text. He explains how SQL Server 2016 encryption options can protect your PII data.
SQL SERVER 2016 – Developer Edition Does Not Expire Like Evaluation Edition
Developer Edition is not the 180-day Evaluation Edition. I check the edition before treating a calculated date as an expiration.
The Row Version Tag: Page Splits After Turning On RCSI
Turn on RCSI and every row you update gets a little bigger. On packed pages that means page splits, and I show the numbers on a small demo table.