Filter Changes for Import in SQL Change Automation in SSMS
You can now easily filter the list of database changes to import in SQL Change Automation in SQL Server Management Studio.
Operations | Monitoring | ITSM | DevOps | Cloud
The Place Where Modern Operations & Technology Come Together
The latest News and Information on Databases and related technologies.
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.
How to monitor Amazon Aurora RDS logs and metrics
Aurora, a hosted relational database service available on the Amazon cloud, is a popular solution for teams that want to be able to work with tooling that is compatible with MySQL and PostgreSQL without running an actual MySQL or PostgreSQL database. In order to leverage Aurora’s benefits fully, it’s critical to log and analyze the various types of monitoring data that are available from an Aurora environment.
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.
Viewing and Interpreting Blocking Chains in SQL Monitor
Blocking is like a traffic pileup: when it occurs, it's helpful to find the "lead blocker" and then step through the chain of who blocked who. In this video we step through an example blocking chain and give tips on how to find useful information in SQL Monitor.
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.
How to monitor an Oracle database with Prometheus
In this article, we will explain how to monitor an Oracle Database with Prometheus using an exporter to generate metrics. Also, we will review the main metrics that you should monitor on resource usage and performance, and what to alert on to detect issues and incidents in your Oracle Database.
See what's happening in tempdb with SQL Monitor
SQL Monitor now shows you insights on what's using up space in tempdb. Is it the version store? Internal objects like hash joins or sorts? User objects like temp tables? Which sessions are involved, and how are your tempdb files being used? Join Kendra to look over an example workload.
Flyway's Growth Demonstrates the Value of Open Source for Software Companies
Following its $10 million acquisition of Flyway, Redgate Software has secured the future of the popular Open Source database migration tool by taking a new approach to software development.