Configure Contained Availability Groups for High Availability in SQL Server 2022
In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.
2023-01-27
In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.
2023-01-27
Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?
2023-01-25
100 reads
In part 3 of this series, see how you can use the principles from the series to build an Azure Data Factory pipeline.
2023-01-25
3,472 reads
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity.
2023-01-25
This article shows how you can use an R script to import data into Power BI.
2023-01-23
1,288 reads
Removing data from your systems isn't as easy as you might think. It is especially important to be aware when you are doing this for compliance.
2023-01-23
188 reads
This tip drills down on how to process JSON files with SQL Server and demonstrates an approach for extracting key values from JSON nested key-value pairs.
2023-01-23
The last two weeks have brought a (seemingly) daily deluge of difficult news in the tech sector. Microsoft, Google, Facebook, and Amazon have all had significant layoffs with many friends in the #SQLFamily and data community being impacted. In times of uncertainty and heightened anxiety, it’s essential to have a group you can turn to […]
2023-01-21
88 reads
In this article, we look at how to do a point in time restore using TSQL and SSMS to recover a database to a particular point in time.
2023-01-20
In this article, Glen Cooper provides code that allows you to process a tree, or undirected graph of data. Lots of hierarchies fall into this category and the ability to process them is valuable in many reporting situations.
2023-01-20
2,808 reads
My biggest fear when my book went into production was that any factual errors...
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...
By Steve Jones
Today’s coping tip is to listen to a piece of music without doing anything...
Hi, I've been tasked with finding out why we've been unable to patch the...
Hi everyone, So I have a ssis package in which I download a excel...
Comments posted to this topic are about the item Cloud Diagrams