2019-11-01 (first published: 2017-09-11)
4,773 reads
Gary Strange
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.
2018-11-13
806 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)
35,428 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,350 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,299 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)
18,419 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,289 reads
Blogs
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors...
Forums
Extract date from String
Folks: I have to extract the date from this string which is between files_...
Detereming Trends in SSAS Cube
I have Analysis Services cubes with over 200 dimensions in them (product requirement believe...
SSDT server setup and using 3rd party tools across servers
Hello, We are a small shop and want to run, for data warehousing/reporting, 2016...
Ask SSC