2019-11-01 (first published: 2017-09-11)
5,417 reads
Gary Strange
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.
2018-11-13
1,670 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)
62,239 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,481 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,477 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)
29,675 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,479 reads
Blogs
Derby City Data Days
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
Tomorrow: Webcast on SQL Server security
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
A New Word: the Wends
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
Forums
Difference between equal directly and use SUBSTRING
Hello, I have a script that was running really long, and I have found...
Visualisation options as an alternative to SanKey diagram
I am building a report to show customer journeys and their arrears levels. I...
should i prefer join or left join over exists or in
hi, I have seen people use exists when exists is required and no cols...
Question of the Day
Express In-Memory OLTP
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers