What is a trace flag, how do you turn one on, and how do you keep it after a restart? A beginner’s introduction, including the startup parameter option.
SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags
A reader asked if trace flags 1117 and 1118 work for user databases. SQL Server 2016 turns them into the AutoGrow and Mixed_Page_Allocations options.
SQL SERVER – Steps to Migrate Clustered Disk / LUN
This was a clustered instance, so we need to take care of dependency also. Here are the steps which I have outlined for Migrate Clustered Disk.
Primary Key and Null in SQL Server – Interview Question of the Week #071
Can a primary key contain NULL values? No. Here is why primary key and NULL do not mix, and the simple interview question many candidates miss.
PowerShell – Backup SQL Server System Databases
A client visit showed me that basics like system database backups often get missed. Here is a PowerShell way to back up SQL Server System Databases.
List All the Stored Procedure Modified in Last Few Days – Interview Question of the Week #070
In the interview and I end up seeing candidates failing to answer this question about the Stored Procedure Modified recently.
SQL SERVER – Optimizing Tabular Models for Self-Service Reporting: Summarize By – Notes from the Field #123
Bill Anton explains how the Summarize By property helps you optimize Tabular Models for self-service reporting, where users build their own reports.