An authentication mode greyed out in SSMS means the Security page can’t show the value it reads. This post reads the real mode with SERVERPROPERTY, with the registry value SSMS uses and with the error log. It also explains what the two valid values mean and how a bad value is repaired.
SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC
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
How to decode @@OPTIONS value? Session-level SET options live in the @@options variable, and this script turns that number into readable settings.
Scheduler ID Values in dm_os_schedulers: What the Big Numbers Mean
Scheduler ID values in dm_os_schedulers run from 0 up to a few thousand, and then jump past one million. This post groups the rows into user, dedicated admin connection and hidden schedulers, and shows the filter that keeps CPU scripts honest. It also shows why filtering on the number alone is fragile.
Active and Inactive VLFs: List Them for Every Database
To list active and inactive VLFs for every database, count the rows of sys.dm_db_log_info by vlf_active and read the log reuse wait next to them. This post builds a demo log with 24 VLFs, shows how an open transaction and small autogrowth steps add more, and fixes the count with one shrink and one regrow.
Msg 17177 in the SQL Server Error Log: What It Means
Msg 17177 is an informational line in the SQL Server error log that reports the process ID of the instance. This post explains its two forms, a daily line and a start-up line, and reads both with a short query. It also shows how the line reveals uptime, downtime and the time zone of the server.
How to Do Case Insensitive Search? – Interview Question of the Week #267
Question: How to Do Case Insensitive Search?
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.