Azure In Pictures: SQL Server Always On Availability Group

The figure below is a graphical representation of SQL Server availability group solution  in Azure for HADR consisting of the following elements:
  • A virtual network containing multiple subnets, including a front-end and a back-end subnet
  • Two domain controller with an Active Directory (AD) domain
  • Two SQL Server VMs deployed to the back-end subnet and joined to the AD domain
  • A 3-node WSFC cluster with the Node Majority quorum model
  • An availability group with two synchronous-commit replicas of an availability database
You can reduce the number of virtual machines by using a domain controller as the quorum file share witness. This would reduce the number of VMs for a two-replica availability group

Related:
- Creating SQL Server 2014 Always On Availability Group in an existing Azure VNET and Active Directory instance
- SQL Server AlwaysOn Availability Groups Listener configuration with Azure External Load Balancer

Comments

Post a Comment

Popular posts from this blog

HOW TO Read Linux ext4 Files on Windows with 7-Zip (No Drivers Needed)

Image
File systems are the organizational systems that decide how data is stored, named, located, and protected on a disk, SSD, USB drive, or partition. They handle directories, file metadata (permissions, timestamps, ownership), free space tracking, and more. Windows side Windows primarily uses: NTFS — the modern default. It supports journaling (for crash recovery), large files and volumes, fine-grained permissions, encryption, and compression. FAT32 and exFAT — simpler, widely used on removable media (USB sticks, SD cards) because they are highly cross-compatible with other operating systems. Windows has no native support for the main Linux file systems. When you connect a drive formatted with ext2/3/4, Windows typically sees it as “RAW” or unknown and may offer to format it (which would destroy the data). Linux side Most Linux distributions default to the ext family: ext2 — the older, non-journaling version. ext3 — added journaling for better reliability. ext4 — the current standard. It a...
Read more

20 SQL Server 2005 Keyboard Shortcuts

What is the bored mother of a geek called? Motherboard There are a bunch of SQL Server 2005 Keyboard Shortcuts on MSDN , but I find these 20 super convenient & use it very often. Description Shortcut Create a New File CTRL+N Toggle full screen mode SHIFT+ALT+ENTER Set or remove a bookmark at the current line CTRL+K, CTRL+K Next bookmark CTRL+K, CTRL+N Previous bookmark CTRL+K, CTRL+P Clear bookmarks CTRL+K, CTRL+L Make the selected text a comment CTRL+K, CTRL+C Uncomment the selected text CTRL+K, CTRL + U Make the selected text upper case CTRL+SHIFT+U Make the selected text lower case CTRL+SHIFT+L Toggle between query and results pane F6 Display Object Explorer F8 Output results in text format CTRL+D Output results in a grid CTRL+T Cancel the executing query ALT+BREAK Display the estimated execution plan CTRL+L Display the Replace dialog box CTRL+F Display the Find dialog box CTRL+H Start incremental search CTRL+I Find the next occurrence of the previous search text F3 Related link...
Read more

The Diet Delinquent

Image
See more of my AI co-creations With just a prompt, Grok was able to take a  repurposed   hand-drawn cartoon from 2004  and generate an image of it doing a 'namaste'.  I’ve been getting by with free Windows-native tools like Paint, Paint 3D , and the Generative Erase feature in Photos . Grok's image editing feature, which can be activated simply by prompting, is a fantastic resource for amateur cartoonists. 
Read more