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-09-18
36 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-09-08 (first published: 2023-09-06)
19 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)
250 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)
167 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)
298 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
The Identity property creates an incremental value for the specified column automatically, which is...
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
Comments posted to this topic are about the item Restore With Standby; A Review...
Comments posted to this topic are about the item Are You Worried About AI?
Comments posted to this topic are about the item The Upgraded Procedure part 2
Ask SSC