2016-04-01 (first published: 2016-03-23)
852 reads
2016-04-01 (first published: 2016-03-23)
852 reads
2015-12-25 (first published: 2015-12-17)
1,693 reads
2015-10-09 (first published: 2014-03-21)
4,965 reads
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,768 reads
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)
893 reads
A script that will help you deal with and get through any disaster recovery situation.
2005-04-01 (first published: 2005-03-29)
532 reads
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
556 reads
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,500 reads
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,515 reads
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
984 reads
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers