SQL Server Science
Technical Articles for the DBA / Developer
Home » configuration

Azure SQL Managed Instance Differences That Catch DBAs During a Migration

2026-11-15 · by Hannah Vernon · in configuration

Azure SQL Managed Instance differences from SQL Server that affect a migration, checked against Learn, plus a read-only query to find them on-premises.

Reviewing Max Server Memory and Lock Pages in Memory

2026-11-11 · by Hannah Vernon · in configuration

A read-only query to review max server memory, min server memory and Lock Pages in Memory across many SQL Server instances, tested on 2019 and 2025.

Configuration Drift Between SQL Server Instances: Comparing sys.configurations to a Saved Baseline

2026-11-01 · by Hannah Vernon · in configuration

Save sys.configurations from each SQL Server instance to a baseline table, then find options that differ, are missing, or need RECONFIGURE or a restart.

Logins, SIDs, and Kerberos from First Principles, Part 8: Auditing Logins with Service Broker

2026-08-17 · by Hannah Vernon · in configuration, security

The series so far has answered who can connect ( showed even that requires asking Windows) and how they prove it ( and ). The closing question is who actually does. Group-based access means the…

Logins, SIDs, and Kerberos from First Principles, Part 5: Windows Groups and the Invisible Members

2026-08-14 · by Hannah Vernon · in configuration, security

Every post in this series so far has dealt with principals you can see: a login row in sys.server_principals with a name and a SID. Windows groups break that comfortable assumption. Grant a group a…

Logins, SIDs, and Kerberos from First Principles, Part 4: Scripting Every Permission a Principal Holds

2026-08-13 · by Hannah Vernon · in configuration, security

moved logins between servers with their SIDs and passwords intact. That gets a principal through the front door; it says nothing about what the principal can do once inside. Permissions live in a different set…

1 2 … 4 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • Data Architecture
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • High Availability
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • Opinion
  • performance
  • PostgreSQL
  • Professional Development
  • recovery
  • reporting
  • ROLLBACK;
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About Hannah Vernon
  • About SQL Server Science
  • Blog Series
    • Backup & Recovery from First Principles: Series Contents
    • Database as a Versioned Contract: Series Contents
    • Extended Events in Production: Series Contents
    • Git for DBAs: Series Contents
    • How SQL Server Stores Data: Series Contents
    • Logins, SIDs, and Kerberos from First Principles: Series Contents
    • Proving the Restore: Series Contents
    • T-SQL Style Guide, Tested: Series Contents
    • The UNKNOWN Problem: NULL Traps in T-SQL, Series Contents
    • Undocumented Changes in SQL Server 2022 and 2025: Series Contents
    • Work That Flows: Kanban for DBAs: Series Contents
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • Privacy Policy

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2026 SQL Server Science