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
189 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,537 reads
2020-02-11
21,606 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,765 reads
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,205 reads
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,651 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,881 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang, Sumatera Barat...
CSTelpon : 0853-73737551 Jl. Soekarno Hatta No.RT. 29, Batu Ampar, Kec. Balikpapan Utara, Kota...
CSTelpon : 0853-737375516 No, Komplek Balikpapan Baru, Blk. D 1-2, Kota Balikpapan, Kalimantan Timur...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers