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 ...

Two existing SAP partners, Snowflake and Databricks, offer similar services, but there are key differences in Dremio's offerings that may speak to enterprise IT AI fears. The gap between human and AI ...

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 ...