Squee!!!
As of yesterday, I’m a Microsoft MVP in Enterprise Security. 😀Rename a lot of databases with PowerShell
I was given the task of renaming a bunch of databases named something like “name,” “name_1,” “name_2,” etc., to “nameold,” “nameold_1,” “nameold_2,” etc. Our convention is for the database name...Art is never finished, only abandoned.
I expect that I’m about to frustrate a lot of people, but that’s the way it is. Back in 2007, I started a “Hurricane Katrina” story. I wandered around in my post-apocalyptic Probably New Orleans, got lost, deleted 5,000 words, rewrote it a...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,...New story available! and bonus snippets.
Thing the first: My story “Ondine’s Curse” is available in the latest (last, alas) issue of Electric Velocipede. Thing the second: I have two more flash pieces in circulation and forgot to post snippets! “Lady of the House”: Aiele’s...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...Subscribe
