Tag Archives: Windows

Departure of a SQL Server Administrator – What to Check?

A SQL Server administrator has left. But what does that actually mean? What do we need to check to make sure that things will continue to work after their Active Directory account is disabled? Some things to check are: SQL … Continue reading

Posted in Uncategorized | Tagged , , , , , | 1 Comment

Error: There is not enough space on the disk

I was running a query in SQL Server Management Studio (SSMS), nothing too complicated, and got this error, unexpectedly: An error occurred while executing batch. Error message is: There is not enough space on the disk. There’s plenty of space … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

Longrunning Query – xp_cmdshell?

Flicking through the ol’ Solarwinds activity monitor, I spotted this one day: That four day purple thing on the right? Not good. (The remaining images are from a reconstruction, partly to protect the not-so-innocent, and partly because the first job … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , , | 1 Comment

Patching

We had a communication from an Ops team saying that they intended to apply Windows patches to all our SQL Servers in one six hour period. This just felt wrong, on so many levels, including: QA, UAT, DR, Production all … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment