2012-04-30 (first published: 2012-04-04)
676 reads
Scripts
Log Shipping - How you can convert the secondary database into primar
This topic explains the log shipping if the primary database is suspected or corrupted and how you can convert the secondary database into primary database.
2012-04-27 (first published: 2012-03-31)
1,015 reads
2012-04-26 (first published: 2012-04-02)
1,033 reads
2012-04-25 (first published: 2012-04-02)
2,259 reads
2012-04-24 (first published: 2012-03-30)
1,854 reads
Operators With Jobs and Notifications
This script will list the operators that have jobs
that are configured to notify them with alerts.
2012-04-23 (first published: 2012-03-29)
1,004 reads
Find Database Recovery Mode
The scripts provided below will show you the "Recovery Mode (Model)" for any given database
2012-04-19 (first published: 2008-03-18)
2,009 reads
Find for SQL Objects, Entities or Text
Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.
2012-04-18 (first published: 2008-05-28)
2,994 reads
2012-04-17 (first published: 2008-02-15)
7,468 reads
Check owners, collations and backups
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,639 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 BCA KCP Tomang Tol Telp:08218154393
Wa:0817819444 Jl. Arjuna Utara No.Kav. 8 A, RT.1/RW.1, Tj. Duren Sel., Kec. Grogol petamburan,...
ALAMAT BCA KCP Radio Dalam Telp:08218154393
Jl. Radio Dalam Raya No.5 B-C, RT.9/RW.13, Gandaria Utara, Kec. Kby. Baru, Kota Jakarta...
Alamat kantor BCA KCP Renon Telp:08218154398
WhatsApp:0821-8154-398 Jl. Raya Puputan No.10, Panjer, Denpasar Selatan, Kota Denpasar, Bali 80226
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers