MSSQLTREK

SQL Server 2008/20008R2, Trace Flags

SQL Server CheckPoints – Trace Flag 3502

Published by

sreekanth bandarla

on

September 19, 2011

Checkpoint – One of the wonderful mechanisms baked within SQL Server to Flush Dirty Pages to Disk and to clear Transaction log(When a Database is Set to SIMPLE Recovery Model) automatically. Few scenarios where CHECKPOINTS are triggered automatically: When SQL Instance has been Shutdown, a checkpoint on all the databases.…
Continue reading →: SQL Server CheckPoints – Trace Flag 3502
SQL Server 2008/20008R2, Trace Flags

Backup Internals – Trace Flag 3014

Published by

sreekanth bandarla

on

September 15, 2011

Trace Flag 3014– This is one of the undocumented Trace flags in SQL Server, which basically gives a detailed information(Well, This might not be useful in most of the cases) regarding File Creation, Padding and much more related Info while you are taking a Backup of your Database. Do you…
Continue reading →: Backup Internals – Trace Flag 3014
Database, SQL Server 2008/20008R2, Trace Flags

Diagnosing Database Restores – Trace Flag 3004

Published by

sreekanth bandarla

on

September 14, 2011

Recently one of my fellow DBA had an issue with a Database Restore, where he was restoring a database using a full backup(from GUI) and the wizard was progressed upto 100% and it stayed there for more than 30 Minutes and he pinged me to see what’s going on!! Well,…
Continue reading →: Diagnosing Database Restores – Trace Flag 3004
SQL Server 2008/20008R2

When was SQL Server Restarted??

Published by

sreekanth bandarla

on

September 13, 2011

As a DBA seldom we see cases where a User reports “Hey Mr DBA, my application went down for a minute or even few minutes, Now everything appears to be Okay. Can you pls take a look what happened?” Well, our very First place should be SQL Server Error Logs(…
Continue reading →: When was SQL Server Restarted??
Encryption, SQL Server 2008/20008R2

SQL Server Encryption – Part5 Encrypting Data(TDE) vs Encrypting Connections

Published by

sreekanth bandarla

on

September 12, 2011

This is the final part of Encryption series where i’m going to show how to encrypt connections in SQL Server. In the previous 4 parts of this series we’ve seen how to enable TDE for your Database, what EFS is and what Bitlocker is. If you recall correctly, all we…
Continue reading →: SQL Server Encryption – Part5 Encrypting Data(TDE) vs Encrypting Connections

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…