POWER uses the base type when returning a result. Cast before calculation when fractional results matter and inspect decimal precision and scale.
ATAN: Understand the Principal Angle of a Ratio
ATAN converts a tangent ratio into a principal angle. The sign and selected interval matter, and a ratio alone cannot recover every original directional quadrant.
SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut
The F6 Shortcut moves focus between SSMS panes. I use it when switching between the query editor and results.
SSMS or VS Code for SQL Server Work
Choose SSMS or VS Code for SQL Server work by task: administration, plans, scripts, MSSQL extension features, and team workflow.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
MVP Open Day 2008 in Goa: the group photograph shared by Allen Bailochan Tuladhar and memories of meeting friends in the MVP community. Read the original account and follow the rest of the Goa event series.
Baselines: Knowing What Normal Looks Like
Build a SQL Server baseline with timestamped workload, wait, and IO samples so you can compare a slowdown with a similar period of normal work.
SQL SERVER – Check Database Integrity for All Databases of Server – DBCC CHECKDB
A quick script to check database integrity for all the databases on a server with DBCC CHECKDB and sp_msforeachdb, and how to read its output.