A client’s deployment scripts got me curious about PowerShell. Here is how to start querying SQL Server from the command line with a PowerShell script.
SQL SERVER – What is Trace Flag – An Introduction
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 Domain Controller – Interview Question of the Week #072
SQL domain controller questions: can SQL Server run on one? Five interview answers, checked against Microsoft’s current guidance, one corrected.
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 – Handling XML Documents – Notes from the Field #125
Stuart Ainsworth shares a client case of importing XML documents into a staging table and what he learned about using XQuery methods in SQL Server.
SQL SERVER 2016 – Management Studio Highlighting Current Line Option
Something felt odd in SSMS 2016: the current line highlight. Here is the option that controls Highlighting Current Line and how to change it.
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.