MSSQLTREK

  • SQL Connectivity Error

    Published by

    sreekanth bandarla

    on

    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 →: SQL Connectivity Error

  • Practice/Worst Practice

    Published by

    sreekanth bandarla

    on

    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 →: Practice/Worst Practice

  • Mirroring – Things to Consider

    Published by

    sreekanth bandarla

    on

    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…

    Continue reading →: Mirroring – Things to Consider

  • 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

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…