Blog

blog

Index Structures in SQL Server

It’s no secret that indexes are a fundamental tool for great database performance.  Generally, more indexes can be used, the better your database performance will be.  In order to use those indexes correctly though, let's take a look at how index are structured to get a better understanding of their utility.

Nick Adams by Nick Adams

SQL Server Backups (High Level Overview)

Backing up data in your environment is a no-brainer but HOW to back up your data requires some high level understanding of what backup types are available and how those backups are managed.

Nick Adams by Nick Adams

“Concurrency” (ha no, not our company!) and Locks in SQL Server

SQL Server needs to be able to manage data with many different transactions happening that are reading, updating, inserting, and deleting.  Whenever SQL looks at data, it needs to put a lock on the record or object to maintain data integrity and allow stable “concurrency” while the database is being used.  There are several different locks that can be put on several fundamental different objects within SQL Server.  Let’s look at them.

Nick Adams by Nick Adams

Create a Table Partition in SQL Server 2012

Partitioning a SQL Table is a great way to organize your data for faster data retrieval.  Partitions do exactly that, break down the Table into organized pieces based on criteria from your columns.

Nick Adams by Nick Adams

SSAS Tabular Model Development Using Power BI Desktop

One of the challenges with SSAS Tabular model development, for me, has always been the need to fully vet out a new measure or calculation in the intended visuals. Is there another way beside Analyze in Excel?

Seth Bauer by Seth Bauer