I recently had a epic failure on my workstation. It was bad. My machine simply stopped working, and when I rebooted everything looked fine, until I saw it blue screen during boot. So here I go with lessons learned during a critical failure. RAID 1 is great …so long as your controller can still function…
Month: November 2011
Who Shrank Roger Rabbit
It all started Thursday afternoon, about 1500. I was walking back from Starbucks with my afternoon pick-me-up, when a co-worker mentioned we have this process or person who shrinks the log file, apparently every week. “Is there some way I can find out who, or what is shrinking the log files?” And with that, I…
88-970: My Study Guide
Since I know I’m going to go for the SQL MCM next year, I’m going to start collecting all of my study materials here, on my blog. Hopefully that way it can jump start your own study process towards that goal. I’ll mark all the entries with the tag 88-970, since I don’t really know…
70-450: Complete!
After another month of studying, I finally took the 70-450. I’m happy to say I passed! I did learn one thing from the exam: I should spend more time with encryption techniques and what all you can accomplish through encryption. Unfortunately, I’ve never had the business excuse to practice with encryption. I am interested in…
70-450: IO Throughput
Today I’m getting back to studying for the 70-450. To follow up the last few articles I’m still in the first bullet point from the official guide. Designing a SQL Server Instance and a Database Solution (14 percent) Design for CPU, memory, and storage capacity requirements. This objective may include but is not limited to:…
70-450: Calculating Table Size
In my previous three posts I covered different RAID solutions, and when I use each type of RAID. That’s just the first part of the first section of the 70-450. Designing a SQL Server Instance and a Database Solution (14 percent) Design for CPU, memory, and storage capacity requirements. This objective may include but is…
SQL Saturday #87 – Louisville, KY Recap
Starting Wednesday of last week I was able to attend the local SQL Server User Group and then that Saturday I attended SQL Saturday #87 in Louisville, KY! There was a ton of learning going on! At the Charlotte User Group meeting, Brian Knight showed us some of the management improvements that have been made…