A New MVP Led Training Initiative – Cloud Formations
Hello Readers – I wanted to make sure those who follow my blog have heard about the new MVP led training initiative started by Paul Andrew (@mrpaulandrew). It’s called...
2022-07-04
50 reads
Hello Readers – I wanted to make sure those who follow my blog have heard about the new MVP led training initiative started by Paul Andrew (@mrpaulandrew). It’s called...
2022-07-04
50 reads
Azure CLI is really handy for all sorts of tasks. When I build solutions, POCs and environments and I want to tear down the resources I like to use...
2022-06-16
52 reads
Storage Accounts are pretty much integrated into so many different designs in Azure, whether you are using Azure Synapse, 3rd party product like Snowflake, or Event Streaming designs –...
2022-06-15
89 reads
I really like scale sets. It lets you create and manage up to 1000 load balanced VMs per availability zone using windows or Linux images. (We can have flexible...
2022-06-09
68 reads
There are many different family groups for Azure VMs each with its own purpose. Below is a summary of what can be selected. This is important because for example...
2022-06-06
33 reads
Lets write about Microsoft Azure, specially the area of high availability when it comes to virtual machines. No doubt you will know about Azure Virtual Machines. IaaS approach is...
2022-05-31
29 reads
A post close to my heart, Azure SQL Managed Instance, I have blogged about this many times but I feel I should be sharing more details about this. One...
2022-05-12
295 reads
The concept of a geo-replicated partnership between a primary and secondary node is very similar to that of something you may have seen with Azure SQL DB, where the...
2022-05-06
86 reads
I mentioned before that you could use the idea of data persistency to rebuild your data from total failure. There are two types. RDB and AOF. RDB – persists...
2022-04-28
59 reads
Let’s assume that you started off with the lower editions and capacity with Redis and your developers tell you to scale the Redis cluster. Well first to use a...
2022-04-25
46 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers