Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.
2024-06-07 (first published: 2024-05-24)
1,319 reads
See a first look at Azure Data Studio from Kenneth Igiri and read about his impressions.
2023-11-13
4,039 reads
Migrate SSIS environment variables from one SQL Server to another in just a few clicks using SSIS Catalog Migration Wizard.
2023-05-19 (first published: 2022-10-12)
5,756 reads
Redgate’s new DevOps test data management tool, Redgate Clone, provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases.
2023-05-08
In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.
2023-04-28
Database DevOps has come of age. Now seen as a key technical practice which can contribute to the successful implementation of DevOps, it stops the database being a bottleneck and makes releases faster and easier.
To implement it successfully, there are ten areas which teams should focus on.
2023-04-05
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,812 reads
The migration to a different VCS should not be underestimated, as there is a lot more involved than just switching tools, and that’s what Tonie Huizer covers in this article.
First, the team needed to migrate the monolithic repos over to Git, second the team needed to make sure we had a branching strategy and workflow in place.
It involved a big process change for the team as well, but this switch is mandatory to make full use of branch-based database development.
2023-02-08
6,817 reads
However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them. Start learning.
2022-12-12
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
2022-10-27 (first published: 2021-08-17)
15,963 reads
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
I am learning DbaTools in Powershell, and my current project is exporting a CSV...
I'm using an ADO Net Source to extract data and running into an issue...
Hi I have below query and i want Cummulative Total . Total should be...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers