2012-10-04 (first published: 2012-04-10)
2,031 reads
Scripts
Find Primary Column of all tables in database
This code helps in finding Primary Keys for all tables in a database.
2012-10-02 (first published: 2012-09-04)
1,438 reads
2012-10-01 (first published: 2012-09-05)
2,599 reads
SQL Server Uptime
This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only)
2012-09-28 (first published: 2012-09-07)
1,446 reads
Find all actual words from Dictionary Table using jumbled word
How to get all actual word from a table,if I pass a jumbled word
2012-09-27 (first published: 2012-09-05)
833 reads
SQL Start up Script
This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.
2012-09-25 (first published: 2012-08-29)
1,881 reads
Run SQL Hosted VBS Script from SQL
This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.
2012-09-20 (first published: 2012-08-21)
997 reads
Show all Objects used by Linked Server
Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.
2012-09-17 (first published: 2012-08-23)
1,071 reads
ASCII Character Groups in String
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,054 reads
2012-09-07 (first published: 2007-11-15)
3,497 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 Bank BCA KCU SUDIRMAN TLP/Wa:0817839777
Hubungi Cs 0817839777 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota...
Alamat Kantor BCA KCU SCBD Tlp/Wa:0817839777
Hubungi Cs 0817839777 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E,...
Alamat BCA KCU WAHID HASYIM Tlp/Wa:0817839777
Hubungi Cs 0817839777 Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan Tanah...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers