SQL Solution center round-up – March 9th, 2015 – SSIS packages, SQL formatting, refactoring and more

Check out how to easily document all components of data flow in your SSIS package – How to document SSIS package data flow

This article describes how to document a control flow diagram in your SSIS package – How to document SSIS package control flow

Get familiar with the basics of source control in SQL Server – SQL Server Source control – Part I – understanding source control basics

In the case of accidentally dropped, deleted, or damaged data, it is still possible to restore specific tables even if restoration of an original database to a previous state is not an option – How to restore specific table(s) from a SQL Server database backup

The first part of a tutorial for creating SQL Server Management Studio 2012 add-ins – The art and science of creating SSMS 2012 add-ins – Part 1 – Laying the Foundation

In the second part, we’ve covered the main class of the add-in, the creation of simple UI elements and the methods that you can use to communicate with SSMS – The art and science of creating SSMS 2012 add-ins – Part 2 – Customizing the add-in

In the third part we‘re continuing the story with the steps to further modify SSMS UI, by creating toolbars and new windows. We also take a look at the method for controlling commands appearance in SSMS 2012 – The art and science of creating SSMS 2012 add-ins- Part 3 – Creating Toolbars and new Windows

By utilizing snippet templates, you can significantly speed up SQL coding process and avoid typing errors – How to code faster with SQL Server code snippets

Check out how to migrate databases between environments by generating a deployment script from multiple SQL databases – How to combine objects and data from multiple SQL databases in a single SQL script

Assign an auto-replacement token to your frequently used SQL commands and SQL objects – How to use SQL code text auto-replacements

Improve the performance of your SQL queries by qualifying object names – How to format SQL query to qualify object names explicitly

How to modify a SQL function or a stored procedure parameters and maintain database integrity – How to safely modify SQL stored procedure and SQL function parameters

Basic principles for replacing one-to-many relationships with associative tables – Replacing one-to-many relationships with association tables automatically– Part 1

How to introduce an associative table and replace a one-to-many association between two tables – Replacing one-to-many relationships with association tables automatically – Part 2

The principles of the renaming SQL Server objects – How to rename database objects in SQL Server database safely – Part 1

Rename objects in SQL Server without breaking the database dependencies – How to rename database objects in SQL Server safely – Part 2

This article is first in a series that will address several SQL readability strategies and demonstrate different ways to format T-SQL code – SQL query basics – How to improve readability by formatting capitalization and object naming

In the second part we will go in detail with formatting rules for commas, spacing, and aligning – SQL query basics – How to improve readability by formatting commas, spacing and aligning>

In this article we will describe how to apply database refactoring on a SQL Server database and replace a natural key with a surrogate key – How to refactor a SQL Server database table to add a surrogate key

Keep track of a SQL Server multiple instance-level settings and objects configuration – Document SQL Server instance settings/objects

Document your SSIS packages in just a few clicks – How to create SSIS package documentation

Compare structures between SQL database schemas and tables directly from SSMS – How to compare SQL databases in SSMS

Identify and raise an alert every time a deadlock occurs by using native SQL Server options – SQL Server deadlock notification – Part 1

How to be notified on a deadlock and see all deadlock details in a user-friendly GUI – SQL Server deadlock notification – Part 2

How to build and deploy SQL databases by using ApexSQL Diff – How to build a SQL database directly from scripts

How to compare and synchronize a database backup against a script folder – How to create a SQL database build script directly from a backup

March 9, 2015