Tags: Books

Freedom

Categories: Book Reviews, News, SSC
Comments: No Comments
Published on: February 7, 2012

Not too long ago, I blogged about a Book called Daemon.  Freedom is the sequel to Daemon.

I enjoyed reading this book.  The story continues from Daemon, but in a largely different direction.  I like the direction the book took, for the most part.  I was hoping that there would be more tech talk and not so much of the sci-fi tek.  I liked the sci-fi tek, I just thought it would have been more down to earth to keep it closer to reality.

Daemon was scarily real.  The exploits were real, the danger seemed real.  In Freedom, I felt it made a big reach.  When looking at both books together though, it seems like a natural progression.

I like the plot.  The story culminates with a confrontation at a compound in Texas.  I really thought that the confrontation was a huge let-down.  I really expected more conflict at that point.  Everything was mounting to that, but the ultimate goal was to demonstrate that the group of people from the darknet still could think for themselves.

In the end, it was a good story.  I would like to have some of the technology.  I must also admit that Freedom was harder to put down than Daemon for me.  I found myself rooting in favor of the Daemon.  I started rooting for the Daemon at the end of the first book.

Daemon

Categories: Book Reviews, News, SSC
Comments: 1 Comment
Published on: January 4, 2012

At the recommendation of Jorge Segarra (Blog | Twitter),  I got the book Daemon.  Well, I actually got that about a year ago as a gift – but it was on my list of books to read because Jorge recommended it.

I have finally finished reading it and will be starting Freedom very shortly.  I am glad I bought Freedom prior to finishing Daemon since the ending leaves to many open story lines.  I really hate to finish a book on a cliff hanger and then have to wait for the next book.

While reading the book, you sit there and wonder if your servers are patched.  You also wonder if the network has been properly secured against intrusion.  But in the end, you accept that it doesn’t matter how secure the network is because the most successful way to hack a network is via social engineering.

Reading the book from an IT perspective, you understand that much of it is plausible.  You also find yourself slobbering over some of the tech that is described.  I really want some of those security systems, at least two AutoM8s, and an omnipresence stereo system (for lack of a better term).  A Razorback would be interesting to own too. ;)

I really enjoyed the book.  There was plenty of talk of databases, data security, and data breaches.  There was also a nice mix of espionage, treason, and mystery.  The plot seems to continue to twist and turn – which kept me involved.  At many points, you are also greeted with cold hard reality with some of the decisions that must be made and with regards to how politics work.

Go get this book and read it.  I’m off to read Freedom now.  I find myself expecting a myriad of possible conclusions while hoping for a better conclusion.

SQL Deep Dives 2 on the Kindle

Categories: News, Professional, SSC
Tags: ,
Comments: No Comments
Published on: November 23, 2011

Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted the book for travel purposes.  I decided I really needed to have it loaded on the kindle and quickly started running into a few roadblocks.

First roadblock was easy to overcome.  That required an email to Manning to get the beta link for the ebooks.  If you purchased through Manning, I’d recommend checking the beta site for any e-book purchases.

The second roadblock was determining which file to use on the kindle.  E-book formats are .mobi, .pdf and another that escapes me right now.  I didn’t see one for kindle.  In my journeys though I learned that mobi is essentially the same format as the azw format used by Amazon for the Kindle.  That is very good to know.

The next roadblock was how to get the file onto the kindle.  Getting it into my PC Kindle was pretty easy.  Find the \Documents\My Kindle Content folder in your user profile directory.  Then copy the mobi file to that directory.  But despite that, syncing did not put that book onto the rest of my kindle apps.  I soon found two ways of getting that done.

The first method for getting those mobi files onto the kindle was to plug my kindle into the usb port and copy the mobi file onto it.  Still, it didn’t sync to the rest of my devices.  Flip side is that it was pretty fast.

