Recently one of my clients asked me if I know any way to open SSMS via Command Prompt. Of course, it is possible to do that in Windows.
SQL SERVER – Add Folder Paths to the Windows Path Variable for Easy Access
I was working with a DBA and he asked me question if thee any way to Add Folder Paths to the Windows Path Variable for Easy Access.
SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper
When my client was trying to patch the other node, it failed with an error – There are No More Endpoints Available From The Endpoint Mapper
SQL SERVER – SqlServerWriter Missing in vssadmin List Writers Command
After troubleshooting they found that when they run vssadmin list writers command from the command prompt, they are not seeing SqlServerWriter.
How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258
Question: How to Map Network Drive as Fixed Drive in SQL Server?
love little problems like this one as they are indeed a lot of fun to resolve.Â
How to Copy Files in SQL Server? – Interview Question of the Week #257
Question: How to Copy Files in SQL Server?
Answer: SQL Server 2019 has very interesting features that can make a life of DBA’s and Developers very easy.
SQL SERVER – Script: Find Last System / Operating System Reboot or Restart Time
Sometimes we need to find last reboot time of the server via some script. In this blog, I am sharing the script to find the last system reboot time.