We have very large Analysis Services(SSAS) cubes with billions of records and hundreds of users so we need to be able to monitor the performance of queries. 95% of...
2023-05-29 (first published: 2023-05-17)
154 reads
In publishing, and Im sure many other industries, we get data at both the daily level and the weekly level. To properly tie these two pieces of data you...
2022-11-16 (first published: 2022-11-05)
291 reads
My responsibilities revolve around providing the business with the data they need to make informed business decisions. One of those processes requires us to shift data from a Snowflake...
2022-11-11 (first published: 2022-10-30)
149 reads
With the release of composite models in PowerBI, Ive been able to solve a long-standing issue with SQL Server Analysis Services: text search performance. In this article I am...
2022-10-28 (first published: 2022-10-17)
295 reads
I'm excited to be presenting my talk on Building a complete API in Azure
2022-10-21 (first published: 2022-10-20)
6 reads
I've decided to move my blog here. You'll see some old content being uploaded in the next few days. Look around, I hope you find some tidbits of information.
Older...
2022-10-17
17 reads
I have a video detailing how to use Managed Identities to authenticate function apps in Azure.
2020-10-26
I decided to revisit my framework to see if I could improve the performance and possibly increase the number of scenarios this framework could be used in. Turns out...
2016-03-24
13 reads
I have text file that contains data for a given fiscal period. In this particular file there are around 2...
2013-11-14 (first published: 2013-11-05)
2,088 reads
I have text file that contains data for a given fiscal period. In this
particular file there are around 2 million records. The file needs to be
split into...
2013-11-05
2 reads
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
I know you can't do this in MSSQL, but hoping DW has progressed more....
Hi Folks trying the below but having zero luck and was wondering if anybody...
I have a varchar(max) column which has sensitive data and want to encrypt it....
Ask SSC