Evaluate new SQL Server features with a focused reading plan, version checks, three relevant experiments, and a record of operational tradeoffs.
Azure SQL Database and SQL Server: What Changes
Compare Azure SQL Database with SQL Server, including jobs, cross-database access, monitoring, backup control, and operational responsibilities.
What a DBA Actually Does All Day
Understand what a DBA does across incidents, prevention, projects, and automation, with practical checks that connect daily work to business risk.
What Is Compatibility Level in SQL Server?
Compatibility level in SQL Server is a per-database setting, and upgrading the server does not change it. Why a restored database keeps the old level, what the setting really controls, and how to raise it without breaking a report.
Keeping Up With SQL Server Without Drowning
Make keeping up SQL Server knowledge manageable with release-note reviews, one deep topic each quarter, and a small record of relevant changes.
What Is Locking and Blocking in SQL Server?
Locking and blocking are not the same thing, and the difference is the whole subject. I blocked a session on purpose and read it from the DMVs. Why short blocking is healthy, and why NOLOCK fixes nothing.
Storing and Querying Locations in SQL Server
Work with spatial data in SQL Server using geography, geometry, matching SRIDs, distance queries, and an index designed for location searches.