Prepare a Microsoft support case with version details, a clear timeline, error logs, system_health, dumps, LogScout, and redaction notes.
SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results
A friend’s SSMS window returned only Command(s) completed successfully for every query. I logged in remotely and found what was wrong with that session.
SQL SERVER – DMV Error: FIX: Error: Msg 297, Level 16 The user does not have permission to perform this action
Msg 297 appears when a user runs a DMV without the right permission. Ask your admin to GRANT VIEW SERVER STATE, and the DMV runs without errors.
SQL SERVER – Get Server Version and Additional Info
Most people check the SQL Server version with @@VERSION. I also like xp_msver, which shows extra details about the server where SQL Server is installed.
Practicing Azure SQL at Low Cost
Practicing Azure SQL can stay inexpensive with current free offers, serverless auto-pause, budget alerts, and deliberate resource cleanup.
Merge Subscription Initialization Without a Snapshot
Initializing a merge subscription without a snapshot requires more than matching table names. Prepare the schema, data and replication metadata, account for local changes and plan recovery for the actual replication topology.
Staying Current Without Chasing Every Update
Staying current on SQL Server takes a repeatable CU cadence, fast security response, and a patch policy your team can actually keep.
SQL SERVER – Find Busiest Database
How do you find the busiest database on a SQL Server instance? I use sys.dm_exec_query_stats to add up logical reads and writes for each database.
A Migration Cutover Checklist
A migration cutover checklist covers final backup, logins, jobs, linked servers, DNS, validation, and an explicit go or no-go decision.
SQL SERVER – Fragmentation – Detect Fragmentation and Eliminate Fragmentation
What is fragmentation, and how do you detect fragmentation and eliminate it? I explain the internal and external types and what each one does to your pages.