The second method for getting those mobi files onto the kindles is to email your kindle email account.  Amazon will eventually make those files available for you.  This will make it so you can sync all of your kindle devices with the same files.  The drawback is that it is considerably slower.

The same process can be done for any of those SQL books you have that you want to port around with you.  Now, the book is updated on several devices for me (laptop, phones, kindle) and I can reference it much faster than lugging the book around everywhere I go.

Try it and enjoy!

Throne of Fire

Categories: Book Reviews, News, SSC
Comments: No Comments
Published on: November 22, 2011

Finally, I have completed another book.  I took the opportunity while traveling to catch up on some reading.  Better yet, I was able to do this while testing out my Kindle.

The book I just finished is “Throne of Fire” by Rick Riordan.  This is the second book in the Kane Chronicles series and is very similar to the popular series about Percy Jackson (by the same author).

Sadly, some of my dislikes about the Percy Jackson books are present in this series as well.  I can get past some of that because the story is good (grammar and spelling mistakes throughout).

The two Kanes (Carter and Sadie) embark in this book to awaken the sleeping crazy Zeus.   The meet new friends and new challenges.  There are bumps and twists throughout the book.  And the one thing that kinda bugs me is that the climax is at the end of the book – creating a cliffhanger.  Now I am stuck waiting for the next book to be published – arghhh.

I liked the story.  I thought it was entertaining.  I would certainly let me children read the book.  It is a nice adventure and a good escape from the daily stresses.

Check it out sometime.

Beyonders

Categories: Book Reviews, News, SSC
Comments: No Comments
Published on: September 16, 2011

It has been a looooong time since I wrote a little book review.  It’s nice to take time out with a little fantasy to ease and please the brain.

Just because I haven’t written a review in a long time doesn’t mean that I stopped reading books.  I actually have a queue of books finished that could have a review written.  For now, I’ll just write a review on the latest book completed and probably never get around to the others – though they would be worthwhile.

Beyonders is the name of the book I recently completed.  This is a fantasy novel that is the first in a three book series.  For now, I am somewhat stuck waiting for book two.  Knowing that the book is part 1 of 3 can help you assume that this book ends in a cliff hanger.  That is somewhat frustrating – I was into the book and really wanted to reach the finale much sooner than the anticipated two years for the remaining tomes.

In Beyonders, two earth children get “warped” to an alternate dimension.  The are transported to a place that is void of heroes.  In this world, magic reigns supreme.  These two children must solve an enigma and become heroes in order to be able to return to earth.

These kids meet interesting people along the way, make several friends, and make even more enemies.  There is plenty of peril along the way.  The kids must solve the puzzle by gaining pieces to a word along their quest.  This word can defeat the wizard and restore peace to the world.  By the end of the first book, the kids have retrieved all the syllables to this word.  Shortly after completing the word the book ends and you must wait until the next book to continue the quest.

The plot had plenty of twists and turns to keep you interested.  It also portrayed these youth quite well as longing to return to their families and friends  Neither of them knew each other prior to being sucked into this new world.  Both show a lot of concern for the other as the book progresses and their friendship forms.

I would recommend reading this – especially if you have teenagers into these types of stories.

The Lost Hero – A review

Comments: No Comments
Published on: January 25, 2011

With what looks to be five books planned in a new series by Rick Riordan, people have some good fantasy ahead of them.

I just finished the first installment in this new series and must say that I am pleased with the story line.  New characters, new aspects of mythology and a third series revolving around those principles.  Rick Riordan has got a really hot topic and something working for him with all three of his series.

In this series we are introduced to the Roman versions of the mythological gods.  With the Roman aspects of these gods, we also get a new class of “evil god.”  Book one takes off from the final prophecy in the Percy Jackson series and brings three new demigods as the central focus.  I like the powers of these new demigods.  I also like the personalities of each.  Rick has done a great job of illustrating their characteristics without making them sound too much like heroes from prior books.

