This blog is from one that came from a DBA from one of my consulting engagements. Let us learn how to fix event id 7000 error.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation – 2
Many disaster recovery solutions are available in SQL Server. Let’s learn how we can fix a specific log shipping error about the sysadmin fixed server role.
Application Locks With sp_getapplock: One Job at a Time
Use sp_getapplock to serialize a job, compare transaction and session ownership, handle return codes, and inspect a two-session test.
SQL SERVER – SQL Agent – Job Start Whenever the CPUs Become Idle
Recently I was asked by the customer of Comprehensive Database Performance Health Check about SQL Agent and Job starting whenever CPU Become Idle.
SQL SERVER – SQL Agent Job and Backslash – Strange Behavior
Today’s blog post is about SQL Agent Job and Backslash. I was surprised to see this behavior. Here are the steps to reproduce this behavior.
Performance Condition Alerts: Warnings Before a Log File Fills
Build performance condition alerts for log usage, tempdb free space, and blocking, with sensible delays and an operator response.
SQL SERVER – SQL Service Not Getting Started Automatically After Server Reboot While Using gMSA Account
My first gMSA test: SQL Service was not started automatically after server reboot, even with automatic startup set. Here is what the event log showed.