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…
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…
70-450:Implementing RAID Solutions
Problem 1 Developers come to you with a new physical database server that hosts a single database. It’s going to be your responsibility now. Currently the server is running off a single hard drive, the operating system and database files are all on that one drive. You realize you have to provide some fault tolerance…
70-450: SQL and RAID 5/10
Continuing SQL and RAID, let’s pick up RAID 5 and RAID 1+0 (or just 10) This content is still for the first skill measured in the 70-450, per the official Microsoft page for the 450: Designing a SQL Server Instance and a Database Solution (14 percent) Design for CPU, memory, and storage capacity requirements. This…
70-450: SQL, RAID 0, RAID1
Let’s get ready for the 70-450. Hit the official Microsoft page for the 450, and you’ll see the first skills measured on the exam: 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: RAID, calculating table…