Authentication in SQL Server identifies the caller through supported identity choices. My GDPR series considered those choices alongside access controls.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Identity Jumping 1000 – IDENTITY_CACHE
Has your identity column ever jumped by 1000 after a restart? SQL Server 2017 fixes it with IDENTITY_CACHE. Here is a demo with the setting ON and OFF.
Kill All Processes for a Database in SQL Server
To kill all processes for a database, set it to SINGLE_USER with ROLLBACK IMMEDIATE and then back to MULTI_USER. This post tests that method against two open sessions, compares it with a KILL script and with RESTRICTED_USER, and explains when each one fits. It also covers what the killed sessions see and why you should not do this on production without asking.
Temporal Table Retention: Cleaning Out Old History Automatically
Set temporal table retention, check history cleanup settings, and choose a history index that lets old versions leave safely.
How to Find DISTINCT COUNT of Column Rows Without Using Distinct Count Keywords? – Interview Question of the Week #157
Only one of ten candidates solved this: find the DISTINCT COUNT of a column without using those keywords. Here are the traditional answer and the trick.
SQL SERVER – DMV to Get Host Information – sys.dm_os_host_info
SQL Server now runs on Linux too, so I check the host first in health checks. Here is how the DMV sys.dm_os_host_info returns Host Information about the OS.
SQL SERVER – GDPR Features and Operational Responsibilities
GDPR Compliance concerns how an organization processes personal data. Reader questions prompted my series about the database controls that can help.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.