SQL Server Performance Tuning Expert frontimage1

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL Server Performance Tuning Expert frontimage2

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

Life Lessons – Understanding Your Customer

A couple of weeks back, I wrote a blog around – Life Lessons – Are There Rules for Interacting With Customers. This has been just to write out what I had in mind and how I approached a customer in general. These are not rules written on stone, but are more of a methodology which I have made for my own self when interacting with customers. Trust me on this, over time you mature and tune this whole process while interacting with customers.

Read More

SQL SERVER – Becoming a More Effective DAX Developer with DAX Studio – Notes from the Field #134

[Note from Pinal]: This is a new episode of Notes from the Field series. I personally have no problem accepting that I do not know many topics. One of the such topics is DAX Studio. I always wanted to learn more and I finally got the opportunity to learn more.

In this episode of the Notes from the Field series I asked SQL Expert Bill Anton a very crucial question – How to become a more effective DAX developer with DAX Studio? Bill was very kind to answer the questions and provides plenty of information about how a novice developer can work with DAX Studio.

Read More

SQL SERVER – System Stored Procedures I Use to Get Started

Call me an old school or whatever – there are certain things I believe in strongly. I have a working style and these in my opinion have evolved over years. I keep innovating myself as I learn on my way but there are few things I do that always makes me think I have not changed much. Let us learn about System Stored Procedures I Use to Get Started.

Read More

SQL SERVER Installation – FeatureUpgradeMatrixCheck (SQL Server 2016 Feature Upgrade) setup rule failed

One of the best ways to learn problems faced by individuals and organizations is to look at the forums for these issues. Often I have visited MSDN forums and see if there are some hot or interesting issues. Sometimes it is interesting to see some setup failures and investigate for the root cause. They might look trivial, but the best part is going the path of troubleshooting can be refreshing and gives you immense satisfaction to how things work inside SQL Server or Windows. This blog is inspired by one such error that encountered and I found it interesting enough to share it on this blog for the benefit of a larger audience. Let us learn about SQL Server Installation Error.

Read More