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
Intact cases remain in an existing frame beside a prepared target frame and a separate staging bench.

SQL SERVER – Changing Cluster Domains with WSFC and SQL FCI Support Limits

September 16, 2017
Pinal Dave
SQL Tips and Tricks
SQL Domain Controller, SQL Server, SQL Server Cluster

To Move SQL Server Cluster installations between domains, I plan an application-specific migration. The Windows cluster capability alone does not establish SQL support.

Read More
keycertificates

Domain Controller – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved

June 16, 2017
Pinal Dave
SQL Tips and Tricks
SQL Domain Controller, SQL Error Messages, SQL Server, SQL Server Encryption, SQL Server Security

SQL Server would not start under a domain account when a Read Only Domain Controller (RODC) was involved. Here is what fixed it.

Read More
Diagram of three nodes in DomainOld, Node-01 behind the listener with Node-02 on synchronous automatic failover and Node-03 on asynchronous manual failover, and the 12 migration steps grouped into four stages

New AD Domain: Moving an AlwaysOn Availability Group Node by Node

February 11, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Domain Controller, SQL Mirroring, SQL Server

After an acquisition, my client had to move an AlwaysOn availability group to a new AD domain. These are the 12 steps I shared, moving one node at a time from DomainOld to DomainNew.

Read More
Separate locked stone buildings hold tools and keys on opposite sides of a small courtyard

SQL Domain Controller – Interview Question of the Week #072

May 22, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Domain Controller, SQL Server

SQL domain controller questions: can SQL Server run on one? Five interview answers, checked against Microsoft’s current guidance, one corrected.

Read More
A narrow post office service window revealing only a few wooden pigeonholes of the sorting wall behind it.

Querying Active Directory From SQL Server

September 16, 2007
Pinal Dave
SQL Tips and Tricks
Linked Server, SQL Domain Controller, SQL Server, SQL Server Security

Querying active directory through an ADSI linked server can answer narrow questions, but its limits favor staged data for repeatable work.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

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