March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
open SSMS

SQL SERVER – Open SSMS from Command Prompt

June 15, 2020
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Command, SQL Server Management Studio, SSMS

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.

Read More
add folder

SQL SERVER – Add Folder Paths to the Windows Path Variable for Easy Access

May 9, 2020
Pinal Dave
SQL Tips and Tricks
oStress, SQL Command, SQL Utility, Stress Testing, Windows

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.

Read More
Endpoint Mapper

SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper

March 27, 2020
Pinal Dave
SQL
Computer Network, SQL Command, SQL Error Messages, SQL Server, SQL Setup, SQL Upgrade, Starting SQL

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

Read More
SqlServerWriter

SQL SERVER – SqlServerWriter Missing in vssadmin List Writers Command

January 20, 2020
Pinal Dave
SQL
SQL Command, SQL Error Messages, SQL Function, SQL Scripts, SQL Server, Visual Studio

After troubleshooting they found that when they run vssadmin list writers command from the command prompt, they are not seeing SqlServerWriter.

Read More
Network Drive

How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258

January 5, 2020
Pinal Dave
SQL Interview Questions and Answers
Computer Network, SQL Command, SQL Scripts, SQL Server, SQL Stored Procedure

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. 

Read More
copy files

How to Copy Files in SQL Server? – Interview Question of the Week #257

December 29, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Command, SQL Scripts, SQL Server, SQL Stored Procedure

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.

Read More

SQL SERVER – Script: Find Last System / Operating System Reboot or Restart Time

June 8, 2019
Pinal Dave
SQL Tips and Tricks
SQL Command, SQL Scripts, SQL Server, Starting SQL

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.

Read More
1 2 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version