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
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
Databases run the internet these days. Forums, online shopping, payment processors, and databases—most of them some form of SQL—are a massive part of the internet. That’s all well and good—very little would get done on the internet without the backing of databases—but when you deal with any form of user input, it’s paramount to clean […]
Read More
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
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
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
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
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
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 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 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
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