MSSQLTREK

Tools

SQL Live Monitor – Great Free Monitoring tool from Codeplex!

Published by

sreekanth bandarla

on

May 22, 2012

How many times do you use DMV’s daily supporting your SQL Server environments? How many of you rely on 3rd party tools for looking at the current snapshot of your SQL Server? Let me say this, I use DMV’s a lot even though I’m provided with fancy 3rd party monitoring…
Continue reading →: SQL Live Monitor – Great Free Monitoring tool from Codeplex!
SQL Server 2008/20008R2

SQL Server 2008R2 SP2(CTP) got released

Published by

sreekanth bandarla

on

May 14, 2012

Microsoft released SQL Server2008R2 SP2(CTP) yesterday(13th May 2012). You can download and test if if you are willing to from http://www.microsoft.com/en-us/download/details.aspx?id=29848 For list of Bugs that got fixed with this release, visit http://support.microsoft.com/kb/2630455 Cheers!
Continue reading →: SQL Server 2008R2 SP2(CTP) got released
Tools, Windows

MAP(Microsoft Assessment and Planning Tool kit) 6.5 for SQL Server Discovery

Published by

sreekanth bandarla

on

May 9, 2012

Hello Folks! In this Blog Post let’s see how to make use of MAP tool for discovering all of your SQL Servers in your Environment. MAP is one of the wonderful tools(free) provided by Microsoft, which basically scans all over your Network and present you with a wonderful report on…
Continue reading →: MAP(Microsoft Assessment and Planning Tool kit) 6.5 for SQL Server Discovery
miscellaneous

How to Truncate/Delete all Tables in a SQL Server Database?

Published by

sreekanth bandarla

on

May 1, 2012

How to Truncate/Delete all Tables in a SQL Server Database in three simple steps???? Howdy! In this post let’s see how to truncate/delete all the tables in a given SQL Server Database and few important considerations while doing so. Today, I had a request from one of my Application teams…
Continue reading →: How to Truncate/Delete all Tables in a SQL Server Database?
SQL Server 2012

SQL Server 2012 CU1 Released!!

Published by

sreekanth bandarla

on

April 18, 2012

Microsoft has released CU1 for SQL Server 2012 RTM within 3 weeks of the initial release of the product, which has more than 50 fixes! This is something really interesting to me which I’ve never seen(at least I don’t remember) where they had fixes for ~50 bugs in a Cumulative…
Continue reading →: SQL Server 2012 CU1 Released!!

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…