2014-02-28 (first published: 2011-02-16)
13,474 reads
Todd Fifield
- Interests: Music Producing/Writing
2014-02-21 (first published: 2010-08-16)
15,786 reads
Calendar Tables
Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.
2014-02-14 (first published: 2010-07-15)
41,914 reads
Using a Variable for an IN Predicate
How to use a passed string variable for an IN type predicate in your queries as a way to more efficiently handle an array of strings.
2013-03-01 (first published: 2011-06-21)
26,198 reads
Key Word Searches
This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.
2012-09-07 (first published: 2011-02-28)
34,883 reads
Blogs
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to...
Inspector V2.6 now available
As always the code can be found here in our github repoWe updated our...
Data Mesh: Centralized ownership vs decentralized ownership
By James-Serra
I have done a ton of research lately on Data Mesh (see the excellent...
Forums
Do You Have ALL the YAML?
Comments posted to this topic are about the item Do You Have ALL the...
Why Power Query as an Activity in Azure Data Factory and SSIS?
Comments posted to this topic are about the item Why Power Query as an...
Azure Blob Store Redundancy
Comments posted to this topic are about the item Azure Blob Store Redundancy
Ask SSC