Find database where table is located
Return a list of databases which contain a table from wildcard table name.
2014-05-05 (first published: 2014-04-14)
1,196 reads
Scripts
2014-05-02 (first published: 2014-04-09)
1,784 reads
2014-05-01 (first published: 2014-04-09)
1,508 reads
Format decimal value to fraction using a tally table.
We use a tally table to find the appropriate denominator for a given decimal part of a number.
2014-04-29 (first published: 2014-04-07)
1,196 reads
Exporting data with header using Powershell
Extracting data with header information using PowerShell
2014-04-28 (first published: 2014-04-07)
1,500 reads
2014-04-24 (first published: 2014-04-05)
2,009 reads
Restore script genrator for moving dbs
usefull script for moving databases from one server to another
2014-04-23 (first published: 2014-03-29)
937 reads
2014-04-22 (first published: 2014-02-20)
2,189 reads
backup, differental and transactions
Backup all databases for an instance (complete, Differential or log of transactions)
2014-04-21 (first published: 2014-04-05)
1,082 reads
Get the defination of all table type in database
THis script will generate the Drop and create script for all user define table type
2014-04-18 (first published: 2014-03-25)
1,205 reads
Blogs
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
Forums
ALAMAT BCA KCU SCBD Telp:08218154392
WA CS:08218154392 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl....
Alamat Kontak BCA KCU BEKASI WA CS:08218154392
WA CS:08218154392 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks,...
ALAMAT BANK BCA KCU GUNSA 45 TLP/WA 08218154374
Hub Cs: 08218154374 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers