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,197 reads
Return a list of databases which contain a table from wildcard table name.
2014-05-05 (first published: 2014-04-14)
1,197 reads
2014-05-02 (first published: 2014-04-09)
1,785 reads
2014-05-01 (first published: 2014-04-09)
1,508 reads
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,200 reads
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
usefull script for moving databases from one server to another
2014-04-23 (first published: 2014-03-29)
943 reads
2014-04-22 (first published: 2014-02-20)
2,192 reads
Backup all databases for an instance (complete, Differential or log of transactions)
2014-04-21 (first published: 2014-04-05)
1,082 reads
THis script will generate the Drop and create script for all user define table type
2014-04-18 (first published: 2014-03-25)
1,207 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
WA CS 08218154392 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl....
WA CS 08218154392 Jl. Jend. Ahmad Yani No.169, Watampone, Kec. Tanete Riattang Bar., Kabupaten...
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers