Profile cover photo
Profile photo
Thomas Mucha
67 followers
67 followers
About
Thomas's interests
Thomas's posts

Post has attachment
Query To Find SQL Audit Details
I've been deploying a SQL Server auditing solution for our new SQL 2014 estate. I know, we're a few years behind. But if you saw some of the legacy systems I work with you'd understand that migrating to SQL 2014 is quite a coup! Anyway, I found a really gre...

Post has attachment
Emergency Access to SQL Server
There are times when you need to gain access to SQL Server in an emergency. It doesn't happen very often, but it does happen. Actually, part of the problem is that it happens so rarely! We all get to grips with the various back-door commands required of us ...

Post has attachment
Restarting a service with PowerShell
We use Redgate's SQL Monitor to keep an eye on our mission critical servers. I like the product. It is reasonably user-friendly, reliable and it helps my team monitor our servers efficiently. I've used other products before and I think SQL Monitor compares...

Post has attachment
Databases With No Recent Backups
I've written the script below to easily identify databases that have not had backups taken within a certain amount of time. This could be useful if you need to build your own monitoring. However, even if you use a third party monitoring tool,as I do, it is ...

Post has attachment
Script to Alter File Growth
I recently inherited a large estate of SQL Servers. Over the years before I started it grew organically and was managed by an insufficient number of accidental DBAs. As a result many SQL server instances were built and left with their default settings. One ...

Post has attachment
Finding When A SQL Agent Job Ran
A quick post for today since I haven't added anything in quite a while. Recently, I was investigating a deadlock that was occurring, like clockwork, on a particular server. A trace revealed that it was being executed by the SQL Server Agent account. The hos...

Post has attachment
I love this series!

Post has attachment

Post has attachment

Post has attachment
Wait while more posts are being loaded