Build a SQL Server home lab with free Developer software, sample data, and a repeatable backup and restore routine on your Windows computer.
How to Check What SQL Server Licensing You Are Actually Using
Check SQL Server licensing evidence with edition and CPU queries, then reconcile visible processors with host inventory and your agreement.
SQL Server Instance or Database: What Is the Difference?
A SQL Server instance is the engine and a database is one set of data inside it. What each level owns, why a login and a user are different objects, and which line to draw when you separate customers or teams.
SQL SERVER – Retrieve SQL Server Installation Date Time
How do I find the SQL Server Installation Date Time? One query on sys.server_principals returns it. A popular question, so here is the answer on the blog.
Running SQL Server in a Container for Testing
Create a SQL Server container for testing from Windows PowerShell, keep data in a named volume, and separate disposable runtime from backups.
How to Check Your SQL Server Version, Edition and Patch Level
Check your SQL Server version, edition and patch level with one query. How to read the build number, why ProductLevel still says RTM on a patched server, and the edition surprise a health check finds most often.
What a Cumulative Update Actually Contains
Understand a SQL Server cumulative update, identify your build and servicing branch, and read fixes and known issues before planning a patch.