A stored procedure calling sp_trace_create failed with Msg 19062, could not create a trace file, Error 0x80070005. Here is what that code means and the fix.
SQL SERVER – Database Mirroring Error -The Specified Network Name is No Longer Available
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.
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.
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.
SQL SERVER – Unable to Bring Resource Online – Error – Could Not Find Any IP Address that this SQL Server Instance Depends Upon
A clustered SQL Server could not find any IP address it depends upon, so it would not start. Here is how to fix it and bring the resource online.