June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Accelerated Database Recovery

The Evolution of Accelerated Database Recovery in SQL Server 2022

November 14, 2023
Pinal Dave
SQL Tips and Tricks
Accelerated Database Recovery, SQL Backup, Starting SQL

At its core, Accelerated Database Recovery is a revolutionary SQL Server feature that dramatically boosts database availability.

Read More
SQL Server on Linux

SQL SERVER on Linux – Commands

May 11, 2021
Pinal Dave
SQL Tips and Tricks
Linux, SQL Server, SQL Server Installation, Starting SQL

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.

Read More
Lock Pages in Memory

SQL SERVER – sys.dm_os_sys_info and Lock Pages in Memory

June 19, 2020
Pinal Dave
SQL Performance
SQL Memory, SQL Server, SQL Server Security, Starting SQL

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.

Read More
Endpoint Mapper

SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper

March 27, 2020
Pinal Dave
SQL
Computer Network, SQL Command, SQL Error Messages, SQL Server, SQL Setup, SQL Upgrade, Starting SQL

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

Read More
frozen

SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?

March 14, 2020
Pinal Dave
SQL
SQL Backup, SQL Error Messages, SQL Server, Starting SQL, System 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.

Read More
administrator rights

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

March 4, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Server, SQL Server 2019, SQL Server Installation, SQL Server Security, Starting SQL

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.

Read More
SQL OS Boot

SQL SERVER – Unable to Allocate Enough Memory to Start ‘SQL OS Boot’. Reduce Non-essential Memory Load or Increase System Memory

February 24, 2020
Pinal Dave
SQL
In-Memory OLTP, SQL Error Messages, SQL Performance, SQL Server, Starting SQL

In this blog, I would share my learning about error “Unable to allocate enough memory to start ‘SQL OS Boot’. Let us learn the workaround.

Read More
1 2 3 4 … 15 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version