Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.
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 – Performance Analysis of Backup to Azure
Compression saves backup space, but does it save time too? My Performance Analysis of backup to Azure compares timings with and without compression.
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.
Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101
Expanding tables in WideWorldImporters in SSMS 2016, you see an icon like a watch. It marks a System-Versioned table, also known as a temporal table.