Jul 31, 2020 | High Availability, Microsoft Azure, SQL Server |
BCP… Panic in a Pandemic? No doubt BCP has been high on your agenda over the last six months? It’s highly likely that a new, remote way of working is here to stay. Do you need to revise your business continuity planning to meet the new world? If you use...
Mar 6, 2018 | DBA, Free Training, SQL Server |
In this post and video, you will learn how to identify the owner and then change the owner of a SQL Agent Job. Have you ever had issues where the owner of a SQL Agent job leaves and their windows active directory account gets deleted/removed/disabled and the job(s)...
Jan 15, 2018 | Azure VM, SQL Server, SQL Server 2014 |
I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server was running the Database Engine, Reporting Services and Integration ServicesI actually run through a blog post I wrote the best of 8 years...
Jan 10, 2018 | ChrisG, SQL Server |
This post is by Chris GibsonI recently wanted to exclude some temporary SQL databases from being discovered by our SCOM environment. These databases are created during a backup process and are always named “_Clone”. I’d previously excluded SQL...
Jan 8, 2018 | Security, SQL Server, version |
The latest security issue with the name “Meltdown and Spectre” affecting Intel processors was made public last week. This security issue affects a lot of systems and Operating Systems it is not a Microsoft specific issue. I think I read somewhere...
Jan 3, 2018 | SQL Server, version |
I have a twitter poll running asking “What is the oldest version of SQL Server you are running?”, to use as evidence in a talk I have planned for later in the year. I’d like to know what is the oldest version of SQL Server you have running...
