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.
float vs decimal: Why Money Should Never Be float
Compare float vs decimal for currency, inspect approximate arithmetic, and use explicit decimal precision and rounding rules.
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.