Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Understanding the Role of a Data Steward

Many years ago, in my earliest IT jobs in Omaha, Nebraska, I realized the field of data was going to continue to evolve and, as such, there would always be a need for people who worked with and understood data. Regardless of which industry someone worked in—financial, medical, governmental, transportation, or retail—someone would have to work with and maintain business data, or the business would fail. This realization led me into the world of databases and SQL Server.

Day 2 Apps Deployed, the Database is on Fire

Use DevOps practices to deploy your database changes seamlessly! Join Robert Reeves of Liquibase and Melissa McKay of JFrog as they discuss the advantages of using tried and true DevOps methodologies and automation to keep your database driven application up and running in production. The 2021 State of DevOps Report tells us that elite performers are 3.4 times more likely to adopt database change management practices. DevOps is for everyone including our database professional friends.

Where's the best place to live as a DBA? | Infographic

Perhaps because so few of us have been able to travel recently, or perhaps because wanderlust is just good fun, we’ve been wondering as to where the best place to live is as a DBA. And not just where pays the most, or where the opportunities are, but where would truly be the best place to live day-to-day. Some of the findings might surprise you! If you live in any of the places mentioned, we’d love to hear about your experience of living there in a comment below.

Monitor the Azure Cosmos DB integrated cache with Datadog

Azure Cosmos DB is a fully managed NoSQL database that scales automatically with load and supports multiple APIs. This makes it easy to incorporate with your applications while removing the need to maintain your own database servers. The Cosmos DB integrated cache—which is now in public preview—is a new offering that can help reduce costs and improve performance for Azure Cosmos DB.

7 Trends in Database DevOps & Monitoring - Download the infographic

Earlier this year, we surveyed over 5,700 global IT professionals and asked them what the most pressing challenges they faced in Database DevOps and Monitoring are. We also asked specific questions to gauge what trends we could spot in the industry and compared the responses to the last 3-5 years of data we have.

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.

Scaling AWS Lambda and Postgres to thousands of uptime checks

When you're building a serverless web app, it can be pretty easy to forget about the database. You build a backend, send some data to a frontend, write some tests, and it'll scale to infinity with no effort, right? Not quite. Especially not with Postgres. As the number of users of your frontend increases, your app will open more and more database connections until the database is unable to accept any more. It gets worse.

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.