March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
  • Training
GetToken

SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326

March 17, 2020
Pinal Dave
SQL
AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Security

In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO failed with error 1326.

Read More
External Data Sources

SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC

March 16, 2020
Pinal Dave
SQL
PolyBase, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration

In this blog, I would share my findings of error Msg 46530 – External data sources are not supported with type GENERIC. Let us read more…

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
process ID

SQL SERVER – Msg 17177 – This Instance of SQL Server Has Been Using a Process ID of %s since %s (local) %s (UTC)

March 9, 2020
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Error Messages, SQL Log, SQL Server, SQL Server Security, SQL Server Services

In this blog today, I would share my understanding of the message “This instance of SQL Server has been using a process ID of”

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

SQL SERVER – Truncating Data and ANSI_WARNINGS

March 3, 2020
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server 2019, Temp Table

Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Health Check.

Read More
GUID

SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It

February 26, 2020
Pinal Dave
SQL
Service Broker, SQL Error Messages, SQL GUID, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Security

In this blog, I would share my knowledge about how to fix error 15580 – Cannot drop the master key because dialog “GUID” is encrypted by it.

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

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

Go to mobile version