Skip to main content

Authors

Concurrency Authors

HDInsight in Azure

One of the most powerful Big Data and data analytics solutions available and easy to set up: Microsoft HDInsight

Nick Adams by Nick Adams

Understanding NoSQL

A quick and basic understanding of what NoSQL is.

Nick Adams by Nick Adams

Installing SQL Server on a Domain Controller: What You need to know

SQL Server can often be a very high strung application that has many requirements and best practices to follow.  Sometimes hosting several services on one server is necessary with smaller or very lean organizations.  Today, we look at the information you need to be aware of when concurrently running SQL Server on a Domain Controller.

Nick Adams by Nick Adams

SQL Server Filegroups

A look how to create SQL Filegroups and what they are.

Nick Adams by Nick Adams

Creating Logins and Users in SQL Server

In order for any application to work, Logins are needed to authenticate to the application and Users need to interact and be allowed access to the application.  SQL Server is no different.  This article will teach you how to create Logins and Users for SQL Server on a relatively high level to begin your understanding of how SQL Server authentication and access is allowed.

Nick Adams by Nick Adams

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

Concurrency Authors