THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Louis Davidson

Utility Objects Series Introduction (but mostly a bit of an update)

So, I have been away from blogging about technical stuff for a  long time,  (I haven’t blogged at all since my resolutions blog, and even my Simple Talk “commentary” blog hasn’t had an entry since December!)  Most of this has been due to finishing up my database design book, which I will blog about at least one more time after it ships next month, but now it is time to get back to it certainly in a bit more regularly.

For SQL Rally, I have two sessions, a precon on Database Design, and another session on Sequence Objects and as I was building a demo with concurrent connections, I found myself again struggling with getting WAITFOR statements synchronized across multiple statements and I built a quick tool to make it easier to get multiple connections to start simultaneously. As I did this, I realized that I have a ton of utility objects that may (or may not) be interesting to the rest of the community. Other concepts I have in store are objects to grant rights, do DDL that SQL Server doesn’t implement (like dropping a schema with all objects, or dropping a column and constraints), metadata viewing etc.

So, I will present a series (maybe long, maybe short, who knows) of T-SQL utilities that I find useful, and perhaps you will too. If you have ideas for utilities you are interested in having built (or want me to share/link to,) let me know either as a comment or email me at


And hey, if you want a day filled with database design, be sure and register for SQL Rally and my precon in May in Dallas, TX…

Published Sunday, March 11, 2012 10:52 PM by drsql
Filed under: , , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Louis Davidson said:

Finally… took longer than I had expected when I wrote this a while back, but I had to move my website

March 20, 2012 10:32 PM

Leave a Comment


This Blog


Links to my other sites


Privacy Statement