For years, String or binary data would be truncated never told us which column was too long. Now SQL Server does, and here is how to identify the column responsible.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151
Another SQL Server upgrade failure: upgrade step SSIS_hotfix_install.sql hit error 15151 because a user did not exist. Here is how I fixed it.
SQL SERVER – Error in Validation: Listener in Workgroup – Unable to determine if the computer exists in the domain ‘WORKGROUP’
A client’s domain-less Always On cluster in Azure could not create a listener: Unable to determine if the computer exists in the domain ‘WORKGROUP’. Here is why.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘msdb110_upgrade.sql’ Encountered Error 8649, State 1, Severity 17
Patching SQL 2017 failed at msdb110_upgrade.sql with error 8649: the query cost exceeded the configured threshold. Here is the cause and the fix.
SQL SERVER – Stretch Database – Free Trial Subscriptions Can Provision Basic, Standard S0 through S3 Databases, up to 100 eDTU Basic or Standard Elastic Pools and DW100 Through DW400 Data Warehouses
Stretch Database failed again for a reader. The log said Free Trial subscriptions can provision only Basic and Standard S0 through S3 databases.
SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)
One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s)
SQL SERVER – Stretch Database – ERROR: The Provided Location is Not Available for Resource Group
This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message.