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
221 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,575 reads
2020-02-11
21,682 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,809 reads
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,236 reads
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,689 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,918 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Telp/Wa 628218200233 Komp. Taman Harapan Indah Blok EE No.1, RT.14/RW.7, Jelambar Baru, Kec. Grogol...
Telp/WA 628218200203 Rukan Multiguna, Jl. Rajawali Selatan Raya Blok C5. 2, Blok 2, Pademangan...
Telp/Wa 628217555651 Mal No. RM, Jl. Mangga Dua Raya No.49, RT.1/RW.12, Mangga Dua Sel.,...
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers