Databases

The latest News and Information on Databases and related technologies.

How to encourage DBAs to embrace DevOps, rather than fear change

Jul 22, 2021 By Kendra Little In Redgate

How do we help Database Administrators (DBAs) embrace DevOps in a way that can be really productive and part of a rich DevOps team that delivers value to customers quickly and continuously? That’s an important question to ask right now because there’s a common view among DBAs that DevOps isn’t for them. They’re responsible for documentation and maintenance and deployments, they have internal customers, and they serve internal requests.

Read Post

Redgate

Read more about How to encourage DBAs to embrace DevOps, rather than fear change

After analyzing 600,000 SQL queries, these are the top mistakes developers make - Oded Valin

Jul 21, 2021 By JFrog In JFrog

Yalla! DevOps 2021 -- The first, in-person DevOps conference of the year! Driven by the DevOps community. All about the DevOps community. Users want to see their data fast, immediately, now. Whether you’re working with an ORM or writing native SQL, you probably had a “scratching-my-head-trying-to-figure-out-why-this-database-is-so-slow” moment. The team at EverSQL analyzed more than 600,000 SQL queries from thousands of different companies, to lay down the most common mistakes developers do when writing SQL queries. This talk focuses on writing SQL the right way, the fast way.

View Video

JFrog

Read more about After analyzing 600,000 SQL queries, these are the top mistakes developers make - Oded Valin

Cloud 66 Feature Highlight: Multi Database Support

Jul 21, 2021 By Cloud 66 In Cloud 66

Many applications use multiple types of datastores simultaneously - mixing SQL and NoSQL databases, for example. Or your application might need two separate clusters of the same database engine to handle an upgrade, or to support separate services. This is where Multi Database Support comes handy. What is Multi Database Support? Multi Database Support makes it possible to attach more than one database group to your application.

View Video

Cloud 66

Read more about Cloud 66 Feature Highlight: Multi Database Support

Choosing the Right Storage for SQL Server

Jul 20, 2021 By Denny Cherry In SolarWinds

Storage performance is key to the health and performance of a SQL Server database. When storage performance begins to slow down, queries suffer from more waits on disk. These waits can show up as a variety of SQL Server wait types, including WRITELOG and wait types starting with PAGEIOLATCH.

Read Post

SolarWinds

Read more about Choosing the Right Storage for SQL Server

Why Would You Pay for Flyway?

Jul 19, 2021 By Grant Fritchey In Redgate

Flyway is an open-source database deployment tool that also includes a paid tier called Teams. Since it’s open-source, you can just download Flyway and run it for free. You’ll get a robust DevOps tool to assist you in deploying your databases just like you deploy your code. It just works. So, why would you even bother to pay for Teams? Actually, there are a number of reasons why people pay for advanced tiers of open-source software in general.

Read Post

Redgate

Read more about Why Would You Pay for Flyway?

Data cataloging: A giraffe's eye view

Jul 19, 2021 By Louise Domeisen In Redgate

In the latest DBAle podcast episode our hosts, Chris and Chris, tackled what they really mean by cataloging a database and how taking a ‘giraffe’s eye view’ approach to compliance is not enough. That’s because the most common data concerns for managers and execs center around where your sensitive data is, the risk it poses and, if you’re migrating to the cloud, how much sensitive data is being stored on that database or that instance.

Read Post

Redgate

Read more about Data cataloging: A giraffe's eye view

Overcoming SQL Server Blocking and Locking Challenges

Jul 15, 2021 By Denny Cherry In SolarWinds

One of the most common performance problems with SQL Server databases in production is the blocking of queries, which happens because database resources are locked. Understanding why locking happens is just half the battle. Being able to resolve locking, which will resolve blocking issues as well, is the second half.

Read Post

SolarWinds

Read more about Overcoming SQL Server Blocking and Locking Challenges

Enabling Single Sign-On with SQL Monitor

Jul 13, 2021 By Ben Emmett In Redgate

It’s never been more critical to protect your data infrastructure against malicious actors, with organizations dealing with an ever-expanding number of increasingly sophisticated attacks. Monitoring solutions represent part of your infrastructure’s attack surface area – they enjoy highly privileged access to the systems they help manage, and store sensitive information about the workloads running on them.

Read Post

Redgate

Read more about Enabling Single Sign-On with SQL Monitor

Self-hosting vs Managed Services: Deciding how to host your database

Jul 12, 2021 By Max Rozen In OnlineOrNot

Like all good things in infrastructure, picking whether or not to self-host your database is full of trade-offs. On the one hand, you have the absolute freedom to do whatever it is you want with your database - whether it's adding a useful Postgres extension, or experimenting with new technologies. On the other hand, you now have to dedicate resources to keeping your database reliably online.

Read Post

OnlineOrNot

Read more about Self-hosting vs Managed Services: Deciding how to host your database

PostgreSQL Monitoring: The Best Tools and Key Metrics to Help Improve Database Performance

Jul 8, 2021 By Nilesh Jayanandana In Sematext

PostgreSQL is a popular open-source, object-relational database. As with any other data storage solution, capturing metrics is crucial for making sure your database is reliable, available, and performing optimally. This will help you dig deeper into database performance problems, do performance tuning, optimize queries and indexes, and make partitioning decisions. But that’s not all. You’ll also be able to set up alerts and plan for failures or upgrades.

Read Post