A client’s ERRORLOG showed database mirroring error 1474, ‘The specified network name is no longer available’. The cause was outside SQL Server.
SQL SERVER – Best Practices About SQL Server Service Account and Password Management
Should the SQL Server Service Account be a local or domain admin? No. Best practices from a client Q&A on service accounts, permissions and passwords.
How to Find Longest Running Query With Execution Plan – Interview Question of the Week #098
How do you find the longest running query with execution plan in SQL Server? Here is a quick DMV query that returns the top 10 along with their plans.
SQL SERVER 2016 – DBCC Command Enhancement with MAXDOP
SQL Server 2016 lets you set MAXDOP on DBCC checks like CHECKDB. Here is how this DBCC Command enhancement works and how to use it.
Telling Which Platform You Run On With SERVERPROPERTY EngineEdition
Read EngineEdition with edition and version properties, select platform-aware diagnostics, and avoid treating an engine family as a license.
Columnstore Segment Elimination: Loading Data So Scans Skip Work
See how segment elimination skips columnstore work by checking segment metadata, measuring scans, and loading rows in a useful order.
In-Place Upgrade or Side by Side: Choosing Properly
Compare an in-place upgrade with a side-by-side SQL Server migration, including downtime, testing, dependencies, and recovery after cutover.