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 – Commands
Let us learn how to install SQL Server on Linux in this quick blog post. I have recently worked with a client wanting multiple installations of SQL Server.
SQL SERVER – sys.dm_os_sys_info and Lock Pages in Memory
This time DBA called me as he wanted to know if how to confirm that lock pages in memory is enabled for the SQL Server instance.
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.