2019-11-01 (first published: 2017-09-11)
5,463 reads
Gary Strange
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.
2018-11-13
1,779 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)
64,317 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,514 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)
11,581 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-13 (first published: 2012-09-25)
30,339 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
10,906 reads
Blogs
Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Forums
Varchar(max) to lines
I have an issue with a varchar(max) field with up to 7000 characters needing...
SQL MI Next-gen general purpose tier
Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers