Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
The post Why Don't You Upgrade in Place? appeared first on SQLServerCentral.

The ForEach loop works with only one file type at a time by default. Learn how you can add code to your packages to work with multiple types of files.
The post Configuring an SSIS ForEach Loop for Multiple File Types appeared first on SQLServerCentral.

Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with a solution to these challenges. Let’s analyse this piece-by-piece.
The post Source Control with GIT, Power BI and Microsoft Fabric appeared first on SQLServerCentral.

Tell me if you’ve heard this one before: I changed data from my application, but when I checked the database, I couldn’t see the change! I’ve seen this. Loads. It can be quite perplexing for folks because they expect to see an error message if the insert, update, or delete failed.
The post When an update doesn’t update appeared first on SQLServerCentral.

This article examines the challenges with searches on encrypted data and presents a possible solution that you might use to speed up those queries.
The post Searching an Encrypted Column appeared first on SQLServerCentral.

Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql.
The post Running Azure CosmosDB queries from SQL Server using ODBC driver appeared first on SQLServerCentral.

Learn about using an alias in the GROUP BY clause for complex SQL Server code instead of having to rewrite the code in the GROUP BY.
The post SQL GROUP BY Alias - An Oracle feature that would be great in SQL Server appeared first on SQLServerCentral.

As data grows and databases become larger and more complicated, data
subsetting provides a method of working with a smaller, lighter copy of a
database to make development and testing faster and easier.
In this article, James Hemson poses the questions; what exactly is data subsetting, how and why are developers using it – or not using it, and
what’s prompting conversations about it?
The post What is subsetting, what are the advantages, and how does it make test data management easier? appeared first on SQLServerCentral.