Copy SSIS Environment variables to another server
Migrate SSIS environment variables from one SQL Server to another in just a few clicks using SSIS Catalog Migration Wizard.
Migrate SSIS environment variables from one SQL Server to another in just a few clicks using SSIS Catalog Migration Wizard.
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.
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.
This article looks at four security best practices for protecting databases in AWS along with how GuardDuty can be used to provide additional security.
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!
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.
Learning to find the career that's important to you can be a challenge. Today Steve has some advice.
This article examines some basic database design principles that help ensure your queries can execute more quickly.
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft ā the feeling of loss upon finishing a good book, sensing the weight...
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. Iām...
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
Hello, I need help to improve an existing (hence I cannot change table's structure...
In Brent Ozar's list of links today, I learned that Microsoft has removed the...