DEGREES converts radians into degrees. An integer radian argument can narrow the output, while a float argument retains an approximate fractional degree value.
Preview Builds: What You May and May Not Do With Them
Preview Builds are useful for SQL Server evaluation when you check license terms, isolate test data, and plan for disposal instead of upgrade.
Onboarding a New DBA
Onboarding a new DBA starts with safe access, a server map, tested runbooks, and a first month of supervised operational tasks.
SQL SERVER – 2005 – Best Practices for SQL Server Health Check
Best practices for a SQL Server Health Check: run one every 6 to 12 months, document everything, and plan fixes afterward instead of fixing during the check.
SQL SERVER – Generate Script with Data from Database – Database Publishing Wizard
The Database Publishing Wizard scripted schema and data for SQL Server 2005-era transfers. I keep that workflow separate from current SSMS instructions.
Comparing Server Settings Across Instances
Comparing server settings across SQL Server instances shows configured and live values, so you can judge which differences affect a workload.
TOP WITH TIES: Keep Every Row at the Cutoff
TOP WITH TIES helps me keep equally qualified rows at a shortlist boundary. A unique ordering key changes that selection. Separate the cutoff rule from the final display order.