Back to All Articles

Articles tagged sql:


Rename SQL Server Schema

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

Read more

String Comparisons

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

Read more

Unable to save database diagrams

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

Read more

SQL Server 2008 Installation, not so quick

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

Read more

Find all tables containing column with specified name

Find a column name anywhere.

Updated: January 14, 2017
Created: January 14, 2017

Read more

Generate Insert, Update, Delete Trigger for Table Audit

Updated: February 13, 2016
Created: February 13, 2016

Read more

SQL Server Triggers To Mirror a Table

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

Read more

SQL Server and Find all Columns in a Database

Find all occurrences of the column in any object.

Updated: April 20, 2015
Created: April 20, 2015

Read more

Export SQL Data to Microsoft Excel (using Visual Studio 2008, c#)

How to migrate data to Excel.

Updated: April 20, 2015
Created: April 20, 2015

Read more

SQL COALESCE Command Features

Concatenate strings within SQL

Updated: April 20, 2015
Created: April 20, 2015

Read more

New SSDT Power Tools! Now for both Visual Studio 2010 and Visual Studio 2012

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

Read more