Welcome to my box of tricks (SQL scripts) for Microsoft SQL Server instance and database administration! I've put considerable effort, over many years, into creating my own scripts, as well as ...

SUM (user_object_reserved_page_count)*8 as user_obj_kb, SUM (internal_object_reserved_page_count)*8 as internal_obj_kb, SUM (version_store_reserved_page_count)*8 as ...

A first look at Pyrefly 1.0 Pyrefly, the Python type checker and linter from Meta, has just dropped its first full 1.0 release. It’s intended to be a solid alternative to existing type ...

For developers doing complex database administration work on SQL Server, SSMS remains the most complete GUI available. Azure Data Studio handles day-to-day query work effectively, but SSMS has deeper ...

In today’s data-driven world, the ability to visualize and interpret complex datasets has become a crucial skill. Businesses, non-profits, and government agencies alike rely heavily on data to make ...