The SQL Server Administrator's Console

infomation & knowledge sharing for building, monitoring and maintaining excellent data solutions

Console     SQLClue     DBA Scripts     Feedback      
Hello and Welcome!  

Free T-SQL Code Reviews!

 

I would like to offer you a technical review of the T-SQL of your choice! Absolutely no cost or obligation. If you've got some DML you have wanted to put before a second set of eyes, now is your chance. If you've never experienced a code review or at least a code review that was actually helpful you owe it to yourself to take me up on this offer. 

 

It has been almost 20 years since the first time I had to figure out how to remove duplicates rows from a table. It was a few years later before I became convinced that database developers and DBAs should sit together and read the code regularly. I have found a code review practice to be always difficult to get started yet every time I have done it people embrace it and the quality of the code increases. 

 

The effects of good code reviews are amazing!

 

  • More considerations come to the table when the team invests a few moments of critical thought to prepare for a code review. As with any collaboration, the whole is better than the sum of the parts. 

 

  • Better early understanding of requirements because as the individuals become habituated to the notion that they may need to explain why they have done what they have done.  

 

  • Reduced number of development iterations to achieve sam result. Code review happen while information details are all still fresh and available for recall. Questions can be considered and necessary changes made before even before unit tested  code is handed off for interation testing of something that won't work with the existing system or acceptance testing something that is unacceptable or carelessly slamdunking bugs into a live environment. The result is less rediscovery, rework and debugging time spent on changes after changes go live.

 

This is a serious offer. If you are serious about taking me up on the free code review contact me and we will get started. It's just an idea, I have not really checked with any of them, but you could always check with any of my excellent former colleagues and managers out there on LinkedIn to get the best kind of feedback about me and my insistence on those consarned code reviews. We may as well get some benefit from the energy we've invested in becoming LinkedIn.

 

What can you get out of this? Better T-SQL. Maybe even more sleep if things are really bad in your shop. And, if you do it right, a success story to bring to your next review.  

 

What do I get out of this? I  am an independant SQL Server Consultant. I need more work. This is a way for me to connect with people that care about the quality of their database code. After a code review or two it will be clear that I can help you improve the quality of your database application(s). From there I am hopeful to receive consideration for projects or piece work. I can help with Service Broker and CLR objects, reports, SSIS packages, or even as the back-up DBA when you you go on vacation or leave.

  

~

 

If the real world is just too troubled and bizarre or you find some solice in pseudo-gheeky essays with bad grammar and convoluted trains of thought, or if you are interested in SQL Server on some less passionate plane I invite you read my weblog (RSS).

 

This page was last modified on Monday, February 07, 2011 01:21:59 PM