We have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run. This KQL query will...
2024-02-21 (first published: 2024-02-06)
225 reads
In a post, I wrote last month I showed how you can take advantage of your replicas in SQL Sever by adding a single attribute to your connection string...
2023-11-13 (first published: 2023-10-26)
431 reads
If you happen to be using C# there is a very easy way to set your application up to take advantage of Read-Only replicas.
Using this connection string: (Some portions...
2023-10-09 (first published: 2023-09-18)
886 reads
Microsoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is map-reduce before map-reduce was a popular...
2023-10-02 (first published: 2023-09-06)
437 reads
I thought I might pass along, what I have found to be, the most efficient way to validate the check digit within Azure SQL Server. I was looking to...
2023-07-17 (first published: 2023-07-10)
346 reads
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)
201 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)
303 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)
155 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)
315 reads
I'm excited to be presenting my talk on Building a complete API in Azure
2022-10-21 (first published: 2022-10-20)
9 reads
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
I recently had a new pipeline fail. It was actually a copy of an...
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
This is one of those things very hard (for me)to explain in words. See...
Comments posted to this topic are about the item Feeling your age? How would...
Hi, one of my server configured with Standard_D64ds_v4 what is next level of version...
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers