A look at the evolution of Accelerated Database Recovery in SQL Server 2022, with better version store cleanup and scalability for long transactions.
SQL SERVER on Linux – Version Specific Installation References and Commands
SQL Server on Linux installation requires instructions matched to the exact supported releases. My older customer checklist concerned Ubuntu.
LPIM Memory Model: Check It With sys.dm_os_sys_info
The LPIM memory model tells you whether SQL Server runs with locked pages. This post reads it from sys.dm_os_sys_info in one query, confirms it with the process memory view and the error log, and explains what each value means.
Twenty Practice Queries on One Small Schema
Work through twenty practice queries on one small sales schema, with expected results for filters, joins, totals, windows, and gaps.
SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?
“I/O is frozen on database” and “I/O was resumed on database”? Did you check the air conditioner temperature? Let us learn about it in today’s blog post.
Error 17138: Not Enough Memory to Start SQL OS Boot
Error 17138 stopped SQL Server from starting on a server with close to 2 TB of RAM after a client added trace flag 834 for large pages. The large page allocation failed during memory manager initialization. Check max server memory and restart the operating system.
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.