Rahul Sharma

Drop all Connections from a Database

On development servers, at times there is a need for dropping and renaming database(s). These scripts can be used for achieving these tasks. The usp_DropDB script will kill the connections to the database and then drop the database. It takes care of the space in the database name, if any and also makes sure that […]

5 (2)

2001-08-08

3,919 reads

Blogs

On Dynamic Ports, Named Instances, and Firewalls

By

Recently I had a client and their vendor trying to configure a firewall for...

Daily Coping 13 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Read the latest Blogs

Forums

The C in ACID

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The C in ACID

Renting Features

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Renting Features

Basic Git for DBAs: Making Changes in GitHub

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Basic Git for DBAs: Making...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The C in ACID

See possible answers