Operations | Monitoring | ITSM | DevOps | Cloud

December 2020

Challenges to Database DevOps: Dealing With Drift

Sometimes, people start their DevOps journey by getting their database into source control, but then, they don’t deploy from source control. Instead, they continue their manual deployments to production. Quickly they find that the database code in their production instances and the database code in their source control system don’t match.

New SQL Change Automation Filter Features for Enterprise Teams: Migrations and Drift Report

Options for filtering when generating migrations and when reporting on database drift help teams make the best of tricky database environments. From Enterprises to tiny startups, most developers prefer to do work in small teams these days. But when it comes to database development, teams in Enterprises often have a hard time keeping these small teams fully separate in the development process.

Where does the tech sector go in 2021?

Like every industry sector, 2020 has been a tough year in tech. The pandemic has changed the way we work, it’s changed the way our customers work, and it’s been a rollercoaster ride. In August 2020, IDC’s Global ICT Spending Forecast 2020 – 2023 predicted 2020 revenue in the sector would fall to $4.8 trillion compared to its original estimate of $5.2 trillion.

A quick guide to the New Zealand Privacy Act 2020 for DBAs

December 1 saw the introduction in New Zealand of the Privacy Act 2020 which not only brings increased protection for individuals but also has some new implications for businesses, including increased fines for non-compliance and the reporting of serious privacy breaches.

Finding Unstable Query Plans in SQL Monitor ("Bad" Parameter Sniffing)

A common but tricky issue to identify in SQL Server is when something called "parameter sniffing" goes bad. In this video, Redgate's Kendra Little shows how to identify if a query has an unstable execution plan in SQL Monitor, where to find the parameters which were "sniffed" for each query plan, and gives tips on where to start to resolve the issue.

Performance tuning with SQL Monitor: tempdb usage, parameter sniffing, and blocking chains

Looking to level up your performance tuning game? Check out three new videos on tempdb, unstable query plans, and identifying blocking chains with SQL Monitor. I got to work with some of my favorite folks from the SQL Monitor team last week to build some new workload patterns for our online monitoring demo site. Here are three videos sharing some highlights of performance tuning features in SQL Monitor.

Redgate embraces open source with its ongoing development of Flyway

18 months ago, Redgate embarked on a new and ambitious journey with the acquisition of Flyway. It’s been quite a ride since then and we thought we’d end 2020 with an update on what’s been happening with the world’s most popular open source migrations framework for database deployments. We’ve learned a lot, and I wanted to share that with you in this post.

DBAle 27: Continuous Delivery with Chris, Chris and Santa

In this cracker of a DBAle episode, you can not only hear, but see our Chris-tmas duo as they embark on an end-to-end database journey where even the beers are getting Festiv-O. There’s no gold, frankincense, and myrrh, instead our two (not so) wise men build and incrementally deliver NuGet presents down your pipeline chimney. So, grab yourself a beer and tune in for the last DBAle of 2020 - cheers!

Scripting Changes to Partitioned Tables with SQL Compare

A customer recently asked if Redgate's comparison engine is able to generate code to split partitions when a partitioned table is modified. Yes, it can! In this video we demonstrate this in SQL Compare, but the same functionality is also available for automated deployments from SQL Source Control and SQL Change Automation, which use the SQL Compare Engine.