What Is Non-Uniform Memory Access (NUMA)?

Bare metal to cloud hosted virtual machines Non-Uniform Memory Access (NUMA) is a four-letter word in every sense, well beyond simply the number of characters in the acronym to many data professionals, particularly those in an operational database administrator (DBA)...

What Is Data Lake Management?

What Is Data Lake Management?

Through better data lake management, organizations can prevent highly disorganized data lakes from becoming data swamps.  Data lakes offer organizations a methodology for effectively handling big data resources. The information contained in the data lake is...

Business Reasons to Use a Hybrid Cloud Solution

Business Reasons to Use a Hybrid Cloud Solution

Organizations are finding that the most effective way to use public cloud resources is by employing a hybrid cloud model. Team productivity and efficiency can be impacted by the challenges of supporting systems in multiple locations. Many of IDERA’s database and...

What Is Server Performance Monitoring?

What Is Server Performance Monitoring?

Server performance monitoring is a practice designed to maintain high levels of database performance and availability.  It allows organizations to assess a server’s current state and determine what actions, if any, need to be taken to improve system...

How to migrate from old versions of InterBase?

I got a question this week about how to migrate from an old version of InterBase to the latest version, so I thought I would share a few tips and hints on how to move data forward from old versions. InterBase On Disk Structure Before we start, it is important to know...

Native v Hybrid v WebApp

Native v Hybrid v WebApp

I recently posted on my Embarcadero Blog about the 3 main types of mobile applications that developers write. Native apps, web-based mobile apps, and hybrid apps, and highlighted that you can achieve the benefits of both Hybrid development with a single code base to...

Why It’s Important to Optimize SQL Queries

Why It’s Important to Optimize SQL Queries

In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the “SmbShare” noun which represents local folders that you share on a network. Today we’re looking at the “SbmMapping”...

Columnstore Index for SQL Server

Columnstore Index for SQL Server

Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with rowstore indexes, SQL Server has columnstore indexes as well. In today’s blog post, we will be discussing the columnstore...

1 13 14 15 16 17 124