I often see DBAs and Developers using Windows Services App to start or stop the services for applications which totally makes sense. However, I often see the command SHUTDOWN underutilized when it is about turning SQL Server services gracefully. I strongly suggest that people learn and explore this command because in certain scenarios it can come very handy.
In today’s video, we are going to learn about how we can shutdown SQL Server via T-SQL.
However, make sure that you do not use this command on your SQL Server production server accidentally otherwise you will be in trouble if your production system goes down.
Let me know if you are interested to know more about this topic. I will write more blogs as well as create an SQL in Sixty Seconds video.
Here are my few recent videos and I would like to know what is your feedback about them.
- SQL Server on Linux – SQL in Sixty Seconds 162
- Query Ignoring CPU Threads – SQL in Sixty Seconds 161
- Bitwise Puzzle – SQL in Sixty Seconds 160
- Find Expensive Queries – SQL in Sixty Seconds #159
- Case-Sensitive Search – SQL in Sixty Seconds #158
- Wait Stats for Performance – SQL in Sixty Seconds #157
- Multiple Backup Copies Stripped – SQL in Sixty Seconds #156
Reference: Pinal Dave (http://blog.SQLAuthority.com)