DaveWentzel.com            All Things Data

September 2012

More Thoughts on NoSQL

I've been getting annoyed lately with everyone jumping on the NoSQL bandwagon when clearly they don't understand the strengths of NoSQL and what it can offer.  It seems instead that anyone who doesn't want to deal with persisting data to a database would rather just use a NoSQL solution.  Um, that isn't what it's for and it probably won't work if that is what you think.  

system_health Session

It's been a few years since I've experimented with and written about Extended Events.  

Enabled by default, the system_health session collects the following information:  


Treating the Cause and Not the Symptom

I always preach that we should treat the "cause" and not the "symptom" when a problem is presented.  ie, find root cause.  People like this analogy.  I heard an even better analogy today...

Don't cure a fever by pushing down the mercury in the thermometer.  

Moore's Law, "Sloppy Chips", and Revolutionary Changes

For as long as I can remember I've been hearing that Moore's Law (roughly, computing power doubles every 18 months) was soon to fail.  "We just can't possibly cram more processing power into microchips.  Physically, it's just not possible to do."  I've always thought that is bunk.  Where there's a will, there's a way.  But even Gordon Moore said in 2005 that the law would be violated as we approached miniaturation at the atomic level.  I'll say again, Bunk!

A Gotcha For SQL Server Filtered Indexes

Most people know that filtered indexes require very explicit ANSI settings to operate.  This is no different than using XML in SQL Server or indexed views.  I'm sure MS did this in an effort to force people to stop using what really should be deprecated features (such as QUOTED_IDENTIFIER OFF and non-default ANSI NULL behavior).  By removing these options I'm sure it also simplifies MS's testing of code paths as well.  I have no issue with MS's decisions here.

Performance Engineer-in-a-Box

Years ago I wrote a little utility called DBA-in-a-Box.  If you needed to administer a large and growing installation of SQL Servers you needed a quick way to make sure that every new server had a scheduled backup job, reindexing job, and DBCC CHECKDB job.  In one quick script you could deploy all of these things.