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
