-
Continue reading →: Windows8 – First Look and My personal Experiences!!!
Windows 8……….!! IMHO, this is one of the best products(with respect to client OS’es) from Microsoft so far. Being in Pre-development phase, it is showing stunning performance. As already shared in my previous post, I Installed Windows8 with Dual boot Option. Let me tell you something, Once i select Windows8…
-
Continue reading →: Installing Windows8 with Dual Boot Option
Hey……!All excited to let you guys know that at laaaaast I was able to Install Windows 8 in my Laptop 🙂 Huhuuuuuuuu. Thought of sharing my experiences with getting this done! How to Install Windows8 with Dual Boot Option? Before jumping into actual content, let me tell you guys difficulties I had when…
-
Continue reading →: Intel CPU’s for a SQL DBA- Few Awesome Resources to start with!
In recent times, I started spending most of my time analyzing the Hardware of a Physical Server and thought of sharing few resources from Intel’s website which i found very useful myself(Exploring CPU). Believe me guys, underlying H/W is the most interesting aspect to explore if you’ve really started thinking…
-
Continue reading →: SQL Server CheckPoints – Trace Flag 3502
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 →: Backup Internals – Trace Flag 3014
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…
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…
- AlwaysOn
- AlwaysOn Availability Groups
- Announcements
- Backups and Restores
- Cloud Computing
- Clustering
- Configuration
- Containers
- Corruptions
- Database
- Database Options
- DB Snapshots
- DBA Tips/Tricks
- DBCC.
- Disaster Recovery
- Encryption
- Generic Errors
- GraphDB
- HADR
- linked server
- Linux/RHEL/CentOS
- Maintenance Plans
- Microsoft Azure
- Mirroring
- miscellaneous
- MongoDB
- MSDTC
- Neo4J
- PerfMon
- Polls
- Service Packs/Cumulative Updates
- SQL Azure
- SQL Denali CTP3
- SQL In Linux
- SQL Server 2008/20008R2
- SQL Server 2012
- SQL Server 2014
- SQL Server 2014 CTP1
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- SQL Server Client tools
- SSAS
- SSIS
- SSMS
- SSRS
- Tools
- Trace Flags
- Uncategorized
- Windows
- Windows Server
- Windows Server 2012
