2014-08-18 (first published: 2014-07-28)
1,258 reads
Scripts
2014-08-15 (first published: 2014-07-16)
1,553 reads
Generate Restore script for multiple databases
Restore script for moving databases from prod to dev with different path / logical name etc.
2014-08-14 (first published: 2014-05-30)
5,915 reads
2014-08-11 (first published: 2014-05-28)
1,794 reads
Script to generate the SQL to create a fulltext catalog and its underlying fulltext index
This script was published originally on http://humakhurshid.blog.com/2011/07/14/script_out_fulltext_catalog/
The author has tweaked it little bit to improve it.
2014-08-07 (first published: 2014-07-02)
5,806 reads
Move End of Month file from source to destination
The script below executes on the first of every month and moves files from source to destination location.
2014-07-24 (first published: 2014-06-16)
951 reads
2014-07-23 (first published: 2014-06-17)
1,770 reads
2014-07-22 (first published: 2014-05-16)
2,001 reads
Object dependencies in xml format
Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio.
It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.
2014-07-21 (first published: 2014-05-19)
928 reads
Caching and paging a SQL Result Set
This is an example of how to Cache Query results on the Server side
then page though the results
2014-06-06 (first published: 2014-05-05)
2,254 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 KONTAK BCA KCP ABC Telp:08218154393
WA:08218154393 Jl. ABC No. 23-25, Braga, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40111
ALAMAT BCA KCP Sunda Mal Telp:08218154393
WA:08218154393 Jl. Sunda No.50-54, Kb. Pisang, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40112
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers