Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

What Is an SSIS Package and How Do You Create One?

SQL Server Integration Services (SSIS) is a workflow orchestration service used mostly for data integration and transformation. It was first released as part of SQL Server 2005 and continues to receive updates and new features today. While SSIS can be installed and run on a server (on-premises or in the cloud), it’s also available in Azure Data Factory. SSIS is commonly used to perform tasks such as: While SSIS originally only ran on Windows, it has also been available for Linux since 2017.

DBAle 38: That's absurd! Does it even pass as database development?

It’s officially National Absurdity Day, although, this could pass as just another DBAle. In the (soya) meat of the episode, our hosts pass the time discussing the frankly absurd database development practices that are somehow still passable in 2021. While the news celebrates the PASS Data Community Summit, and the importance of passwords in data security with Troy Hunt. So, pass yourself a beer, a champers, or a Passoa, and tune in – cheers.

How to Restore Databases From Native SQL Server Backups

In my previous post, Native SQL Server Backup Types and How-To Guide, I discussed the main types of native SQL Server backups and various backup options. Backups are critical to restoring databases quickly, but there isn’t much benefit to having backup files sitting around if you aren’t prepared and know when and how to perform the restores.

[Webinar] 5 Things to Consider When Migrating Databases to Kubernetes with Komodor & Ondat

Kubernetes is eating the world...at least the world of modern software engineering. Besides their applications, most businesses consider their data as the holy grail. It is key to the value they deliver. As they progress through application modernization, Kubernetes is the natural foundation to support their effort. But where should the data go? Is Kubernetes safe enough to take care of it? How to prepare for DB related incidents in an everchanging environment?

How to choose between AWS RDS and EC2 Hosted Database?

You’ve decided to migrate your applications from on-premises to AWS and are considering what cloud services are available that suit your needs the best. When you are migrating an application that uses a relational database backend (RDBMS) such as Oracle, MySQL or SQL Server to the cloud, the question of RDS vs EC2 will inevitably surface.

AWS Database Types - Aurora vs DynamoDB vs RDS - How do they compare?

In this blog, we describe the different types of AWS’ managed databases and their various features and merits. By the end of the blog, you should have better information to choose the right AWS database that would match your application’s needs.

Top key metrics for monitoring MySQL

Monitoring MySQL with Prometheus is easy to do thanks to the MySQL Prometheus Exporter. MySQL doesn’t need an introduction – it’s one of the most used relational databases in the world, and it’s also open-source! Being such a popular database means that the community behind it is also huge. So don’t worry: you won’t be alone.