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,032 reads
2012-04-25 (first published: 2012-04-02)
2,258 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,007 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,993 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,638 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCU BANGKALAN Telp:0817839777
WhatsApp: 0817839777 Jl. Trunojoyo No.15 A, Pejagan, Kec. Bangkalan, Kabupaten Bangkalan, Jawa Timur 69112
Alamat Kantor BCA KCU PROBOLINGGO Telp:0817839777
WhatsApp: 0817839777 Jl. Suroyo No.28, Tisnonegaran, Kec. Kanigaran, Kota Probolinggo, Jawa Timur 67211
Alamat Kantor BCA KCU TULUNGAGUNG Telp:0817839777
WhatsApp / CS:0817839777 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers