Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

New: Optimize Slow Queries with Enhanced Database Visibility in Splunk Observability

Databases have always been the backbone of applications – both web and enterprise. Now, more than ever before, you need to know not just overall statistics about your database, but you must identify how database performance interacts with the network, operating system, servers, configuration, and even third party dependencies.

How Data Types and Query Tuning Can Improve Application Performance

One of the easier ways to improve the performance of your SQL Server and Azure SQL database queries is to ensure you choose the right data types for your data, and the data types in your application’s code match the ones in your stored procedures and queries. Choosing the right data type conserves space, because doing something like choosing a variable character type for data of fixed, regular length like a phone number or national ID number is wasteful.

Next-gen database cloning deploying soon

Building on the success of SQL Clone in delivering copies of SQL Server databases at speed, we’re bringing cloning to Oracle, PostgreSQL, MySQL. As we launch an early access program, we would like to invite you to gain first access to our newest database cloning technology and input into our roadmap. Adding support for other RDBMS is a big deal as we look to extend our market-leading Database DevOps solutions to more teams, but that’s not the only major feature.

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.