Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Monitoring MS SQL Server with Applications Manager

MS SQL, Microsoft’s relational database management system (RDBMS), is known for its broad spectrum of capabilities such as transaction processing, business intelligence, and analytics. This is why most businesses trust and invest in SQL for their data storage and access needs. What are the benefits of monitoring SQL servers? Applications Manager offers proactive SQL server monitoring.

Dissecting Rails Migrations

In today’s post, we’ll take a deep dive into Rails migrations. We’ll break down the migration into different pieces, and in the process, learn how to write an effective migration. We’ll learn how to write migrations for multiple databases, as well as how to handle failed migrations and techniques of performing rollbacks. To understand the whole post, you’ll need to have a basic understanding of databases and Rails.

SQL Server, Part 1: Why you should monitor SQL logs

Over 44 records are stolen per second every day due to data breaches, and according to the Risk Based Security Research report published in 2019, databases are the top most targeted assets for malicious actors to exploit organizations’ confidential data. Often, organizations don’t realize their databases have been compromised for months. Once sensitive data is leaked, the damage can’t be undone.

Azure Database Security: 7 Best Practices You Need to Know

Azure is a cloud computing vendor, ranked among the top providers. Like all cloud vendors, Azure uses a shared responsibility model. This means that some of the responsibilities are taken care of by the cloud vendor, while the rest should be taken care of by the cloud user. In this article, you will learn about Azure SQL services, and the seven most important best practices needed to ensure the security of your cloud-based Azure SQL operations.

Global Oil & Gas Company picks NiCE Oracle Management Pack

NiCE IT Management Solutions is proud to serve global key-players in advanced Oracle database performance and health monitoring. Read the latest customer reference on how the NiCE Oracle Management Pack is helping a global Oil & Gas company in standardized, IT Governance compliant Oracle operations.

Episode 11: Connecting to Redis with .Net Core and C#

We've finally finished screwing around with basic groundwork. Today we start writing actually useful application code! First, can we connect to Redis? Connecting to Redis implies some connection strings, so we'll create a basic environment based configuration while we're thinking about it.

NiCE DB2 Management Pack 4.40 for Microsoft SCOM

The NiCE DB2 Management Pack enables advanced health and performance diagnostics for Db2 databases. Health and performance measurement is directly displayed in your Microsoft System Center console. Integrations into SquaredUp dashboards make it even easier to tune Db2 monitoring. Leverage your existing investment, reduce costs, save time and build efficiencies that will last beyond your expectations.

Episode 10: Installing Redis from Ansible Galaxy

A pre-built playbook from Ansible Galaxy lets us easily install Redis. (Even we don't re-invent the wheel every time.) The Request Metrics application will use Redis as its main data store. We need to install Redis on our servers to find out if this is a good plan. Ansible provides a repeatable way of doing this configuration work.

A Guide To SentryOne SQL Server Monitoring

There is a lot to consider when weighing up SQL server monitoring solutions, with various competing providers delivering compelling packages that promise to boost performance, improve maintenance and enhance troubleshooting. SentryOne is a leading light in this market when it comes to the best SQL server monitoring tools, so here is a look at the features and functions that are included in its SQL Sentry monitoring suite.