I did not like the grammatical problems constantly repeated throughout this book.  The same thing happened in the Percy Jackson series and got better with each book.  This is not an issue with the dialog but more to do with editing.  An example would be “Jason sat to next to the tree.”  Stuff like that is easily skipped by many people but sticks out like a sore thumb to me.

Overall, I highly recommend the book if you enjoy mythology and fantasy.

MockingJay – a review

Comments: No Comments
Published on: January 4, 2011

After a long wait, I have finally read the final installment in the “Hunger Games” trilogy.  I read the other two books earlier in the year in 2010 and then had to wait for the third book to come out.   Once the book came out (September 2010) I had to find some time to read the book.  Actually, I had to make time to read it.  Reading helps to de-stress and I just needed to do it.  you can read my reviews of the other books here and here (d’oh didn’t write one for the first book).

Up front – this was the third best book in the series.  I was mildly disappointed in this book.  The story was good but was just not as good as the first two.  It seemed to me that the author was trying to develop the story as the story unfolded.  The twists and turns in the plot were minor and mostly the plot was about the Mockingjay recovering from this or that.  It just wasn’t in true hunger games fashion.

It also seemed obvious to me that Plutarch (games master) was busy trying to orchestrate yet another Hunger Games.  That became painfully evident early on but was blaringly obvious when they are in the command center going over the map for Capitol City.  And if there was any doubt in the final chapters as to who did what in regards to a certain bombing event – you weren’t paying attention while reading.

I still liked the book and i still liked the series – I expected more and for it to be better.  If the book was to be another Hunger Games – then play that up a bit more.  It is the how the first two books were written and the description of the games that got people intrigued.

I would still say to go read the book and the entire series though.

Drumroll Please…

Comments: No Comments
Published on: November 29, 2010

Defensive Db Programming Chapter 10

After dragging this review on for months now, it is finally time to bring this bad boy home and wrap it up.  I have been working through a chapter by chapter review of the book by Alex Kuznetsov (Blog | Twitter).  Alex has been taking us through the process and various techniques to better program defensively.  This is the last installment in that series (yes shed a little tear).  This chapter is devoted to teaching us how to better deal with Modifications that Survive Concurrency.  Some of the problems associated with this are:

  • lost modifications, a.k.a. lost updates – such problems occur when modifications performed by one connection are overwritten by another; these typically occur silently; no errors are raised
  • resource contention errors – such as deadlocks and lock timeouts
  • primary key and unique constraint violations – such problems occur when different modifications attempt to insert one and the same row. (p. 337)

Another way of stating these types of problems is that there is a “Race Condition.”  You may have heard this term thrown around by the developers from time to time.  It isn’t made up and is a very real potential problem that must be dealt with accordingly.

I can’t give this chapter enough props nor enough due through a short blog post on it.  It is a lengthy chapter and covers a very important topic (my opinion).  Alex covers each of the race conditions and continues to show how to resolve that race condition.  He uses real world scenarios as you should have grown to see up to this point.  I will point out that I had not considered using RowVerssion to help resolve some race conditions.  That is at least one thing I have learned from reading this chapter.

Another thing that struck me and made me think is related to the TSQL patterns that Fail High concurrency.  Here two methods are scrutinized and a third method is proposed.  The third method is MERGE.  That is a subject about which I could learn a lot.

For the final time (since this series has come to a close), go get the book and read it.  You can find the rest of the articles by linking back through this link.

Defensive Db Programming Chapter 09

Comments: No Comments
Published on: November 22, 2010

It is down to the final two chapters of the book by Alex Kuznetsova.  Check out the previous chapter here.  The review of this book is certainly taking longer to produce than I had planned.  However, I think you find that the book is still worth it and that this little series is also worth it.  I hope that the spread of this series is at least getting to a few more people here and there and that more people may get a copy of “Defensive Database Programming”.

This chapter is about concurrent queries and Isolation Levels.  I think these seem to be a hot button of late – at least I have been hearing more and more talk about them than in the near past.  Alex starts the chapter with a stark realization.  He states:

