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
177 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,398 reads
2020-02-11
20,932 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,502 reads
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,181 reads
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,556 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,762 reads
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Comments posted to this topic are about the item A Partial Count
Comments posted to this topic are about the item The Stagnant Career
Comments posted to this topic are about the item Stairway to Database DevOps Level...
Ask SSC