2019-11-01 (first published: 2017-09-11)
5,029 reads
Gary Strange
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.
2018-11-13
1,163 reads
Dynamically Query a 100 Million Row Table-Efficiently
This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.
2016-05-27 (first published: 2015-02-24)
47,262 reads
DAX: Topn is not a Filter
In this document I will demonstrate how using the TOPN function in a DAX query doesn’t necessarily do what you may expect.
2014-05-01
4,004 reads
DAX Query - Part 2
A more detailed look at the DAX language and some of its more frequently used functions
2013-12-13 (first published: 2013-05-02)
10,669 reads
DAX Query Basics
In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.
2013-12-12 (first published: 2012-09-25)
22,838 reads
Asynchronous Procesing with Service Broker
Service Broker is a great feature that allows you to defer processing in SQL Server. Learn how you can have processes work together, but in an asynchronous fashion in this piece from Gary Strange.
2011-05-17
8,614 reads
Blogs
2020 Advent of Code–Day 3
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
Welcome to the Azure Data Community, empowered by Microsoft
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
Daily Coping 24 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Long SSIS job failed with connection failure
I have a long ETL SSIS process, one step is to call a web...
Minimal Downtime Storage Migration of Large Databases
Comments posted to this topic are about the item Minimal Downtime Storage Migration of...
Some questions regarding Service Broker
Hi all, I have a third-party database/application that I'm attempting to augment with functionality...
Ask SSC