Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.

Using Power BI in a Hybrid Environment

by Additional Articles

Microsoft MSDN

Power BI

This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.

Be Prepared with Baselines

by Steve Jones

SQLServerCentral.com

Editorial

Analyzing performance often requires you to understand what is normal and what is not. Steve talks about the importance of baselines.

Improving SQL Server 2016 Large Database Performance

by Henrik Thomsen

SQLServerCentral.com

SQL Server 2016 Performance

This article aims to save you days or weeks of troubleshooting when using SQL Server 2016 for large databases

Microsoft and GitHub

by Steve Jones

SQLServerCentral.com

Editorial

The Microsoft acquisition of GitHub doesn't worry Steve.

Converting a Database to In-Memory OLTP

by Additional Articles

SimpleTalk

In-Memory OLTP Tables

In-Memory OLTP was introduced with SQL Server 2014 as a way to improve transaction performance. There are several scenarios that are not supported, such as some data types, and Darko Martinovic describes the issues and provides workarounds. He also has provided a tool to assist in migrating disk-based tables to In-Memory optimized tables.