My primary responsibility is to help people with SQL Server Performance Tuning and Optimization, and I believe there are three important challenges any DBA faces. Today we will discuss why I prefer to use Spotlight to identify SQL Server Performance issues and their resolutions.
How to Prevent Common SQL Server Performance Problems Efficiently With Smart Capacity Planning
Have you ever imagined how often SQL Server performance issues are actually caused by poor capacity planning? Sometimes a SQL Server database has insufficient storage performance, an instance is running out of memory, or the server level CPU is skyrocketing to an unhealthy level.
SQL SERVER – Export Data From SSMS Query to Excel
Today’s blog post is actually a follow up of my earlier blog post SQL SERVER – Copy Data From SSMS Query Result to Excel. In the earlier blog post, we had discussed how to copy data from the resultset. In this blog post, we will discuss how we can directly export data from SSMS Query to Excel.Â
Oracle to SQL Server Data Migration and Replication – Budget and ROI
My primary job is to help various organizations design scalable architecture which can provide robust performance all the time. I love my job very much when I have complete freedom to make the decisions to build elaborate infrastructure. However, not every time I am allowed to do what I want to do because every CEO and CTO are concerned about one thing – “Budget and ROI (Return of investment).”
SQL SERVER – FIX: Msg 8180 – Statement(s) Could not be Prepared. Deferred Prepare Could not be Completed
While running a linked server query, I encountered an error and learned something new. In this blog we would learn about how to fix error – Msg 8180 – Statement(s) could not be prepared.
How to Move Log File or MDF File in SQL Server? – Interview Question of the Week #208
Question: How to Move Log File or MDF File in SQL Server?
SQLBits 2019: Attention Pre-Con Attendees – One Free Consulting Hour
SQLBits 2019 is one of my most favorite events.Â
If you are going to go to SQLBits 2019, you want to come to my pre-con about 21 Essential Scripts: Performance Tuning for EVERYONE. This pre-con contains best of my material and goes beyond what you conventionally know about any topic. It is no-nonsense, direct to demonstration and fast-paced advanced class where we discuss 21 essential scripts for SQL Server Performance Tuning.
SQL SERVER – FIX: Msg 9514 – XML Data Type is Not Supported in Distributed Queries
Sometimes, I get some quick questions via my blog comments and I do spend the time to search on them and reply or write a blog. In this blog we would learn how to fix: Msg 9514 – XML data type is not supported in distributed queries.
SQL SERVER – Copy Data From SSMS Query Result to Excel
Just another day I received a question via email about how to Copy Data From SSMS Query Result to Excel? This is indeed a very simple question but trusts me not everyone knows everything and this blog is dedicated to learning new things – a complicated one or even a simple one.
SQL SERVER – Cleanup Plan Cache For a Single Database
During my recent Comprehensive Database Performance Health Check, we had implemented quite a few improvements in the database. After making the improvements in the database, we reached to the point where we needed to clear the cache of the server to see how our improvements fairs with the changes which we have made.Â