We’re excited to introduce a brand-new capability of the Deployment Suite for Oracle: Redgate Change Automation is a command line tool with built-in safety checks that lets you safely automate your Oracle database deployment. With four commands that help you build, test, prepare, and perform Oracle database releases, Redgate Change Automation can be used as part of a CI/CD pipeline.
2020-06-03
SQL Server database business continuity, including high availability and disaster recovery, is not an easy topic to engineer for. The business must work with the IT teams to define service-level agreements, statistically significant scenarios to plan for, and then decide on a budget.
2020-06-03
PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to use? In this article, Greg Moore shows how to add professional looking help to your scripts that work just like the help in cmdlets.
2020-06-02
In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating a word cloud, word associations, sentiment scores, and emotion classification.
2020-06-01
2020-06-01
My favorite new things are that sp_BlitzIndex @Mode = 2 now makes it even easier to do disconnected index tuning just purely inside a spreadsheet, and sp_BlitzCache runs faster on big servers.
2020-05-29
Is your organization—and your data team—ready to embrace an AI-augmented future?
2020-05-28
How many different database applications exist? Many people can name the most common ones such as MySQL, Microsoft SQL Server, and Oracle. Most good DBAs and programmers could likely rattle off a dozen different databases is you asked them to.
2020-05-27
For any Business Intelligence solution to be useful for analytical and decision-making purposes, it is imperative that the underlying data quality is good so, that reports generated are reliable to make business decisions. This article from Imran Quadri Syed walks the through steps involved to implement a successful Data Quality Monitoring framework that would validate incoming data against predefined data quality rules and capture data quality metrics.
2020-05-26
1,004 reads
It’s a great time to learn a new skill or improve your existing skills if you have the extra bandwidth while staying at home.
2020-05-25
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers