2 followers
I have over 31 years in the world of RDBMS. I have in-depth knowledge of Microsoft SQL Server and the Azure platform (Data Factories, Logic Apps, Functions, Event Grids).
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....
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...
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...
Microsoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is...
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 go...
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...