2011-10-31 (first published: 2011-10-19)
2,272 reads
Scripts
Proc to Rename a file
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
2011-10-28 (first published: 2008-05-13)
2,965 reads
Find and Replace a String in the Whole Database
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database.
2011-10-27 (first published: 2008-02-08)
3,454 reads
SQL Server 2005 Index Maintenance
Index maintenance procedure using rebuild or reorganized based on fragementation level.
2011-10-26 (first published: 2008-03-28)
3,488 reads
Generate HTML output for given SQL Query
Many times we need to generate html query for a given SQL query for that we need to use ASP, Java. Now you can use this SP to generate HTML.
2011-10-25 (first published: 2007-10-01)
4,544 reads
Reverse-Engineer Database Permissions (2005 up)
This script reverse engineers SQL statements to recreate database permissions.
2011-10-24 (first published: 2011-10-07)
16,235 reads
Search for a String in all Stored Procedures and beyond?
Search for String Occurence with this script in your stored procedures.
2011-10-20 (first published: 2008-06-08)
5,388 reads
UP_COMPACTA_COPIA
I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.
2011-10-17 (first published: 2011-09-30)
437 reads
2011-10-14 (first published: 2011-08-24)
522 reads
Detailed Table Data
Gets Detail table information such as partition information, compression, and partition range.
2011-10-13 (first published: 2011-09-30)
1,236 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
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...
Forums
Alamat kantor BCA KCP Kutabumi Telp:082144477715
Wa:0821-4447-7715 Jl. Raya Kutabumi No.16-17 Blok B-18, Kutabumi, Kec. Ps. Kemis, Kabupaten Tangerang, Banten...
Alamat kantor BCA KCU GADING SERPONG Telp:082144477715
Wa:0821-4447-7715 Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia Garden No.001...
ALAMAT BCA KCU JOMBANG Telp:08218154393
WA:08218154393 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers