SQL Server Memory-Optimized Tables: Beginner’s Guide

Learn how memory-optimized tables work in SQL Server - In-Memory OLTP architecture, creating durable and schema-only tables, natively compiled stored...

14 February 2020 18 min read

BI

Andy Brown in BI

Creating Time-Intelligence Functions in DAX

DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in...

14 February 2020 19 min read

Performance

Greg Larsen in Performance

Get Your Scalar UDFs to Run Faster Without Code Changes

Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article,...

10 February 2020 14 min read

BI

Sanil Mhatre in BI

Sentiment Analysis with Power BI and Azure AI Language: A Practical Introduction

Perform sentiment analysis on survey responses using Power BI and Azure AI Language (formerly Azure Text Analytics). Part 1 covers...

03 February 2020 13 min read

Database Administration

Robert Sheldon in Database Administration

Storage 101: The Language of Storage

Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.…

22 January 2020 13 min read

Containers and Virtualization

Carlos Robles in Containers and Virtualization

Managing SQL Server Docker containers in macOS

In the second article of this series, Carlos Robles explains how to manage Docker images and containers.…

21 January 2020 11 min read

T-SQL Programming

Edward Pollack in T-SQL Programming

Gaps and Islands in SQL Server: Efficient Window Function Solutions

Advanced gaps and islands analysis in SQL Server using efficient window function patterns. Covers streak detection, PARTITION BY for multi-entity...

21 January 2020 32 min read

BI

Andy Brown in BI

Power BI Calendar Table: Create & Use Dates

Learn how to create calendar tables in Power BI using DAX functions like CALENDARAUTO and CALENDAR. Covers fiscal years, multiple...

03 January 2020 18 min read

T-SQL Programming

Edward Pollack in T-SQL Programming

Gaps and Islands in SQL: Techniques & Examples

Master gaps and islands analysis in SQL Server with practical T-SQL examples. Learn to identify consecutive sequences, find missing values,...

02 January 2020 19 min read

NoSQL

Shel Burkow in NoSQL

Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key

As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design...

18 December 2019 13 min read

Database Administration

Robert Sheldon in Database Administration

Storage 101: Welcome to the Wonderful World of Storage

Understanding all the storage options available today is not easy. In this new series, Robert Sheldon will explain what you...

03 December 2019 13 min read

T-SQL Programming

Joe Celko in T-SQL Programming

Do You Have REFERENCES?

The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include...

03 December 2019 13 min read

Database Administration

Forrest McDaniel in Database Administration

How Does Accelerated Database Recovery Work?

Accelerated Database Recovery is new with SQL Server 2019 and Azure SQL Database and used to decrease the time for...

26 November 2019 12 min read

Editorials

Kathi Kellenberger in Editorials

SSRS is Still Around

The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI...

20 November 2019 3 min read

T-SQL Programming

Joe Celko in T-SQL Programming

Understanding Auctions

We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the...

29 October 2019 13 min read

T-SQL Programming

Kathi Kellenberger in T-SQL Programming

PERCENTILE_CONT in SQL Server: Continuous Percentile and Interpolation Explained

How the SQL Server PERCENTILE_CONT function computes continuous percentiles using interpolation, with a worked example from AdventureWorks, comparison with PERCENTILE_DISC,...

17 October 2019 11 min read

T-SQL Programming

Joe Celko in T-SQL Programming