In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) cluster verification errors which might appear during installation or AddNode.
SQL SERVER – How to Know Transaction Isolation Level for Each Session?
During recent, Comprehensive Database Performance Health Check, I had a very interesting scenario. I was hired by a customer to identify their system’s unexpected performance bottlenecks. I do these for a living so I am usually pretty comfortable. However, this customer was so unique that after their permission I am sharing you their story of transaction isolation level.
SQL SERVER – Unable to Run Maintenance Plan. Error: Integration Services Evaluation Period has Expired
A few days ago, one of my clients contacted me to fix an error which they were getting while using maintenance plan – Integration Services evaluation period has expired. Here is the complete error message which was taken from job history.
We Are Sold Out – Practical Real World Performance Tuning – SQL Authority News
I am very excited to announce that we are sold out for the two of our class focusing on the USA time zone for Practical Real World Performance Tuning. This is indeed very exciting. If you have signed up for the training, we will be meeting later this week and next week. If you have not signed up for the training, indeed we will miss you during our training.
To be super honest, the request for this training was in demand for a quite a while and at the price point of USD 495, it was a quite a deal. Honestly, I had never thought that this training will be sold out so quickly. When I am looking back at this, I feel pretty comfortable that both the classes are filled up 100% and the audience is going to have lots of fun.
Driving up Database Coding Standards and Productivity with SQL Prompt
Alongside specialists, an IT department needs people who are broadly skilled and adaptable, who can pivot quickly to new projects, slot easily into new teams, and be productive quickly. In this blog post, we will learn about database coding standards and productivity.
SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).
My lab machine is my playground. Other than my real-world client’s problem, many blogs have come from my lab machine because I keep on breaking something or another on my server. Once I found that I was unable to start SQL Server Agent service for one of the SQL Server instances. In this blog, we would learn how to fix error Failed to initialize SQL Agent log (reason: Access is denied)
SQL SERVER – All the Features not Listed While Installing SQL Server
I was trying to install SQL BI features for one of the assignments I had got. In the setup wizard when I reached the Features Page I got a surprise of my life. There were many features missing! I could not see features available while installing SQL Server listed here:
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.
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.