Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to crashes...
2023-06-07 (first published: 2023-05-08)
299 reads
This book will provide you with a good foundation upon which a consistent convention for practicing your day-to-day operations can have a solid footing in your database discipline, with...
2023-06-07 (first published: 2023-05-20)
350 reads
Script to identify the most expensive queries on your database server using the Query Store DMVs. This allows you to look at data from a specific time frame, as...
2023-06-07
6 reads
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal. Now, we can provision Microsoft fabric easily using Microsoft PowerBI premium per capacity or using...
2023-06-06 (first published: 2023-06-05)
27 reads
In this post we're going to go through the steps to set up Always Encrypted and create an encrypted column. As with my last post we're looking at the...
2023-06-06
11 reads
I’ve been using Azure SQL Database for quite some while and have set up it in many various ways to run Ola’s Index Optimize and
The post Using Azure Automation...
2023-06-06
12 reads
At Tuesday 6th of June 2023, I’m giving an online version of my session “Analyzing Azure Cosmos DB Data with Azure Synapse Link” (which I presented at Techorama). It’s...
2023-06-05
3 reads
Unlike TDE, there is some extra CPU overhead when you take an encrypted backup as the data has to be encrypted before being written to disk – whereas with...
2023-06-05 (first published: 2023-05-22)
193 reads
I get asked questions by salespeople all the time. Usually this is because a customer is struggling and I try to educate the salesperson as well as give them...
2023-06-05 (first published: 2023-06-02)
62 reads
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your stakeholders with a variety of tooltips that offer deeper insights. They love the tooltips, and...
2023-06-05
6 reads
Script to identify the most expensive queries on your database server using the Query...
In this post we're going to go through the steps to set up Always...
I’ve been using Azure SQL Database for quite some while and have set up...
I'm looking for best practice here and these are Azure VMs by the way....
Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...
Comments posted to this topic are about the item Build a Better WordPress Archives...
Ask SSC