SQL Solution center round-up – April 2nd, 2015 – Auditing, encryption, disaster recovery, and more

Clean up your SQL scripts from unused variables and parameters – How to clean up SQL database code by removing unused parameters

Perform a change impact assessment and determine SQL table column dependencies – How to determine table column dependencies within a SQL database

Personalize your SQL database documentation – How to customize SQL database documentation

Customize your auditing reports – SQL Server database trigger auditing – How to customize data tracking and reporting – Part 1 and SQL Server database trigger auditing – How to customize data tracking and reporting – Part 2

Consolidate your SQL scripts into .NET project file or an executable installer – How to package database scripts into C# projects and .NET executables

Execute SQL scripts against multiple databases in a few steps – How to execute SQL scripts against multiple SQL databases at the same time

Combine your SQL scripts into a single script in a very simple way and decrease deployment time – How to consolidate multiple SQL scripts into a single SQL script

Keep track of your SQL database documentation creation date and time – How to add a timestamp to SQL database documentation

Split a database table without breaking dependencies – How to refactor a SQL Server database by splitting a table

Visualize all dependencies between SQL database objects – How to visualize SQL database objects dependencies

How to use CVS file format to test your database – How to generate randomized test data from a CSV file

How to create tool windows by using Visual Studio packages – Using VSPackages to create tool windows and customize command appearance in Visual Studio

How to use Visual Studio packages to create add-ins – How to create Visual Studio add-ins with VSPackages

How to connect your development client to your source control system – SQL Server Source control – Part II – Integration

How to rename tables, procedures, views, functions and columns while maintaining all SQL database dependencies – How to rename database schema and object names without breaking SQL database dependencies

How to schedule a database virtual restore – How to automate the process of restoring a SQL database

3 different solutions for creating a scheduled SQL Server backup – How to schedule a SQL Server backup

Protect your disaster recovery solutions by using SQL Server cryptographic features – SQL Server database backup encryption

Related posts:

  1. SQL Solution center round-up – May 31st, 2014 – SQL Server monitoring and creating databases on multiple servers
  2. SQL Solution center round-up – February 15th, 2014 – SQL formatting, recovery of deleted images, SQL Server auditing, security, and compliance
  3. SQL Solution center round-up – October 18th, 2013 – SQL Server compliance with FERPA and Basel II, database recovery, and methods for auditing failed logins
  4. SQL Solution center round-up – March 9th, 2015 – SSIS packages, SQL formatting, refactoring and more
  5. SQL Solution center round-up – January 31st, 2014 – HIPAA compliance, SQL formatting, SQL Server memory performance, single table recovery, and SELECT statements auditing
April 2, 2015