-
Continue reading →: Installing SQL Server 2016 – Is it any different?
Howdy…it’s been a long time I’ve written something related to SQL Server here in my blog. So here I am, I took some time out of my holidays to download and Install SQL Server 2016 CTP 3.0 in my laptop. Let me share my thoughts on what has been changed/improved…
-
Continue reading →: SQL Server 2012 SP2 CU7 – @@Version
Today I was testing CU7 for SQL Server 2012 SP2 and as usual after installing CU on our test server, as a practice I was reviewing the Error Log and interestingly it mentioned CU7 during the startup! Let me show you what am saying…See below screenshot on a server running…
-
Continue reading →: SQL Server 2016 announced :)
Not sure if you guys have got a chance to grab updates from Microsoft Ignite event(Previously called TechEd), So here is a news for you. Microsoft CEO Satya Nadella announced SQL Server 2016 day before yesterday. It’s not yet available to download for public, but they are saying it(public preview) will…
-
Continue reading →: How to connect to Azure VM SQL Server from SSMS?
In one of my previous posts, I’ve shown how to connect to Azure SQL DB(DaaS) from your local SSMS. In this post, let’s see how you can connect to SQL Server Instance which is running inside your Azure Virtual machine. I’ve created a Azure VM(sreetestvm.cloudapp.net) with SQL Server 2014. I…
-
Continue reading →: Azure SQL DB using SSMS – Things you should know.
Hey folks…In this post let’s see few things which you should be aware of, to avoid any surprises when connecting to your Microsoft Azure SQL DB from your SSMS. First thing you might notice is there are no msdb,model and tempdb databases under system databases category, No Agent and pretty…
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
