Database testing is often skipped until there is a problem. Here is my approach to testing database performance with tSQLt and SQLQueryStress.
SQL SERVER – CREATE OR ALTER Supported in Service Pack 1 of SQL Server 2016
SQL Server 2016 Service Pack 1 introduced CREATE OR ALTER. I use it for repeatable deployments of supported object types.
SQL SERVER – Unable to bring resource online – Error DoREPLSharedDataUpgrade : Failed to create working directory
SQL Server would not come online in the cluster: DoREPLSharedDataUpgrade, Failed to create working directory. The cluster log showed why. Here is the fix.
SQL SERVER – Discovery Report – How to Find Information About Installed Features?
No DBA needed: the Installed SQL Server Features Discovery Report in Installation Center lists every SQL Server feature and version on a machine in one place.
SQL SERVER – Error After Cluster Patching – Error: 5184, Severity: 16, State: 2
SQL Server would not come online after a service pack on a cluster. Here is how ERRORLOG helped me fix this error after cluster patching (error 5184).
![SQL SERVER - Clustered Instance Online Error - SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]](https://blog.sqlauthority.com/wp-content/uploads/2016/11/sql-clus-01.jpg){kind=small}
SQL SERVER – Clustered Instance Online Error – SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]
After a lab restart, the SQL resource stayed Online Pending, then Failed. Here is how the cluster log helped me fix this clustered instance online error.
SQL SERVER – Unable to create login AlwaysOn availability group secondary replica
Creating a login on an AlwaysOn availability group secondary replica failed with Error 3906, database is read-only. Here is why it happens and what to do.