MSSQLTREK

Cloud Computing

How to create a SQL Server Instance on Amazon RDS

Published by

sreekanth bandarla

on

February 16, 2017

In this blog post let’s see how to create a SQL Server Instance on Amazon RDS (Relational Database Service). I will be using defaults for most of the part in this screenshot tour to keep it simple. This post doesn’t cover what a VPC is, What a Security Group is…
Continue reading →: How to create a SQL Server Instance on Amazon RDS
Clustering, Windows Server

Upgrading Windows Failover Cluster 2012R2 to 2016

Published by

sreekanth bandarla

on

February 4, 2017

In this blog post, let’s see how to upgrade a Windows Server 2012R2 Failover cluster to Windows Server 2016. My current LAB setup is a 3 node cluster, all running 2012R2 and I decided to upgrade them to 2016 to learn new features/enhancements of windows server 2016. Thought of coming…
Continue reading →: Upgrading Windows Failover Cluster 2012R2 to 2016
AlwaysOn, AlwaysOn Availability Groups, SQL Server 2016

How to move AlwaysON AG Databases ?

Published by

sreekanth bandarla

on

July 15, 2016

Back in 2011, we have seen how to move a database which is participating in DB Mirroring here. In this blog post, let’s see how to move a database which is participating in a AG to a new drive(location). In my AG setup,I’ve three replicas(2 near Replicas-Sync mode and 1…
Continue reading →: How to move AlwaysON AG Databases ?
AlwaysOn Availability Groups, Clustering, SQL Server 2016

Lab setup – AlwaysOn AGs in a Multi Subnet Cluster – Part 2

Published by

sreekanth bandarla

on

July 10, 2016

In part1, I’ve shown how to create a windows cluster in a multi subnet setup. In this post let’s see how to create a AG and corresponding listener. In my lab, I will be creating two AGs and two corresponding listeners. Details: I’ve two databases – > sales and customers.…
Continue reading →: Lab setup – AlwaysOn AGs in a Multi Subnet Cluster – Part 2
AlwaysOn Availability Groups, Clustering, SQL Server 2016

Lab setup – AlwaysOn AGs in a Multi Subnet Cluster – Part 1

Published by

sreekanth bandarla

on

July 10, 2016

Let’s see how to setup an AG(SQL 2016) in a multi subnet cluster(Geo cluster) in a lab environment. Below is my lab setup: Two Replicas sitting in my Production Data center.(Subnet 192.168.1.x) – Sync Mode Automatic Failover. Third(Far) Replica sitting in my DR Data Center.(Subnet 192.168.2.x) – Asynch Mode Manual…
Continue reading →: Lab setup – AlwaysOn AGs in a Multi Subnet Cluster – Part 1

Howdy!

Welcome to MSSQLTREK, my little corner of the internet where I geek out about SQL Server, databases, and all things cloud. This blog is my space to share lessons learned, cool tips, real-world troubleshooting stories, and the occasional deep dive into data and performance. Whether you’re a fellow Cloud Architect, DBA, Developer, or just cloud-curious, come along for the ride — let’s explore, optimize, and build awesome data solutions together!

Recent posts

Let’s connect

Join the party!

Stay updated with my posts…