Even the simplest SELECT, against one table, may retrieve incorrect results when the base table is being modified at the same time. (p. 297)

Think about that statement for a bit.  I imagine it won’t take you long to realize that it is true.  I am certain that you have come up with several examples that underscore that statement.

Alex then progresses through Isolation levels giving a demonstration of what will happen under the described circumstances.  This chapter is not intended to explain the differences between the Isolation levels, but merely to demonstrate what could happen – as has been the theme throughout the book to this juncture.  These examples that Alex uses first describe a theoretical problem and then he reproduces the theoretical problem with real world scenarios.

Alex also outlines in this chapter some considerations for choosing the correct Isolation level for your business needs.  Pros and Cons are weighed and usefulness of the Isolation level is discussed.  Alex also offers up the notion of using a query hint to issue a table lock when querying the database.  Due to the reciprocal effects Alex also states that it is almost never really an option.

Alex goes the extra mile in this chapter by discussing how we can minimize deadlocks.

In the end Alex makes a recommendation as to which Isolation level he would use.  Check it out and see for yourself.

Defensive Db Programming Chapter 08

Comments: 1 Comment
Published on: November 11, 2010

We are slowly getting to the end of this book by Alex Kuznetsov (Blog).  You can find more on this series by looking here.  We are now discussing chapter 8 and it is a good chapter.  This chapter delves into Error Handling.

While the use of TRY…CATCH certainly is the best way to handle errors in T-SQL, it is not without difficulties. (p. 259)

In this chapter, Alex discusses some of the problems associated with error handling and demonstrates how to resolve some of those problems.  We will also see how to use XACT_ABORT.

The first key to error handling is to prepare for unanticipated failure.  That is the crux of error handling.  We anticipate certain behaviors and code for that, anything else needs to be handled through error handling so we can see what has happened.  Code sometimes fails, and queries against the data can also fail on occasion – we need to plan for those failures.

When dealing with data modifications there are occasions when using explicit transactions is necessary due to the nature of the data modification – we would want to ensure that any and all changes to the data were rolled back.  There are other times when we would want to ensure that processing halts immediately when an error is encountered.  In such a scenario, XACT_ABORT comes in useful.  Note, however, that this setting is probably better set explicitly ON or OFF depending on the needs.

A recommendation in this chapter is to use client-side error handling for all but the simplest of error handling.  Error-handling is far more robust in other languages than it is in TSQL.  This is a recommendation that I support.  Error handling in TSQL has become better over time (i.e. with the addition of the TRY…CATCH) and is quite useful for some degrees of error handling.  One particular realm where error handling in TSQL is lacking is in the area of Code-Reuse.  The TRY…CATCH must be rewritten for each stored procedure for which you wish to enable error handling.

As always, this chapter covers some of the gotchas of error handling in TSQL and gives examples on how to implement as well as circumvent some of the problems.  Check it out!!

page 1 of 3»
Calendar
May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  
Follow me on Google+

In 0 people's circles

Add to circlesi
Content
Categories

Categories

Now Reading

Now Reading

Planned books:

Current books:

  • ChiRunning: A Revolutionary Approach to Effortless, Injury-Free Running

    ChiRunning: A Revolutionary Approach to Effortless, Injury-Free Running by Danny Dreyer, Katherine Dreyer

  • Advanced Marathoning – 2nd Edition

    Advanced Marathoning – 2nd Edition by Peter Pfitzinger, Scott Douglas

  • SQL Server MVP Deep Dives

    SQL Server MVP Deep Dives by Nielsen Paul, Delaney Kalen, Machanic Adam, Tripp Kimberly, Randal Paul, Low Greg

  • A World Without Heroes (Beyonders)

    A World Without Heroes (Beyonders) by Brandon Mull

Recent books:

View full Library

SQLHelp

SQLHelp


Welcome , today is Friday, May 18, 2012