2012-01-20 (first published: 2011-12-16)
1,019 reads
Scripts
create jobs script for 2000 2005 or 2008
will create jobs script for backup or DR purposes to install on another server.
2012-01-18 (first published: 2011-12-15)
2,168 reads
poor mans archival of backup files and tran logs to alternate location
This script will backup your files that have changed only. old files will not be copied just newer ones.
2012-01-17 (first published: 2011-09-20)
719 reads
Create bank holidays table
Do you know what happens if a holiday falls on a weekend? This script will help you.
2012-01-16 (first published: 2011-12-14)
3,080 reads
Who did what?
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)
4,215 reads
Display row value as a TABLE column using SQL select statement
Display row value as a TABLE column using SQL select statement
2012-01-12 (first published: 2007-10-26)
4,727 reads
2012-01-11 (first published: 2008-04-16)
5,172 reads
Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
5,423 reads
2012-01-09 (first published: 2007-11-13)
4,909 reads
2012-01-06 (first published: 2008-02-15)
7,312 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Alamat kantor BCA KCP Renon Telp:08218154398
WhatsApp:0821-8154-398 Jl. Raya Puputan No.10, Panjer, Denpasar Selatan, Kota Denpasar, Bali 80226
Alamat kantor BCA KCP Bantul Telp (0817)-866887
Wa:0817-866-887 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
ALAMAT KONTAK BCA KCP Blok M Telp:08218154393
WA:08218154393 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers