Quickly Disconnect Users
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
2001-04-21
17,814 reads
Articles
Automatically Gathering Server Information Part 3
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-20
11,169 reads
Process Tracking
It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.
2001-04-18
4,705 reads
Tame Those Strings! Part 3 - Using REPLACE
The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.
2001-04-18
17,077 reads
Tame Those Strings! Part 4 - Numeric Conversions
The fourth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with numeric conversions.
2001-04-18
9,431 reads
Blogs
Is Cataloging Your Data Important?
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
Daily Coping 20 Mar 2023
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Forums
Azure SQL - Restore to lower enviornment
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Bcp queryout issue
Hi all, I am running the following query in SQL, trying to export some...
SQL Server RLS Database Users and Login User Permission
Please suggest practice on SQL Server RLS On the database level, defined users with...
Ask SSC