While playing with my virtual machines, I screwed up something and my SQL service for my named instance was failing to start. Let us learn about a startup error.
When I tried to start via services.msc, here was the error
SQL SERVER – Message: “Please wait for the System Event Notification Service” When Trying to Logoff from RDP Session
I must tell you that there could be many reasons for this behavior, but in this blog, I would talk about a cause which was due to SQL Server. Let us learn about how to fix error related to the Notification Service.
SQL SERVER – Msg 7399, Level 16 – The OLE DB Provider “ADsDSOObject” for Linked Server “AD” Reported an Error
One of my blog reader told that they are having trouble with linked server to AD. SQL SERVER – How to Query Active Directory Data Using ADSI / LDAP Linked Server. Let us learn about error related to OLE DB Provider.
SQL SERVER – The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found
Recently, one of my clients contacted me to understand why they are seeing such messages in their application event log. Where it says The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found.
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
Due to development challenge people still use SQL 2012 in production. In one of the case a client told me that their application vendor has not approved SQL 2014 and above, so they were forced to install SQL 2012. There were getting below error while trying to install SQL Server 2012. Let us learn how to fix error while enabling windows feature.
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
Due to my connect with my many clients, learning never stops for me. Almost every day someone sends me email for quick 55 minute consultation. You can read more about it over here about how to fix error related to SQL Catalog.
How to Validate Email Address in SQL Server? – Interview Question of the Week #147
How to Validate Email Address in SQL Server?
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.