Back to All Articles
Copying SQL Databases, renaming is not as easy as it could be. Luckily the following script can make the effort much easier. Give it a try. After copying a SQL Server database I needed to create a new schema and transfer all tables and views and stored procedures from the old schema to the newly created schema. Using the following script made this task much easier.
Updated: October 13, 2020
Created: October 13, 2020
Yes! There really are 6 ways to compare strings within .NET (I suspect other languages as well). Hopefully this will shed some light on the options.
Updated: December 10, 2019
Created: December 10, 2019
Once you resolve the ability to save database diagrams, please note that in the next release of SSMS v18 Microsoft is deprecating database diagram feature. I don't quite understand this thinking however you can find more information in the release notes.
Updated: October 3, 2018
Created: October 3, 2018
Before you rush to download SQL 2008 you may want to read the following KB article contained within this blog.
Updated: May 29, 2017
Created: May 29, 2017
Find a column name anywhere.
Updated: January 14, 2017
Created: January 14, 2017
Updated: February 13, 2016
Created: February 13, 2016
I had a need to mirror any changes to one Sql Server table to another Sql Server table of a different name. Read on.
Updated: February 13, 2016
Created: February 13, 2016
Find all occurrences of the column in any object.
Updated: April 20, 2015
Created: April 20, 2015
How to migrate data to Excel.
Updated: April 20, 2015
Created: April 20, 2015
Concatenate strings within SQL
Updated: April 20, 2015
Created: April 20, 2015
Updated: April 20, 2015
Created: April 20, 2015
SQL Server Data Tools (SSDT) provides project templates and design surfaces for building SQL Server content types - relational databases, Analysis Services models, Reporting Services reports, and Integration Services packages.
Updated: April 20, 2015
Created: April 20, 2015