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,186 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,204 reads
2014-04-17 (first published: 2014-03-25)
1,298 reads
2014-04-14 (first published: 2014-03-18)
6,957 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,055 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,677 reads
2014-04-03 (first published: 2014-03-12)
1,190 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers