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 – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper
When my client was trying to patch the other node, it failed with an error – There are No More Endpoints Available From The Endpoint Mapper
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.
SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights
In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.