-
Continue reading →: Windows Server 2012 – My Very First Impression!
Hey…I’ve Installed Windows Server 2012 Datacenter Edition today in my laptop and would like to share my initial experiences from twenty thousand feet distance 🙂 . Let me tell you all, Installation Experience is awesome. It was very smooth and easy with less manual interventions! Everything was blazing smooth and…
-
Continue reading →: Cannot set a credential for principal ‘sa’. (Microsoft SQL Server, Error:15535)
In this Quick and dirty post, let’s see a simple fix for one of the annoying error messages you’ll see in SQL Server 2005. Basically, You’ll see below mentioned error in few cases when you try to change the sa password using SSMS. The Simple trick is to check the…
-
Continue reading →: How to Failover the Cluster Group in Windows Server 2008/2008R2
In this short Blog post let us see how to move(Failover) the Cluster Group from one node to other in a Windows Server 2008 Failover Cluster. See here for more details on locating your Cluster Group for your Cluster. Let’s get into the content! As you can see in the…
-
Continue reading →: Obtaining Pipe Delimited Results from SQL Server using SSMS
In this short Blog post let’s see how to fetch results in a Custom/pipe delimited format file directly from SSMS without any fancy SSIS Packages involved. In fact you can use SSMS for fetching result set as with any delimited value. As you all know with all the default settings…
-
Continue reading →: SQL Server 2012 Licensing – Myths/Gossips
This will be a pretty short blog post where I would like to share my thoughts on new Licensing policies of Microsoft SQL Sever 2012. Last year, when Microsoft announced that they are moving to Core Based Licensing from Socket based starting SQL 2012, I still remember many conversations we had within…
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
