This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Title card: PolyBase Error Msg 46530

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

March 16, 2020
Pinal Dave
SQL Tips and Tricks
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
SQL Server VSS backup sequence: freeze writes, take snapshot, then resume writes. Investigate if the pause persists.

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 Tips and Tricks
SQL Backup and Restore, 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
Title card: Setup Account Does Not Have 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 Tips and Tricks
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
Title card: Error 15580: Cannot Drop Master Key

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

February 26, 2020
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Datatype, SQL Error Messages, 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
Title card: Unable to Allocate Enough Memory to Start 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 Tips and Tricks
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
Previous 1 2 3 4 5 6 7 8 … 117 Next
  • Books
  • Testimonials
  • Privacy Policy

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