Learning
-
Azure Data Studio… I am impressed with what I can do with this tool.. not just basic stuff. You can become a pro. https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017 Download and install it to explore yourself… its backward compatible.
-
Alright, friends here is what I did last week, One interesting feature that came with SQL Server 2016 that can be of good use to us is that we can compress the DB’s backup even if we have TDE enabled on them. There is a small switch that we need to change for doing as…
-
Scenario : When trying to upgrade from lower version to rich upgraded SQL Server version its a sanity check to do UPGRADE ADVISORY REPORT. Cause : When you try to run this report from remote machine this might fail with error message : and this little above message caused havoc in internet for multiple users…
-
Here is what happened and i did panic while answering the blog’s like this… READ THE ERROR MESSAGE VERY CAREFULLY WITH SOUND MIND. DO NOT PANIC. Scenario : Upgrading from 2008R2 Sp2 Standard Edition to 2014 Sp1 Standard CU11. Error : “The upgrade patch cannot be installed by the Windows Installer service because the program…
-
Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
SQLSERVERLABS 