-
Continue reading →: Quorum Drive in Failover Cluster(Windows Server 2008R2)?
Let me share one of the interesting conversations I had couple of days ago with one of my colleagues. This was regarding Quorum Drive in Failover Cluster(This was Windows Server 2008R2). Let me tell you the story in short. ” She had a Question regarding Quorum(Q Drive typically) disappearing from…
-
Continue reading →: SQL 2012RC0 Database(s) Properties from 2008R2 SSMS
This is one interesting thing which I’ve Observed recently connecting to SQL Server 2012 via SSMS 2008R2. SSMS 2008R2 is not displaying Compatibility Levels of the 2012 databases! See below Screenshot for what I’m trying to explain. See below screenshot for the same database properties from SSMS 2012. As you…
-
Continue reading →: CNOs/VCOs(Computer Objects) and few ways to protect them…!
If you already have experience working on Clustered Environments, you might already know about CNO(Cluster Name Object) and VCO(Virtual Computer Object). For Newbies, let me explain what CNO and VCO are in a line or two… CNO: This is the Core piece of your Windows Cluster and acts as an…
-
Continue reading →: sp_configure and sys.Configurations
This would be a very small blogpost, Well, actually an informational Post, no Issues and no troubleshooting shown in this post! We all, being a DBA will be running “sp_configure” every now and then on our SQL Instances to see what are the configured settings on the Instances. okay, okay….If…
-
Continue reading →: Windows Networking Tools for SQL DBA’s – PATHPING/TRACERT/PING
Hey Folks! Hope you all had fabulous holiday season 🙂 In this Post let’s see Three fabulous tools which Windows OS offers for testing your Network between your Servers. A typical example for DBA’s would be testing Network Latency between your Prod and DR Server while initial testing of your…
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…
- AlwaysOn
- AlwaysOn Availability Groups
- Announcements
- Backups and Restores
- Cloud Computing
- Clustering
- Configuration
- Containers
- Corruptions
- Database
- Database Options
- DB Snapshots
- DBA Tips/Tricks
- DBCC.
- Disaster Recovery
- Encryption
- Generic Errors
- GraphDB
- HADR
- linked server
- Linux/RHEL/CentOS
- Maintenance Plans
- Microsoft Azure
- Mirroring
- miscellaneous
- MongoDB
- MSDTC
- Neo4J
- PerfMon
- Polls
- Service Packs/Cumulative Updates
- SQL Azure
- SQL Denali CTP3
- SQL In Linux
- SQL Server 2008/20008R2
- SQL Server 2012
- SQL Server 2014
- SQL Server 2014 CTP1
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- SQL Server Client tools
- SSAS
- SSIS
- SSMS
- SSRS
- Tools
- Trace Flags
- Uncategorized
- Windows
- Windows Server
- Windows Server 2012
