The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog



No Ads ever, except search!
Wednesday, July 17, 2024 Login

Blog posts for the month of February,2010.
The Bob Book Review2/18/2010 3:55:23 PM

Starting in December I purchased the following books.  Most of these were related to new projects where I work and knew I'd need to sharpen a few skills, Encryption, SQL Express, Merge Replication and security.

  • Beginning SQL Server 2008 Express for Developers: From Novice to Professional - Robin Dewson
  • Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5
  • Mobile Merge Replication - Rob Tiffany
  • SQL Server MVP Deep Dives
  • Expert SQL Server 2008 Encryption - Michael Coles, Rodney Landrum
  • SQL Server Forensic Analysis - Kevvie Fowler [bought but not reviewed]


Beginning SQL Server 2008 Express for Developers: From Novice to Professional - Robin Dewson

This book was a disappointment, but I knew when purchasing it that it was probably not going to be of much help; but I had to start somewhere.  We're preparing to migrate from MSDE to SQL Express 2K8 in 10,000 locations; I was involved in the intial deployment (and patchings) of MSDE and I really need to figure out how to avoid the gotchas with SQL Express; this book wasn't it.  Over-all it's a good book, but it's not meant for an existing SQL Server DBA, I would expect even a Jr. DBA to already be familiar with the content.  It truly is meant for an access developer who wants to learn SQL Express; I gave it to our local access programmer at work {though it's actually a she and she's not in IT or a programmer, seems that is where most access db's begin life}, maybe she'll develop a new career path, we seriously need more women in IT, I digress.

Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge

This book was great.  We're deploying Merge replication with up to possibly 10,000 differnt locations to SQL Express 2k5 and that is why I purchased this book.  While not an exact guide or road map for what we're doing [we're not using SQL Server compact edition], most of the concepts apply.  It has really been helpful, we're still in the planning and proof of concept stages, so it remains to be seen if we'll continue with this design at work, but I feel this book helped us greatly.

SQL Server MVP Deep Dives

This book was great.  I kind of avoided it at first, as I don't like books that too many people jump on as good, but this one lived up to that promise.  Very few parts of the book were lame ! [there's a glowing recommendation].  I put a sticky next to each new thing I learned and when I was done, i'd say there were at least 15-20 stickeys across the book, that's worth the money I paid for it.  It's also nice as you can read this book in quick "snippets" flipping to what subject interests you and what you have time to read.

Expert SQL Server 2008 Encryption - Michael Coles, Rodney Landrum

This book is good, though a bit dry, I'm still not all the way through it...reading about encryption is not what I'd consider an exciting topic, but it is a skill i'm going to need and it was seriously lacking.  We're preparing to bring in a 3rd party hardware device to provide consistent encryption and key management across the entire enterprise, which is why I needed this book.  So far it's been a great help, as I don't feel like a complete moron as I attend the endless meetings on implementing enterprise encryption where i work.

SQL Server Forensic Analysis - Kevvie Fowler

I haven't got to reading this one yet.  I'm looking forward to it, as security has become a major focus in ways I couldn't even imagine 2 years ago.  I thought the description of this book is interesting, as it approaches security from the aspect of determine what was compromised, from that I hope to learn better practices in security data....I'll update on that later.

Tightrope Terror is terrible !2/16/2010 7:36:46 AM


This has to be one of the worst ever toys for kids.  There are some positive reviews out there for this, and I'm convinced those are paid reviews or something.

This toy does not work, it requires heavy objects to weigh it down and it is near impossible to get the car to run on the rope.

A huge disappointment for the kid awaits with this toy.

I don't blog product reviews, but this one sucks so bad i had no choice.

I'd pay money for someone to show me this toy working...

Peak is over2/4/2010 3:12:30 PM

January and February are peak times for my company's business; now I can start to focus on new things, here is what I learned during peak and where 2010 will focus:

  • Capacity management is the 2nd most important thing dba's do.
  • Performance tuning and monitoring is the most important thing (during peak)
  • Locking and Blocking is the biggest scale issue i regularly see.
  • Mirroring on SQL Server standard edition sucks (especially for geographically disperse sites).
  • Mirroring on SQL Server enterprise edition rocks (though the cost factor is prohibitive).
  • Informatica is no better an ETL Tool than SSIS
  • Oracle and SQL Server are a pain in the ass to make work together (Oracle DBAs are'nt much help either)
  • 1 terrabyte of disk space is almost enough !
  • Re-indexing and defragging is analogous to politics and religion and DBA's should be barred from discussing the topic
  • Encryption is a pain in the ass.
  • Surprise - Merge replication actually works and is not near the PIA I thought
  • 6gb of RAM is never enough
  • Polyserve is not worth the effort
  • VM Ware with VMotion is awesome
  • VM Ware is a good alternative to Polyserve
  • Hyper-V is not there yet
  • SQL 2008 R2 licensing sucks
  • SQL 2000 is finally no longer meeting the business requirements and we may finally get funding to upgrade the remaining instances !

Blog Home