A reader asks why you need the -Force flag to stop services with PowerShell but not to start them. I do not know the answer, so I am asking you.
Disabling All Agent Jobs During a Freeze and Restoring Their State
Enable-all after a freeze wakes up jobs that were off on purpose. Save the starting state and put back exactly that.
Reading DBCC SHOW_STATISTICS Step by Step
Read SHOW_STATISTICS headers, density and histogram boundaries, compare estimates with your plan, and query the histogram directly.
SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009
John Sterrett shows how Central Management Server lets a DBA run the same query on many SQL Server instances at once, a handy tool for proactive DBAs.
Counting Rows per Month With Zero-Filled Gaps
Build monthly counts with zero-filled gaps, generate a complete month range, and retain empty categories through a reporting scaffold.
Ranking Items by Rating Fairly With a Bayesian Average
Use Bayesian average in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.