2016-04-01 (first published: 2016-03-23)
809 reads
Steve Jones
- Interests: yoga, reading, biking, skiing, volleyball
2015-12-25 (first published: 2015-12-17)
1,647 reads
2015-10-09 (first published: 2014-03-21)
4,731 reads
Check if SQL Server is running
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,691 reads
SS2K - sp_helprevlogin`
Old version, archived, that works on ss2k. Updated version works on ss2k5. NOTE: This is a Microsoft developed script, not from the contributor (Steve Jones)
2007-06-27 (first published: 2006-05-04)
872 reads
All Encompassing Disaster Recovery Script
A script that will help you deal with and get through any disaster recovery situation.
2005-04-01 (first published: 2005-03-29)
514 reads
Stored Procedure to Backup all files
This stored procedure performs a full backup on all databases on a server. It takes a parameter for a drive letter and will create the backup structure as needed. The standard backup structure is "\mssql\backup\".
2001-10-22
533 reads
Kill spids that are idle
Ever wanted to get rid of users who are sitting idle for long periods of time? Here's a script that removes spids idle for a variable period of time.
2001-10-03
4,439 reads
Trim Backup Files
This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]
2001-09-12
1,465 reads
Idle Spid Time
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
905 reads
Blogs
Speaking about Latches & Spinlocks at the EightKB Online Conference
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
SQL server Linux and SQLCMD
By Arun Sirpal
Following on from a previous blog post (https://blobeater.blog/2021/01/15/sql-server-linux/) on installing SQL Linux, a common...
Azure Platform Series: cloudshell code -your (brilliant) online editor
By HeyMo0sh
This post is about code which is an online editor you can use with...
Forums
Error in bcp query out
I've been playing around wiht bcp out the data into csv file but been...
Multi subnet failover cluster
My goal is to have an FCI across 2 nodes with shared storage (node...
Power Query or SQL Server? Which, when and why
Comments posted to this topic are about the item Power Query or SQL Server?...
Ask SSC