Operations | Monitoring | ITSM | DevOps | Cloud

October 2021

NiCE DB2 Management Pack 5.00 released

The NiCE DB2 Management Pack 5.0 is an enterprise-ready Microsoft SCOM add-on for advanced IBM Db2 monitoring. It supports the Db2 system, application, and database administrator in centralized IBM Db2 health and performance monitoring to improve user experience and business results. The Management Pack provides clear and precise performance indicators and timely alerts enriched by pinpointing problem identification and troubleshooting information.

Effective DataOps Tools for Improving Performance

Some of the best-selling books of all time are self-help books. Reading about the potential for change always intrigues people enough to buy the book. To succeed in enacting positive change, you must do just that—change. People’s habits are familiar and safe, and change requires effort down an unknown path. People aren’t sure of the outcome, and as a result, usually stick with the proven method—even if it’s what they’re trying to change.

DBAle 37: Neuro (just not name) diversity

Your usual Chris duo becomes a trio, as they welcome Friend of Redgate and autism spectrum self-advocate, Chris Voss. Only our 2nd ever guest Chris on the show, he joins us to demystify the myths of neurodiversity, its meaning, influence, and prevalence within the IT sector. Things get a little hazy as our Chris trinity start on the beer, but they keep IT relevant talking cloud, widgets, and acronyms. So, grab yourself a beer and join the Chris trifecta – cheers.

How to Make SQL Server Faster on Azure VMs

Many organizations have migrated their environments from on-premises to the cloud, and one of the clouds of choice is Microsoft Azure. For SQL Server workloads, organizations can use platform as a service solutions with features like Azure SQL Database and Managed Instance or infrastructure as a service solutions with Azure SQL virtual machines. Azure SQL virtual machines are an easy target for organizations migrating to Azure due to the simplicity of the migration.

Oracle Management Pack Update Release (21.9.2568.0)

We’re happy to announce a new update release of our Oracle Management Pack for SCOM. The 21.9.2568.0 release contains new features, fixes, and changes. On top of this, we have also released a new datasheet and a white paper that you can find more information about further down in this article.

Master Data Management and Data Governance-How to Build an Effective Strategy

As organizations marshal their data to drive business value throughout the enterprise, it’s becoming more important than ever to ensure the quality of this data. Building data quality, data validation testing, and aligning the data with your organization’s master data (such as products, customers, assets, and locations) is critically important to ensure your reporting is consistent and accurate.

What Is MongoDB's _id Field and How to Use It

The MongoDB _id field is fundamental to every collection in MongoDB, and, by default, it has some useful properties users can take advantage of when familiar with how _id is generated. Understanding the field's default behavior and the advantages and pitfalls associated with it can be useful for managing your collections as well as understanding when to override it.

What Is CI/CD and How to Build ETL Processes

In today’s world of heterogeneous data ecosystems, managing and consuming data can be cumbersome. Organizations often have multiple systems of truth in corresponding to the applications managing the data. While data engineers dream of software that would make it easy to consume and digest different data streams from disparate systems, that scenario rarely comes to fruition.

Time series databases - For the heat of modern data

Meet the hottest data trend. Time-stamped data is an ever-present aspect of our lives. Medical sensors, autonomous vehicles, financial fluctuations, your refrigerator... These days anything can be connected, and the data flow can be astronomical. No matter what you throw at them... time series databases are built to handle the heat of modern data. In fact, they’re so hot... they’re cool! Want to know more?

Time series databases - Astronomically awesome

Imagine a universe of data. A place where every star, every planet, is a byte of information...dispersed through eons of time. Could anything handle all that data? Time series databases are built for astronomically huge amounts of information. When you’re wrestling with near infinite data, a time series database – like Aiven for M3 – will help you make sense out of chaos. Want to know more? Check out Aiven’s guide to time series data – and transform a universe of data into something awesome.

How to Prepare for a SQL Server DBA Interview and Questions

So, you have an interview lined up for a sweet new gig as a SQL Server database administrator (DBA). What interview questions will you be asked? How can you make sure you ace the interview? What will make you stand out from the other candidates? There are no concrete answers, because… “it depends.” However, you can count on at least two major components of your interview – a technical component and a non-technical component, often focusing on soft skills.

How to Quickly Identify Performance Issues in Azure SQL Database

Moving your database to the cloud using a PaaS option such as Azure SQL Database or Azure SQL Managed Instance reduces the maintenance overhead required from the database administrator (DBA). The DBA no longer must worry about managing backups or configuring high availability, for example. That said, the DBA still needs to tune the database’s performance and monitor SQL workloads. The Azure Portal offers several services to quickly identify performance issues for Azure SQL Databases.

Configuration, Access, and Connection to GCP CloudSQL for PostgreSQL

GCP is increasingly being used by teams all over. In this blog, Uzziah explains how CloudSQL is Google Cloud Platform’s solution that provides a managed PostgreSQL and MySQL server. Relational databases are the preferred choice for persisting data in most non-trivial applications. CloudSQL is Google Cloud Platform’s solution that provides a managed PostgreSQL and MySQL server.

Daily SQL Server Performance Checklist for DBAs

A main focus for database administrators (DBAs) is to ensure server environments are optimized and performance is at its peak. Whether you’re a DBA starting in a new role and are evaluating an existing environment for the first time, or you’re a senior database professional with the ongoing task of maintaining optimal performance, following key SQL Server best practices for installing, configuring, and ensuring new instances of SQL Server are consistently deployed is all in a day’s work.

5 things to look for in a third-party monitoring tool

A key finding from Redgate’s recent State of Database Monitoring Survey of over 2,500 IT professionals was that 79% of respondents reported using either a third-party or in-house monitoring tool. It’s notable because it’s an increase of 10 percentage points from the same survey last year – and the satisfaction rate with third-party monitoring tools also saw an increase of 18 percentage points to 86%.

10 SQL Server Performance Tuning Best Practices

There are a large number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially when you consider the number of different database settings, SQL Server settings, coding practices, SQL wait types, and so on that can affect performance.

How Do You Monitor Cassandra Performance: Key Metrics to Measure

Apache Cassandra is a distributed database known for its high availability, fault tolerance, and near-linear scaling. It was initially developed by Facebook, but it is a widely used open-source system used by the largest tech companies in the world. There are numerous reasons behind its popularity, including no single point of failure, exceptional horizontal scaling with a data layout designed as a perfect fit for time-series data.

Native SQL Server Backup Types and How To Guide

When a disaster occurs, the ability to successfully restore SQL Server databases is fundamental for avoiding data loss. It’s not enough to rely on hardware and software technologies to replicate data because these technologies can go wrong or there can be multiple failures during a disaster, meaning you have to rely on backups to recover. SQL Server allows multiple types of backups, and a multitude of options to use with those backups.