-
Continue reading →: SQL Server Denali CTP3 and SQL Server 2008R2 SP1 – Released:)
Most awaited SQL Server Denali CTP3 has arrived atlast:) Microsoft has announced a public release of CTP 3 today. Also SQL Server 2008R2 SP1 was released Yesterday! Please note- this is a 180 day Eval edition which Microsoft released today. You can download from microsoft SQL Server Site or from https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/ Thought of…
-
Continue reading →: What a Fail Over Cluster can do for us?
Clustering: Cluster/ActivePassive/ActiveActive/SingleInstance/MultiInstance/Failover/Nodes/Services/Offline/Online….all these are the words which you will be listening very often if you are working with Windows Servers. (I’ll not be explaining all those terms and terminologies here in this blog post. They will be covered in another Blog post under Installing SQL Server Cluster.) So what exactly…
-
Continue reading →: SQL Connectivity Error
Early in the morning, one of my developers called me at my BlackBerry saying “Our UAT Server is down, application is not able to connect to backend, We need your immediate assistance”. Well, a typical start for the day with a typical SQL Server connectivity Issue! The Error msg what they…
-
Continue reading →: Practice/Worst Practice
Have been to an amazing trip visiting few of my friends and was not able to spend some time in my technical blogging :-p Okay! Anyways I’m back to business after a loong (No Pun Intended) trip! Thought of sharing one of my sickest and weirdest experience happened today because of…
-
Continue reading →: Mirroring – Things to Consider
DB Mirroring! Very fancy term which we all are hearing starting SQL Server 2005. Your DR Server is often called as “Hot Standby”( Real time Synch) when you are using DB mirroring where as it is considered as “Warm Standby” while your DR DB is Log Shipped! Gotcha – If…
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
