-
Continue reading →: This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)
This morning one of our developers contacted me regarding this error message he got when he tried to design a table from his SSMS. Also, he reported that his SSMS goes to “Not Responding” state when he tries to edit rows using his SSMS. So…What’s happening? He was trying to edit a table…
-
Continue reading →: Physical Server or a Virtual Machine?
Lot of times, when stepping up for supporting a new SQL Server Instance, we as a DBA need to know whether it’s running on a Physical Machine or a VM. In this post, I will provide you guys with a simple T-SQL Script which you can run from your client…
-
Continue reading →: SQL Server 2012 SP2 RTM got released :)
Yesterday, microsoft released Service Pack 2 for SQL Sever 2012. They made Slipstream Installation packages available as well to the customers 🙂 And hey, you know what….CU1 for SQL Server 2012 SP2 is scheduled to release in July 2014. It’s time to upgrade all your SQL Server 2012 Instances to…
-
Continue reading →: The Wait is Over-Much awaited SQL Server Service packs are just around the corner.
Hurray…! At laaaaaast Microsoft officially announced today that they are planning to ship one last Service pack for both SQL Server 2008 and 2008R2. Timing of the release will be little odd though. They will be available to public after July 8th 2014(After Mainstream support ends). This is defenitely a…
-
Continue reading →: Idera’s SQL Extended Events Profiler – concise and Elegant tool for SQL DBAs!
In this blog post, I would like to introduce all of you to a very cool and concise Free tool from Idera. Note: I Do not work for Idera. Idera has nothing to do with this blog post. Am expressing just my opinion with my experiences with this free tool.…
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
