{"id":82120,"date":"2012-03-11T22:52:03","date_gmt":"2012-03-11T22:52:03","guid":{"rendered":"https:\/\/www.webstaging.red-gate.com\/simple-talk\/?p=73409"},"modified":"2018-12-12T13:20:08","modified_gmt":"2018-12-12T13:20:08","slug":"utility-objects-series-introduction-but-mostly-a-bit-of-an-update","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/utility-objects-series-introduction-but-mostly-a-bit-of-an-update\/","title":{"rendered":"Utility Objects Series Introduction (but mostly a bit of an update)"},"content":{"rendered":"<p>So, I have been away from blogging about technical stuff for a&#160; long time,&#160; (I haven\u2019t blogged at all since my <a href=\"https:\/\/www.webstaging.red-gate.com\/simple-talk\/uncategorized\/2012-blog-resolutions\/\" target=\"_blank\">resolutions blog<\/a>, and even my Simple Talk \u201ccommentary\u201d blog hasn\u2019t had an entry since December!)&#160; Most of this has been due to finishing up <a href=\"http:\/\/www.apress.com\/9781430236955\" target=\"_blank\">my database design book<\/a>, 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.<\/p>\n<p>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\u2019t implement (like dropping a schema with all objects, or dropping a column and constraints), metadata viewing etc.<\/p>\n<p>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 <a href=\"http:\/\/mailto:louis@drsql.org\">louis@drsql.org<\/a>. <\/p>\n<p><a href=\"https:\/\/www.webstaging.red-gate.com\/simple-talk\/wp-content\/uploads\/2017\/12\/42241_SQLRally_Speaking_37B0BEA4.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px;border-left: 0px;padding-left: 0px;padding-right: 0px;float: right;border-top: 0px;border-right: 0px;padding-top: 0px\" title=\"SQLRally_Speaking\" border=\"0\" alt=\"SQLRally_Speaking\" align=\"right\" src=\"https:\/\/www.webstaging.red-gate.com\/simple-talk\/wp-content\/uploads\/2017\/12\/42241_SQLRally_Speaking_thumb_56F36577.jpg\" width=\"172\" height=\"172\" \/><\/a>&#160;<\/p>\n<p align=\"left\">And hey, if you want a day filled with database design, be sure and <a href=\"http:\/\/www.sqlpass.org\/sqlrally\/2012\/dallas\/Register.aspx\" target=\"_blank\">register<\/a> for <a href=\"http:\/\/www.sqlpass.org\/sqlrally\/2012\/dallas\/\" target=\"_blank\">SQL Rally<\/a> and my precon in May in Dallas, TX\u2026 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, I have been away from blogging about technical stuff for a&#160; long time,&#160; (I haven\u2019t blogged at all since my resolutions blog, and even my Simple Talk \u201ccommentary\u201d blog hasn\u2019t had an entry since December!)&#160; Most of this has been due to finishing up my database design book, which I will blog about at&#8230;&hellip;<\/p>\n","protected":false},"author":56085,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[19684],"class_list":["post-82120","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/56085"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=82120"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82120\/revisions"}],"predecessor-version":[{"id":82320,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82120\/revisions\/82320"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=82120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=82120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=82120"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=82120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}