DaveWentzel.com            All Things Data

July 2012

Managing Developers...Part 10...Summary and Next Steps

"As a manager, I see now that I need improvement"
...so how do you affect change to be a better manager? Just listen. Go to your meetings but don't speak, just listen. If your team is apathetic then just wait, don't force dialog. Then, when they start speaking, don't just listen, "hear" what they are saying.


Managing Developers...Part 8...Dealing with a Productive Staff that Loves You

"But My Staff is Productive and Loves Me"

I've heard plenty of managers proclaim this publicly. It's then interesting to look around the room and see who is chuckling. It's very possible that your staff does love you and you have no issues. But you really need to scrutinize the situation to make sure that is actually the case.


Managing Developers...Part 7...Anarchist Tendencies

Some managers claim that their developers are just anarchists at heart and hate any form of management, bureaucracy, or governance. (See my Benevolent Dictator comments for immediate refutation.) "No one could manage these people." Managers who have failed at forcing scum/agile or kanban, or whatever, down their team's throat will claim that their developers will never accept any structure and process. This is wrong. You'll find that developers LOVE structure and order and process...what they hate is stupidity.


Find Cached Query Plans Containing the Given SQL Text

--find cached query plans containing the given text

Managing Developers...Part 6...Spotlight-er Issues

Have you ever thought that your people just want to be in the spotlight all of the time? Do you feel like your developers are always trying to steal credit for something from you or from others? I call these people "spotlighter-ers".  But the "spotlight-er" behavior is a symptom of a bigger issue. The cause is, again, your problem. Every developer I've ever met would much rather be allowed to make a good decision on their own, without being second-guessed or micro-managed, quietly, without taking any credit.


Useful SSMS Regular Expressions

^ is start of line marker

$ is end of line marker

\n Line Break (platform independent).  When used in the Replace expression it inserts a line break.  


I find SSMS regular expressions very useful.  Here's an example of what I do all of the time.  I run EXEC sp_help 'SomeTable' to get a list of columns.  I copy that list of columns into an INSERT statement.  When I copy the column list I get something that looks like this: 


Managing Developers...Part 5...Dealing with Cry Babies

This is Part 5 of my series on managing developers.  

Some managers complain that their developers are cry babies, constantly bitching about every little thing. Do you feel as though your people cry about the littlest issues? They are. Here's why.


Buffer Pool Health

How do you know if your SQL Server's buffer pool is "healthy"?  Generally, 3 performance counters are examined...Free Pages, Page Life Expectancy, and Lazy Writes/sec.  

Free Pages

Second System Syndrome

I don't know about you but I often find myself recreating the same systems over and over and over and over again.  I just finished another SQL script build/deploy project.  The first one I did over 15 years ago.  It was a simple batch file that looped through and executed any .sql scripts it found in its folder using isql.  It worked flawlessly.  It was simple and elegant.  It logged any SELECT and PRINT statements to a .log file using DOS redirection.  Anyone could support it.