MSSQLTREK

  • SSMS – Tweaks

    Published by

    sreekanth bandarla

    on

    SQL Server Management Studio – Outstanding UI provided by Microsoft for managing/Administering/Developing/manipulating  code in (for) SQL Server environments. As a DBA how much time would you spend with SSMS on a daily basis? I would say 90-95%! Well, we will be using Configuration manager if needed sometimes to troubleshoot few…

    Continue reading →: SSMS – Tweaks

  • PerfMon

    Published by

    sreekanth bandarla

    on

    Today I’m going to give a brief about collecting Performance Monitoring metrics using Perfmon. ( For a better Picture of what exactly is happening with your SQL Server, you may need to use SQL Profiler along with Perfmon and Ofcourse you should consider using DMO’s(Dynamic management Objects) starting SQL Server…

    Continue reading →: PerfMon

  • Simulate 824 IO Error

    Published by

    sreekanth bandarla

    on

    Simulating a 824 IO Error in SQL ServerJ.  Sounds Cool huh! Not really, Trust me, you won’t and never say 823/824 (and more often ignored Informational Sev 10 825 Message)  is cool once you encounter it on your Production Database! Okay…..Enough scaring you people. I tried to play a little…

    Continue reading →: Simulate 824 IO Error

  • MSDTC- SQL2005/Win2003 Cluster

    Published by

    sreekanth bandarla

    on

    Let me share my one of the experiences I had couple of weeks ago with my 4 node Active-Active Cluster. Our Non prod envi is a 4 Node A-A cluster with SQL Server 2005 SP3 (Don’t ask me why we are still on SQL 2005 and more even why on…

    Continue reading →: MSDTC- SQL2005/Win2003 Cluster

  • CHECKDB in ErrorLogs on STARTUP

    Published by

    sreekanth bandarla

    on

    Couple of days ago, one of my colleagues observed in the error logs saying, “CHECKDB for database Completed on the database(s) blabla” when she restarted SQL Server Services and she asked me how come SQL Server is running Checkdb within matter of seconds when SQL Services are restarted where as…

    Continue reading →: CHECKDB in ErrorLogs on STARTUP

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…