A collection of readers questions from this blog, with answers from other readers, like how to script table rows as INSERT statements and track changes.
Getting Started in the SQL Server Community
Join the SQL Server community through user groups, online events, helpful answers, and a first short talk built from real practice.
Building Your Own Sample Data Set
Build a sample data set with realistic keys, skew, NULLs, and repeatable generation when a downloaded sample misses the lesson.
Keeping Large Blobs Out of Your Main Tables
Large blobs can widen SQL Server access paths and backups; learn to separate payloads, avoid SELECT *, and measure off-row storage behavior.
Preparing a Demo That Does Not Fail on Stage
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.