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
180 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,489 reads
2020-02-11
21,326 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,619 reads
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,185 reads
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,609 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,832 reads
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
By Rob Sewell
The partner directory connects your agency with new customers.
I had an excellent group of people in Gothenburg Sweden when I taught there...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Hello all, Is there an easy way to output my records to a flat...
Comments posted to this topic are about the item Refactoring Databases: Evolutionary Database Design
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers