The latest News and Information on Databases and related technologies.


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.


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.

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.

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.


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.