-
Continue reading →: DPM(Data Protection Manager 2010) Gotchas….
In the previous post, we’ve seen what is DPM and what can be achieved via DPM at a very High level. In this Blog Post, let’s see few GOTCHAS(The Oops Moments 😉 , things you should be aware of) to keep in mind implementing DPM. Let me get this very…
-
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…
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
