This wizard migrates SSIS Catalog from one server to another in just a few clicks.
The post Migrate the SSIS Catalog in Just a Few Clicks appeared first on SQLServerCentral.

In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.
The post Build SQL Server CLR Triggers appeared first on SQLServerCentral.

Learn about the Schema Compare feature in Azure Data Studio.
The post How to Compare Tables in Azure Data Studio appeared first on SQLServerCentral.

More and more organizations are turning to DevOps to improve the efficiency and quality of software delivery, and increase value to their business. But what exactly is DevOps and what does it mean for you and your organization?
The post DevOps 101 with Grant Fritchey appeared first on SQLServerCentral.

In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.
The post Running SQL Server on Oracle and Google Cloud appeared first on SQLServerCentral.

In this article we present complex built-in data types in Python along with several examples of how to use complex data types.
The post Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set appeared first on SQLServerCentral.

In case you missed it: IDC’s recent Global DataSphere Forecast, 2021-2025, predicts that global data creation and replication will experience a compound annual growth rate (CAGR) of 23% over the forecast period. But what’s causing the growth? Where will all of that extra data be stored? And how should we, as data professionals, prepare for it?
The post ICYMI: What's behind the explosive growth in data? appeared first on SQLServerCentral.

In a total 180° turn, find out which Redgate product Grant Fritchey wanted to get rid of a few years ago, why he changed his mind and why it's now one of the reasons he is so proud to work at Redgate!
The post "I started lobbying to just toss the tool aside." appeared first on SQLServerCentral.