Prepare a demo with scripts, clean resets, offline backup material, and a recovery route that keeps the lesson moving when a live step fails.
Opening a Microsoft Support Case: What to Gather First
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.