DaveWentzel.com            All Things Data


Service Broker Demystified - [Initiators] and 'Targets'

Service Broker "initiators" adhere to the rules for object identifiers.  But "target" service objects are simple string literals.  This leads to goofy syntax and confusion.  This is really no big deal and in this post I'll cover in detail why it works this way.  

Entrepreneurial Programmers

The definition of 'entrepreneur' is misunderstood.  An entrepreneur is so much more than a businessman.  Entrepreneurial programmers are those technologists that exhibit similar traits.  The best programmers are entrepreneurial programmers (EPs).  You want these folks on your team.  And you want to be one of them.  In this post I'll describe what it means to be an EP.  Do you qualify?  

Recurring DST Anamolies

Daylight Saving Time is an obnoxious concept to deal with in the IT world.  At a minimum it means that early morning scheduled tasks need to be monitored twice per year to ensure they aren't skipped or run twice.  But if you have customers in other time zones DST can become a real nuisance that isn't easily handled using any current job scheduler.  

On Points

Software estimation "points" were never meant to be applied universally in scrum and agile.  They were meant to help dysfunctional teams meet "goals."  Points solve the wrong problems, and solve them in a way that fosters distrust with management and customers.  There are better alternatives.  

The #NoEstimates Movement is Nuts

Most software developers hate giving estimates.  Who doesn't?  But now there is a movement to ditch estimation entirely (#NoEstimates) based on a bunch of faulty logic.  They've gone too far.  Estimates serve a legitimate purpose.  Those behind this movement are an embarrasment to those of us who want to see our clients and employers succeed.  

Monitoring Service Broker


This is an update to my old post Service Broker Monitoring Routine.  The SB monitoring routine from that post was a little difficult to understand and tried to integrate setting up Service Broker with the monitoring of a Service Broker solution.  Bad idea.  This version of my monitoring routine is far easier to understand.  

Monitoring Disk Latencies with PerformanceCollector

PerformanceCollector (PC) is free and open-source software (FOSS) that I have developed to monitor and baseline performance of your SQL Server.  There are certainly plenty of commercial tools and even free scripts available on the net that handle all of this. What I like about PC is that it can be deployed with a simple PoSh call, runs without any dependencies, and is easily customizable to support any additional logging and reporting that you may need.  

On Resumes

I have debated for months whether I should actually publish this post.  

I've finally decided to do it.  



Subscribe to RSS - blogs