Enterprises now has four options to host SQL Server in environment SQL Server on Physical Machines SQL Server on VMs in DataCenters SQL Server on Azure VMs (IaaS) SQL Server on Azure SQL Database (PaaS) The following presentation can be used as a reference to decide on where to host your SQL Server Instance
Last week, I worked on an issue which might sound weird or strange when you hear it for the first time. “Whenever we fail SQL Server AlwaysON Group from Cluster, Node A loses its network connectivity.” (Sounds weird, Right ???) Here is the email which I received from my customer We’re able to re-create the…
Security Hardening or Security Audits in an enterprise are some of the motivation for DBAs to run SQL Server default instance on a non-default port. For standalone instances, there are no challenges in changing the default instance port to non-default port, however for clustered instance there are some considerations since cluster.exe performs IsAlive check by…
As I interact with more & more customers who are onboarding on Azure which is the Microsoft Cloud solution, one of the common myth or assumptions which I hear or encounter is “We just need to deploy the application or database in cloud & Microsoft will take care of the OS, Storage, patching etc” “After…
This is my first attempt of blogging a non-technical topic (non-technical but still related to technology) since I never felt it is my cup of tea. However the recent changes & developments which I am witnessing around me has provoked a lot of new thoughts in me which I wanted to pen down for my own…
I have chosen this title for my blog post since troubleshooting this issue was like solving a mystery. One of my customer had recently faced a slow performance while loading the data in a partitioned table. Whenever there is performance issue for an insert statement, the usual suspects which come to our mind is blocking…
Recently I presented a demo on Power BI for the internal audience at Microsoft which was very received & appreciated by the audience. I thought it would be a good demonstration for external audience as well. Hope you all like the demo & Power BI !!! Parikshit Savjani Premier Field Engineer
Today, I was asked the following question by one of my colleague who specializes in Sharepoint If the actual data is 50GB in size & if we create a pre-grown data file of 200GB to avoid autogrow & fragmentation, the database restore time for the pre-grown database should be much larger than the restore time…
Recently my customer reported they were seeing intermittent server hangs, connection timeouts and slow performance on their SQL Server instance. The first question I had, do we have PSSDIAG running on the SQL Instance for me to be able to understand the cause of the hang. However since we won’t be running PSSDIAG proactively on…
Recently while troubleshooting a performance issue on the SQL Instance which was experiencing a very high THREADPOOL wait type I observed something which I was unaware until I hit this issue. While I was looking at the system health xel files captured at the time of the issue, specifically at the query_processing event trace, the…