2010-03-29 (first published: 2010-03-24)
1,838 reads
Scripts
Finding rows count in a table without Select...
Here is a one more very quick way to find row count for a table.
2010-03-26 (first published: 2010-03-23)
5,383 reads
Credit Card Number Validation Escalar Function
Evaluate credit card numbers based on ISO 2894 algorithm.
2010-03-24 (first published: 2010-03-17)
1,923 reads
Script to get Phonetic Pronunciation of a given password
This script displays Phonetic Pronunciation of a given password
2010-03-22 (first published: 2010-03-12)
1,391 reads
2010-03-17 (first published: 2010-03-04)
1,531 reads
EXECute SQL Commands over entire sets of parameters!
A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.
2010-03-16 (first published: 2010-03-04)
2,932 reads
Unused Objects in the Server
This Script is used to List out the objects lying in the box which were un used from the day of the sql server recycled.
2010-03-09 (first published: 2010-02-18)
1,922 reads
ServerProperty query with case function
Returns all properties from ServerProperty, also has a case function for EditionID and EngineEdition.
2010-03-08 (first published: 2010-02-18)
1,373 reads
Fix users for SQL 7 thru 2008
This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.
2010-02-24 (first published: 2010-02-04)
2,254 reads
See the compile time
Useful if you think a SQL statement, Function, or SPROC is taking too long to compile.
2010-02-23 (first published: 2010-02-04)
972 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 BCA KCP Jatimakmur Telp:08218154393
WA:08218154393 Jl. Raya Jati Makmur, RT.001/RW.007, Jatimakmur, Kec. Pd. Gede, Kota Bks, DKI Jakarta...
ALAMAT KONTAK BCA KCP Cikarang Telp:08218154393
WA:08218154393 Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blk B, RW.6, Cikarang, Kec. Cikarang...
ALAMAT BCA KCU CIKARANG Telp:08218154393
WA:08218154393 Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu, Cikarang Selatan,...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers