Expert Insights

blog

Business Intelligence & SQL Server



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

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

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

Welcome to R!

A brief introduction to R Language

Nick Adams by Nick Adams

Watch “Level Up Your SQL Server Index Knowledge”!

Adding the right index is a little bit of science and a lot of knowledge about how your database is being used.

Knowing the basics about SQL Server indexes will help you be a better developer

Jes Borland by Jes Borland