There's more to it than just SQL Server
Friday, October 16, 2015 3:38:00 PM
There's far more occurring on your Windows servers than just SQL Server, and looking at ERRORLOG won't show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more. We'll start by looking at different ways to collect Event Logs. From there we'll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server. We'll finish it off with two immediately-usable implementations you can set up on Thursday morning.
Michael Bourgon is the Senior Production DBA for a large healthcare company. He's always looking for a better way to be a Lazy DBA - spending far too many hours automating processes in order to accomplish that. In Fort Worth we think of him as the Caspian Sea Monster of Eventing.
Thursday, October 8, 2015 9:27:00 PM
Well, it's a good thing we know about backups and restores.
Thanks for everybody that sent a heads up about the site.
I have about 6 or so different sites hosted on various servers and when I let the hosting service know I couldn't reach a couple of those servers, the ticket submission failed to post. Then the follow up email I sent even bounced.
I hate days like that.
So here's to all the hard working geeks that reversed that sorry state!
Thank you very much and I hope you get to sleep soon!