How in-memory OLTP engines give faster application performance and better scalability for SQL Server databases, with a focus on SQL Server 2014.
When In-Memory OLTP Helps and When It Does Not
Learn when In-Memory OLTP can reduce transaction contention, which limitations still matter, and what to measure before changing tables.
What the Cardinality Estimator Does and When It Is Wrong
Understand how the cardinality estimator predicts rows, why estimates go wrong, and which statistics and plan checks help you investigate.
MySQL Habits That Trip Up Developers Moving to SQL Server
Replace six MySQL habits with SQL Server equivalents for LIMIT, AUTO_INCREMENT, quoting, GROUP BY, duplicate inserts, and collations.
Building a SQL Server Home Lab That Costs Nothing
Build a SQL Server home lab with free Developer software, sample data, and a repeatable backup and restore routine on your Windows computer.
Backing Up to Azure Blob Storage
Backing up to Azure blob storage with SQL Server requires scoped SAS credentials, block blob targets, tested striping, and a real restore drill.
Watching Live Data With the XEvent Profiler
XEvent Profiler in SSMS offers live Standard and T-SQL event views; a focused Extended Events session serves repeat investigations.