Mastodon

SQL Server Express Maintenance

Don’t you love looking at your old scripts? I’ve rewritten all of our maintenance jobs, including the jobs in task manager that handle SBSMonitoring.  I’ve rid myself of Windows Internal Database, but was still using the script I wrote for it.  Not...

Backups FTW!

I could say it’s because I’m a DBA and SysAdmin and it’s an occupational hazard, and frequently do.  I could also say it’s because I’m neurotic.  😉  But it’s probably the most honest to say, “Because I once experienced a...

The Career Venn Diagram

Every now and then, people ask me for career advice.  Or, you know.  They start complaining about their careers and I annoy them with unsolicited advice.  😉  Either way, my advice for choosing a career comes down to: Things you can do that people will pay you to do...

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...

Broad Universe Rapid Fire Reading

I’ll be reading with Broad Universe at WorldCon, Sunday at 10am in 007B (Convention Center).  I plan to read from “Ondine’s Curse,” which will appear in an upcoming issue of Electric Velocipede.  Come by and say...

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...

Pin It on Pinterest