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.
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.
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.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.
Developer – 10 Phrases Developer Use Too Often
I am a developer and so are most of my friends. Here are 10 phrases every developer says too often, from ‘I can fix that’ to ‘That’s not my code’.