Dec 19 2011
On the Sixth day of Christmas my Server Admin gave to me… Six Gb of RAM Five Volumes Minimum… Four Words to Live By… Three Training Events… Two Twitter Handles… and Mirrored Disks with Parity RAM is Just Giving it Away on the Corner of Performance Boulevard and Buffer Lane No, RAM is not a [...]
Dec 17 2011
On the fifth day of Christmas my Server Administrator gave to me… Five Volumes Minimum Four Words to Live By… Three Training Events… Two Twitter Handles… and Mirrored Disks with Parity Five is a Magic Number When initially configuring a SQL Server be sure to fight the basic drive of your server administrators to [...]
Dec 16 2011
On the fourth day of Christmas I gave a gift to you… Four Words to Live By Three Training Events… Two Twitter Handles… and Mirrored Disks with Parity Stop As in “Know when to Stop.” This bit of advice applies to many things. Knowing when to call it a day, turn of the lights, [...]
Dec 15 2011
On the third day of Christmas my Manager gave to me… Three Training Events Two Twitter Handles… and Mirrored Disks with Parity I Can’t Get No Satisfaction I am never satisfied with the amount of knowledge I possess. Most of us are like that in our profession because if we stand still we are [...]
Dec 14 2011
On the second day of Christmas I gave a gift to me… Two Twitter Handles and Mirrored Disks with Parity. Two Twitter Handles… why? A Base Twitter Primer Twitter, in and of itself is a great tool for communicating with one, or many “followers” in 140 characters. At the core it really is nothing more [...]
Dec 13 2011
On the first day of Christmas my SAN Admin gave to me striped disks with parity… Yes, this is known as RAID 5 and is ideal and preferred for user database data files in Microsoft SQL Server. Why? Satisfactory performance – disks are striped Good redundancy – parity is distributed Lowest-cost RAID option for performance [...]
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 [...]
Nov 7 2011
We all knew the dream had to come to an end at some point. Effective with licensing changes for SQL Server 2012 is the end of licensing based upon CPU sockets as an option for SQL Server. Since I’ve only ever had to deal with processor licensing (low CAL diet for me, thanks) I’m focused [...]
