Most Popular Databases

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

Data Tampering: The Quiet Threat

For decades, data tampering has been limited to relatively simple attacks, like data corruption (which is immediately noticeable) or “cooking the books” to hide embezzlement or other financial failings. Of late, however, data tampering has been done with far more serious intent, such as redirecting shipments at sea or capturing financial or sensitive information. And, unfortunately, it’s getting […]

Read More

The PowerShell Scripting Environment

The PowerShell Integrated Scripting Environment (ISE) has been my bread and butter for years. As a consultant, it was the most reliable platform to develop any and all Orion® SDK scripts and tools on, as it’s almost universally installed on Windows platforms. However, a new world order is upon us, and the end of my […]

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

How many “MPP” is your team getting?

  Have you heard about the new metric by which to measure how hard your IT support technicians are working?  It’s “MPP” or “Miles Per Pair”. IT support technicians can put several miles on a pair of shoes in a day as they move from one user to another to address and resolve issues. Face […]

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
822