Beginning In-Memory OLTP in SQL Server 2014 is easier than it looks. I explain why we need it in simple words, with a sample example to get you started.
FORMAT vs CONVERT: The CPU Cost of Pretty Dates
FORMAT makes dates look nice, but it costs CPU on every row. Here is the gap, and where it hurts most.
SQL SERVER – Flushing Transaction Log to Disk for Current Database
A reader using delayed durability asked how to be sure every log record reaches the disk. This is how flushing transaction log to disk works for a database.
Choosing a Technical Conference Worth Attending
Choose a technical conference by matching sessions and audience to your skill goals, then counting the full cost before you book.
Hey DBA – Go Make a Proactive Investment Today! – Notes from the Field #045
Mike Walsh explains why every DBA should be proactive, then gives all of us one challenge to complete: make a proactive investment today.
Delayed Transaction Durability Explained: SQL in Sixty Seconds #074
Delayed transaction durability lets a commit return before its log record reaches the disk. This post explains the idea and the three settings, then measures 10,000 small transactions on SQL Server 2025 and shows the one risk with a log write count. It ends with a simple rule for using it safely.
SQL SERVER – Delayed Durability Database Level and Transaction Level
A reader asked how database level and transaction level durability settings interact when they conflict. I simplify the MSDN grid for delayed durability.
Example of Delayed Durability: How Much Faster Are Commits?
This example of delayed durability runs 50,000 small transactions on SQL Server 2025 four ways and compares time and log writes. It shows what the database setting and the commit option change, and what you risk.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
How do you setup Delayed Durability in SQL Server 2014? Here are three methods, starting at the database level with ALTER DATABASE SET DELAYED_DURABILITY.
SQL SERVER – Basics of Delayed Durability in SQL Server 2014
SQL Server 2014 adds Delayed Durability, which puts performance ahead of durability. I explain it in simple questions and answers, starting with full durability.










