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
Orders Data

SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service

October 22, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Installation, SQL Upgrade, Starting SQL

During an upgrade, as soon as they enter the product key and hit next, setup was failing with an upgrade error. Let us learn how to fix the error.

Read More

SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value

September 26, 2019
Pinal Dave
SQL Tips and Tricks
Dedicate Administrator Connection, SQL Error Messages, SQL Memory, SQL Scripts, SQL Server, Starting SQL

My clients contacted me for whom I assisted installation with health check and backup automation. Today we will discuss about max server memory.

Read More
Framework

SQL SERVER – Upgrade Error: Microsoft NET Framework 4.0 Installation Has Failed With Exit Code – 2146498511

August 2, 2019
Pinal Dave
SQL
Cumulative Update, DotNet, SQL Error Messages, SQL Server, Starting SQL

The solution of error Microsoft .NET Framework 4.0 installation has failed with exit code  -2146498511 which was faced during SQL Server upgrade

Read More

SQL SERVER – Script: Find Last System / Operating System Reboot or Restart Time

June 8, 2019
Pinal Dave
SQL Tips and Tricks
SQL Command, SQL Scripts, SQL Server, Starting SQL

Sometimes we need to find last reboot time of the server via some script. In this blog, I am sharing the script to find the last system reboot time.

Read More

SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)

May 20, 2019
Pinal Dave
SQL
Cumulative Update, Docker, SQL Error Messages, SQL Login, SQL Server, SQL Upgrade, Starting SQL

I recently had a very simple and interesting error received while I was performing an upgrade mode with Docker and Persistence Storage for my upcoming workshop.

Read More

When Was SQL Server Last Restarted? – Interview Question of the Week #225

May 19, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Scripts, SQL Server, SQL TempDB, Starting SQL

Question: When Was SQL Server Last Restarted?

Read More

SQL SERVER – SQL Server Configuration Manager Missing from Start Menu

March 1, 2019
Pinal Dave
SQL Tips and Tricks
Registry, SQL Server, SQL Server Configuration, Starting SQL, Windows

Earlier I wrote a blog on the same topic and today I found another way to do the same thing. In this blog, we would discuss the steps you can take to open SQL Server Configuration Manager when its missing from Start Menu in the Windows operating system.

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

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

Go to mobile version