A major outage from Atlassian because of a bad script has Steve thinking about the challenges of recovering from mistakes. When we are making changes to portions of our data and we need to plan for mistakes to occur and ensure we can restore the data.
2022-04-22
184 reads
The purpose of this document is to help design Unix shell scripts (or any programming scripts) with restart capability from point of failure and also to avoid a common mistake done by developers/admins while filtering records.
2020-07-09
28,519 reads
2020-02-11
21,552 reads
In this article author Joe Gavin covers how to transfer files using SFTP with a SQL Server Agent job.
2020-01-28
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
6,721 reads
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,191 reads
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,640 reads
Yakov Shlafman brings back the world of the command prompt to make life easier for a DBA that must deploy a series of scripts to their servers.
2008-11-06
12,871 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers