MSSQLTREK

Backups and Restores, Disaster Recovery, Tools

Ola Hallengren’s DDBoost Backups

Published by

sreekanth bandarla

on

July 12, 2018

The already awesome Ola’s Maintenance solution for SQL Server became more awesome with his latest release. If you are not aware of Ola’s maintenance solution, you should definitely check it out. In the July 2018 release, quite a few enhancements were introduced. My personal favorites are ability to add percentage…
Continue reading →: Ola Hallengren’s DDBoost Backups
SSMS, Tools

Dedicated Admin Connection(DAC) from SSMS

Published by

sreekanth bandarla

on

June 28, 2018

DAC is probably the most useful tool for troubleshooting SQL Server in few scenarios. Basically, It can be used as a back door entry in case the server goes unresponsive and doesn’t accept any new connections. So, how to make a DAC to SQL Server Instance? Preferred way is to…
Continue reading →: Dedicated Admin Connection(DAC) from SSMS
Corruptions, DBCC., SQL Server 2016

dbccLastKnownGood – The 2016 way.

Published by

sreekanth bandarla

on

May 14, 2018

How to check when was the last known good CheckDB for a given database? As of today on all the versions including SQL 2017(Except 2016 SP2), the easiest way we can get that information is by querying boot page of the database and look for “dbi_dbccLastKnownGood” value. You could do…
Continue reading →: dbccLastKnownGood – The 2016 way.
Announcements

I became a SQLShack community Author :)

Published by

sreekanth bandarla

on

May 9, 2018

I am excited to announce that I’ve my first article published on SQLShack and I am really thankful to ApexSQL for giving me this opportunity. Please hop over and leave feedback/comments/suggestions.
Continue reading →: I became a SQLShack community Author :)
Service Packs/Cumulative Updates, SQL Server 2016

SQL Server 2016 SP2 got released :)

Published by

sreekanth bandarla

on

April 24, 2018

Microsoft released SQL Server 2016 Service Pack 2 today. Visit https://support.microsoft.com/en-us/help/4052908/sql-server-2016-service-pack-2-release-information for all the details you need. There’s a looooong list of number of bugs fixed and enhancements made. Couple of DMVs and features from SQL 2017 were back ported as well. Make sure you go all the way to…
Continue reading →: SQL Server 2016 SP2 got 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…