Azure SQL Database has no service to restart, yet a customer showed me a way to restart SQL Azure database. Here is how, and why a restart is only a band-aid.
Moving From Express to Standard Without Reinstalling
Plan how to upgrade SQL Server edition from Express to Standard, preserve the instance, and verify databases and applications after setup.
SQL SERVER – Fix: Error – VS Shell Installation Has Failed with Exit Code 1638
A customer’s SQL Server 2017 install kept failing with “VS Shell installation has failed with exit code 1638”. Here is what caused it and how we fixed it.
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
A SQL Server 2012 install failed with an error while enabling windows feature NetFx3. Here are the steps to turn on .NET Framework 3.5 in Server Manager.
Installation Error – Updating Permission Setting for File Failed
A brand-new SQL Server 2016 install failed at the end with: Updating permission setting for file failed. Here is the quick fix for this installation error.
SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server?
A DBA friend ran Edition Upgrade from Standard to Enterprise, setup finished with no errors, yet SQL Server still showed Standard Edition. Here is why.
SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet
SQL Server setup warned on the Microsoft .NET Application Security rule because the computer cannot access the Internet. Here is what it means and what to do.