Most Popular Databases

AWS SQL Server: Everything You Need to Know

In an increasingly data-driven business landscape, it’s no secret that more organizations rely on cloud-based databases to support their enterprise needs. But with plenty of options available, understanding what solutions are best suited for your business can be challenging. Here, we’ll break down two of the most popular enterprise-grade relational database management systems on the […]

Read More

Best Database Monitoring Tools

You’re probably familiar with the phrase, “software is eating the world.” In the last couple of decades, the importance and pervasiveness of technology in our society and our lives reached levels past generations would consider the realm of science-fiction. You probably have in your pocket, right now, a computer way more powerful than the one […]

Read More

The Consumerization of Database Appliances

Database appliances seem to be coming back into the forefront. There are several reasons for this, and the resurgence of interest in database appliances has some interesting implications for IT teams. A database appliance is a server preconfigured with a specific database rated to handle a fixed number of transactions per second. The key advantages […]

Read More

Why you Need a Database Performance Solution to Supplement your End-to-End Monitoring

Preface: Jez Marsh is a SolarWinds MVP and the founder of Silverback Systems U.K., a solutions provider working with customers to sharpen their operations processes and maximize their investment in their monitoring solutions. He primarily works with customers to implement SolarWinds network management software and systems management solutions but has found a growing need for […]

Read More

How to Maintain Legacy Databases in 2019

Many organizations rely on applications older than several of their employees. We’ve all heard the horror stories of some ancient DOS application running on FoxPro still in use today running mission-critical tasks. Many of us have personally struggled with the issue of maintaining an older, legacy database (or several), and often the legacy applications they […]

Read More

How Amazon Outposts Will Change Databases

Many of Amazon’s proprietary public cloud capabilities are coming to an on-premises data center near you in the form of Amazon Outposts. Others may be made available through alternate routes. Amazon RDS, for example, is now available on VMware-based infrastructures. This change in tactics by Amazon represents the biggest change for the traditional database administrator […]

Read More

SQL Server Internals: Snapshot Isolation – Part 2

In Part 1 of this topic (“SQL Server Internals: Snapshot Isolation”) I told you about the two different ways to use snapshot isolation, either with an alternative implementation of the default READ COMMITTED Isolation Level (called READ COMMITTED SNAPSHOT, or RCSI) or by using a whole new Isolation Level called SNAPSHOT. RCSI is a statement […]

Read More

SQL Server Internals: Snapshot Isolation – Part 1

https://logicalread.com/sql-server-internals-snapshot-isolation-part-2/ SQL Server has been around for over 30 years, and I’ve been working with it for almost as long. I’ve seen a lot of changes over the years (and decades!) and versions of this incredible product. In these posts, I’ll share with you how I look at some of the features or aspects of […]

Read More

SQL Server Internals: Tempdb Part 2

SQL Server Internals: Tempdb Part 1 In part one of this topic (“SQL Server Internals: Tempdb”), I told you what your tempdb database is used for, and what the main differences are between tempdb and user databases. In the post, we’ll look at the files created for tempdb. You can see the files that you […]

Read More

SQL Server Internals: Tempdb Part 1

SQL Server Internals: Tempdb Part 2 SQL Server has been around for over 30 years, and I’ve been working with SQL Server for almost as long. I’ve seen a lot of changes over the years (and decades!) and versions of this incredible product.  In these posts I’ll share with you how I look at some […]

Read More

Choosing Between Rowstore Indexes and Columnstore Indexes

Since the columnstore index was first introduced back with SQL Server® 2012, there have been a lot of questions about when you should use a columnstore and when you should use a traditional rowstore index. This is especially true following Microsoft’s latest enhancements to the columnstore. Microsoft touts some impressive performance gains using the columnstore […]

Read More