Fun with PXE, redux.
You may recall that I’m serving up not only Windows Deployment Services capture and deploy but also Acronis recovery media over PXE. Well, now I’m also serving up Windows Defender Offline. When chosen from the PXE boot menu, it boots into Windows PE,...They’re using HOW MUCH space?
This assumes a convention where databases are named after the responsible party with an underscore and a version number or description. It also assumes that running this script is faster than remoting to the server and looking at the directory. 😉 declare @dbname...SFTP – copy smallest files first
I needed to SFTP a bunch of files ranging in size from 40 meg to 130 gig. The default behavior of “mput *” is to copy the files in alphabetical order, but what happens then is that all the smaller files pile up behind the large ones. This is bad because...Fun with PXE
At one of my previous positions, I was in charge of the PXE server. I like PXE, so I set up a PXE server here, too. It was a lot easier at my current place of employment, because I had access to the routers and the DHCP server. It ended up being a straightforward...Nagios Event Handlers on Windows
Nagios event handlers are WHERE IT’S AT, BABY, YEAH! There are some services that I can just automagically restart without any problems. (WSUS, SQL Agent, etc.) This way, instead of notifying me, Nagios can just fix the problem for me and We Need Never Know....A script for migrating to a new server
I stripped out a piece of company-specific logic, but… List the databases you want to move in a file named “control.txt.” (To migrate the entire server, paste the output of “select name from sys.databases where name not in...Nagios Twitter Notifications – working again!
Yeah. Twitter changed their authentication, and my old Twitter notifications (based on Ed Voncken’s work) seized up and failed. I had to update the python tweepy library to get them to work. pip install tweepy –upgrade And they’re back! I love...Fun with VLFs
Virtual Log Files. Your database’s log file is made up of one or more virtual log files. Our databases have too many. Basically, our LDFs are fragmented. What to do about this? Well, Dave Levy has a script to reduce the number of VLFs, but it’s to run...Jabber Nagios Notifications – Working Again!
I like using non-email notifications, especially when monitoring, you know, email. So I have notifications going out via twitter and google talk. Of the three, the order of speediness is: Google Talk Twitter Email So I was really sad when the google talk...Subscribe
