Dec 12 2011
The Apology Before I continue I owe everyone an apology. I’m sure I’ve been absolutely, positively annoying in my near-constant soliciting for votes for #DBAInSpace. I now am quite assured that I’ll never go into politics because I find it quite difficult to walk the fine line between distributing my message and micromanaging the voting [...]
Dec 9 2011
This week’s Friday Fun here on thesqlagentman.com is a classic wordseek of SQL-centric words, terms, phrases, and keywords. Take a break when you have a moment and enjoy! Let’s meet back here next week to have a bit more fun. Y I G E N O D E E V B N I S H [...]
Dec 8 2011
That line is all about context. Am I saying there is no such thing as a good DBA? I hope not. I’m referring to the fact that a successful DBA is invisible to those users that unknowingly rely on him or her daily – as mythical as the Chupacabra, free love, and universal phone charger [...]
Dec 6 2011
It certainly doesn’t take a rocket scientist to go to space… John Candy spent dog years in space in Spaceballs… Abbot and Costello went to Mars… Eddie Murphy hammed his way through Pluto Nash… (though even HE won’t admit that) Ben Affleck escaped gravity (and J-Lo) in Armageddon… Jane Fonda found Duran(d) Duran(d) in Barbarella… [...]
Dec 2 2011
We all deserve a break don’t we? That’s what I remember being told by Ronald McDonald back when I was growing up in the 1970′s. Who’s to say that we also can’t learn something new while stepping away from the data center craziness. A couple years ago I did a few rounds of (Not) Madlibs [...]
Apr 11 2011
To work with me that is. Spectrum Health is hiring a full time Oracle and SQL Server DBA (2 Disciplines – 1 FTE) and I’m tossing this request out to you here. The formal job posting can be found on the Spectrum Health website, but keep in mind the posting was written by a series [...]
Jul 15 2010
<Cliché> Life works in mysterious ways </Cliché> <Cliché> All things happen for a reason </Cliché> However you slice it the last week has been quite a wild one for me and my family. It all came to be in the series of two emails received less than four hours apart from one another. The first was an email [...]
Jun 1 2010
By default, new databases are created with the following basic file settings: Data File: 2 MB 1 MB unrestricted growth Log File 1Mb 10% unrestricted growth Just exactly why is this bad? It will assuredly increase the frequency at which files will grow automatically… A transaction log file, if configured for autogrowth, will expand when it [...]
