-
Continue reading →: SQL Server Encryption – Part1
This is the First part of the Series Which Covers how to handle the Encryption piece in SQL Server. The Term “Encryption” is one of the Most Interesting and annoying things which we as DBA’s see, especially if we never dealt with Database Encryption,Certificates, Keys in the Past and all…
-
Continue reading →: BGINFO – Sysinternals
Let’s deviate a little bit from SQL Server in this Post;) Let’s get Straight to the point! Have you ever been in a situation logged in to your Windows Server and searching for “Service Packs Installed, IP Configurations, DNS Details, Boot Time, Drive/Volume(s) Information with the Free Space, Logged on…
-
Continue reading →: How to Transfer(Copy) Maintenance Plans from One Server to other???….
Update: Don’t copy or transfer Maintenance Plans. Create new ones Instead if needed or checkout Ola Hallengren’s Maintenance solution or Minionware suite. This would be a very short blog post where I’m going to show how maintenance plans can be copied over from one SQL Server to another. If you…
-
Continue reading →: Uninstalling SQL Server 2008/2008R2 Service Pack(s)
Uninstalling Just the Service Pack/CU without uninstalling the entire SQL Server Instance….!! Yes, A definite improvement, Starting SQL Server 2008. In SQL Server 2005 days if you want to Uninstall a Service Pack, basically you’ve to uninstall the entire SQL Server Instance. In other words…we didn’t had Roll Back Capability…
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
