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
Scripts
2014-05-02 (first published: 2014-04-09)
1,785 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,198 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)
943 reads
2014-04-22 (first published: 2014-02-20)
2,191 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,207 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers