2019-11-01 (first published: 2017-09-11)
4,857 reads
Gary Strange
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.
2018-11-13
864 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)
37,361 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
3,391 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)
9,545 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)
19,129 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
7,552 reads
Blogs
Daily Coping 30 Mar 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Error handling protip: @@Error resets after the next command
The system variable @@ERROR is a quick and easy way to retrieve the error...
Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions
Introduction Recently have been working on a “Proof of Concept” task where I wanted...
Forums
The Coping Thread
I've started a series on my blog about coping strategies during the pandemic: https://voiceofthedba.com/tag/life/...
Get the difference from one record to the one previous
In it's simplest form I want a table that I can use to store...
Regarding for Microsoft Azure Certification
Hello Everyone, I am new here and I am preparing for microsoft azure certification...
Ask SSC