All Articles - SQL Authority with Pinal Dave

SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size

March 19, 2020

File Growth, SQL Error Messages, SQL FileGroup, SQL Log, SQL Scripts, SQL Server, SQL Server Configuration

Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647

SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?

March 18, 2020

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security

I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?

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.

All Articles External-Data-Sources-600x245

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…

How to Decode @@OPTIONS Value? – Interview Question of the Week #268

March 15, 2020

Pinal Dave

SQL Interview Questions and Answers

SQL Options, SQL Scripts, SQL Server

The session-level options can be found using the @@options variable in SQL Server. Let us decode that in this blog post and learn about it.

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.