Alex has done some pioneering work on the testing of stored procedures over four years, and has learned a great deal in the process. In this article, he spells out the lessons learned from a wealth of experience in Unit Testing T-SQL.
Recently Dave Ballantyne posted a list of free resources for SQL Server, entitled " The best things in life are free ." Now, I'm not trying to upstage Dave, but I know of several resources that aren't on his list. It would be good to have a true community page for this kind of thing, but for now a blog post will have to do. [I also just re-noticed Mladen Prajdic's post on free SQL Server tools , and his list is quite exhaustive.]
Trust me, I'm a DBA “ Signs point to yes .” – Magic 8-Ball prophecy You have probably heard this line at one point, the one that says “the best DBAs are the ones you never see or hear?” I used to think that was a result of some sketchy personal hygiene choices and later on understood it to mean that if everything is running smoothly then there isn’t a need to see your DBA. It’s kinda like how you never see your plumber. Oh sure, you could call him (or her) and chat, have them over for drinks or dinner one night, but you never bother talking to them until your toilet backs up and there’s crap everywhere.
INFORMATION PROVIDED IN THIS DOCUMENT AND THE MDBSHELL UTILITY ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED. THE USER ASSUMES THE ENTIRE RISK OF RUNNING THIS SOFTWARE. Ó Terry Kreft (1998-2002), All Rights Reserved Download wzRef.Zip (size: 150,864 bytes ) Note: If you're distributing this wizard along with your MDE application as part of your runtime application and you experience any problems, try distributing the MDA file as an MDE.