Migrate SSIS environment variables from one SQL Server to another in just a few clicks using SSIS Catalog Migration Wizard.
The post Copy SSIS Environment variables to another server appeared first on SQLServerCentral.

Learn the basics of how CTEs work with a few examples in this article.
The post Common Table Expression Basics appeared first on SQLServerCentral.

This article explains why Flyway is fundamentally well-suited to the task of bringing control and automation to database development work and then the features of Flyway Teams edition that become necessary when a team of developers need to work concurrently on a database.
The post The Journey to Team-based Development with Flyway appeared first on SQLServerCentral.

Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.
The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.

In this article, Joe Celko gives us a history of the different character sets that are used in computing and how that can pertain to your usage in relational databases. Some of these you may have never heard of!
The post Getting Out of Character appeared first on SQLServerCentral.

This article looks at four security best practices for protecting databases in AWS along with how GuardDuty can be used to provide additional security.
The post Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty appeared first on SQLServerCentral.

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.
The post PASS Data Community Summit 2023 registrations are open! appeared first on SQLServerCentral.

This article explains how these ‘ephemeral databases’ can be used to improve development and testing processes in ways that reduce the number of bugs entering the deployment pipeline, drive up the quality of database releases, and so improve the reliability and speed of database deployments to production.
The post 7 ways businesses can improve the quality and speed of database releases appeared first on SQLServerCentral.