As the title says, this script looks for any failed or cancelled jobs and will restart them from the failed step automatically. This type of script is useful in below scenario: You have a job with multiple steps which runs overnight and is required to be completed before start of Read more…
The Problem: I have 2 SQL Server names Server A and Server B. I have created a linked server on Server A to Server B which means I would like to run a query on Server A which pulls some data from a database on Server B. I configured the Read more…
An ideal way to verify if the connections are using TLS 1.2 protocol or not is through some network monitoring tools like Netmon or Wireshark. However from SQL Server, we can monitor them using extended events and can be done only for SQL Server 2012 SP2 and above. Below is the Process: Open SSMS Read more…
SQL VDI Errors (SQLVDIMemoryName_0) SQL Backup failed messages logged in SQL Error Log On one of our SQL Servers, we have noticed backup failed messages in SQL Error Logs. BACKUP failed to complete the command BACKUP DATABASE master. Check the backup application log for detailed messages. However when we have Read more…
Nowadays security takes utmost importance in the wake of several data breaches reported in the last few years. These are also enforced by some regulatory authorities (GDPR or Data Protection Act or PCI standards) as compliance. Particularly the companies involved in processing customer payments have to adhere to PCI DSS Read more…
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider When you try to open SQL Server Configuration you get the below error: Cannot connect to WMI provider. You do not have permission or the server is unreachable. This can happen due to many reasons: On a 64-bit machine, Read more…
We use logshipping as a Disaster Recovery for our production databases to a server in different location. We would need to monitor the synchronisation status of the logshipping secondary databases. We did not like to use the default monitoring job (LSAlert) created by logshipping and hence built our custom solution. Read more…
How often have we not encountered this situation as a DBA. Troubleshooting performance problems is often the critical challenge a DBA has to face. When you see High CPU condition in your environment, you would need a to-do action checklist to bring everything to normal as soon as possible. If Read more…
Extended events have been around since SQL Server 2008 version. This was created by Microsoft as a light weight way of tracking and monitoring SQL Server. As DBA, I was traditionally used to using SQL profiler and tracing for performance troubleshooting over the years and correlate the data with other Read more…
As SQL Server Database Administrator or Developer you might have noticed different types of error messages logged in SQL Server Error Log. Usually most of the SQL errors are in the below format: Error: <number> : Severity: <number>; State: <number> Usually most of the times you would find an error Read more…