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
Scripts
2014-04-22 (first published: 2014-02-20)
2,187 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
2014-04-17 (first published: 2014-03-25)
1,299 reads
2014-04-14 (first published: 2014-03-18)
6,972 reads
Get the Column level difference for 2 database
The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.
2014-04-10 (first published: 2014-03-11)
1,057 reads
Find dependencies between field and sp/function
This script shows the stored procedures and functions affected by field name change in a table.
2014-04-09 (first published: 2014-03-18)
1,062 reads
Identify Column Data Types
Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.
2014-04-07 (first published: 2014-03-12)
1,683 reads
2014-04-03 (first published: 2014-03-12)
1,192 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers