{"id":2566,"date":"2014-09-16T13:00:54","date_gmt":"2014-09-16T17:00:54","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=2566"},"modified":"2014-11-13T12:04:50","modified_gmt":"2014-11-13T17:04:50","slug":"tsql2sday-58-roundup","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/","title":{"rendered":"T-SQL Tuesday #58 – Round-Up"},"content":{"rendered":"
\n

Thanks to everyone who participated in T-SQL Tuesday #58<\/a>.
\nHere is the list of participating posts.<\/p>\n

\n

\"T-SQL<\/a><\/p>\n<\/div>\n

T-SQL Tuesday #58 Posts<\/h3>\n

This list contains all the posts I was able to find and they are listed in no particular order. Please let me know, if I missed any.<\/p>\n

There are also rumors of a few stragglers still being written. While the official rules don't allow for this, if you follow all rules, but got the week (not the month) wrong, I might still be able to add your post to this list.<\/p>\n

Passwords<\/a><\/h5>\n

Rob Farley (B<\/a>|T<\/a>) was the first to post. Rob reminds us that passwords are really a \"secret\" and that we should be careful, with whom we share that information. As professionals, we should also try find ways to not require clients to share their secret passwords with us.<\/p>\n

T-SQL Tuesday #58 Passwords Require Communication<\/a><\/h5>\n

Boris Hristov (B<\/a>|T<\/a>) encourages us to communicate across teams. While that is important in many areas of software development or IT in general, missing communication around password changes can be disastrous.<\/p>\n

Bad habits : Giving out the sa password<\/a><\/h5>\n

Aaron Bertrand (B<\/a>|T<\/a>) adds to his long list of Bad Habits<\/a> posts. In this edition, he reminds us that using the SA account is a (very) bad practice. Particularly, as it requires publishing the SA password which in turn makes it close to impossible to change it. (If you need to change it after all, refer to Boris' post.)<\/p>\n

TSQL Tue #58: Passwords and Registered Servers<\/a><\/h5>\n

Russ Thomas (B<\/a>|T<\/a>) investigates how passwords for registered servers in SSMS are stored. He concludes that the current encryption methodology of this information seems a lot stronger than in older versions of this software. However, the algorithm is still not published, and therefore the security cannot be confirmed.<\/p>\n

T-SQL Tuesday #58 \u2013 Passwords<\/a><\/h5>\n

Andy Levy (B<\/a>|T<\/a>) recommends 1Password (which is also my favorite password management program). Andy also reminds us that security is like an onion and you need many layers. In the context of passwords that includes using two factor authentication<\/a> wherever possible.<\/p>\n

#Tsql2sday - Passwords<\/a><\/h5>\n

Wendy Pastrick (B<\/a>|T<\/a>) gives us a mnemonic device to generate and remember complex passwords. You will always have a few accounts that you cannot manage with the passwords manager, like the password for the password manager itself. For these few cases use Wendy's method.<\/p>\n

T-SQL Tuesday #58 \u2013 Security Phrases<\/a><\/h5>\n

Jason Brimhall (B<\/a>|T<\/a>) takes on a similar topic as Boris. He reminds us that you do not only have to communicate when changing passwords, you also have to document the new password (preferably not on a sticky note). Otherwise, you might end up in serious trouble down the road. In Jason's case, the lack of documentation caused the SQL Server service account to be locked out. That is a really rather bad situation to find yourself in.<\/p>\n

T-SQL Tuesday - Passwords<\/a><\/h5>\n

David S (B<\/a>|G<\/a>) reminds us that really only the password length matters. A complex but short password is a lot easier to crack than a simple but long password, at least as long as you do not use something easy to guess.<\/p>\n

T-SQL Tuesday #58: Passwords<\/a><\/h5>\n

Kenneth Fisher (B<\/a>|T<\/a>) explains how password hashing works. He concludes that \"123456\" is a bad password. You will need to read his article to figure out how these two messages are related.<\/p>\n

T-SQL Tuesday #58\u2013Passwords<\/a><\/h5>\n

Steve Jones (B<\/a>|T<\/a>) introduces Password Safe and tells us the story of how Password Safe together with a well-crafted script enabled him to manage the required regular password changes in a large-scale organization.<\/p>\n

Five Ways to Manage your SQL Server Passwords [T-SQL Tuesday #58 - Passwords]<\/a><\/h5>\n

Finally, in my (B<\/a>|T<\/a>) own post for this T-SQL Tuesday, I compare five different options to manage the administrative passwords in your SQL Server environment.<\/p>\n

Summary<\/h3>\n

What a party - Thanks to everyone who showed up. See you next time.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Last week was the 58th #tsql2sday party and 11 people showed up. There were exciting discussions about password strength, password management, hashing and more. Read on to see what everyone contributed.<\/p>\n

[more…]<\/a><\/p>\n","protected":false},"author":3,"featured_media":2560,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[5,203,34,13],"tags":[153,233,15,270],"class_list":["post-2566","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","category-passwords","category-security","category-t-sql-tuesday","tag-password","tag-password-management","tag-sql-server","tag-t-sql-tuesday"],"acf":[],"yoast_head":"\nT-SQL Tuesday #58 - Round-Up - sqlity.net<\/title>\n<meta name=\"description\" content=\"Last week was the 58th #tsql2sday party and 11 people showed up. Read on to see what everyone contributed to the password discussion.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T-SQL Tuesday #58 - Round-Up - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"Last week was the 58th #tsql2sday party and 11 people showed up. Read on to see what everyone contributed to the password discussion.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-16T17:00:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T17:04:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/09\/tsql2sday.png\" \/>\n\t<meta property=\"og:image:width\" content=\"129\" \/>\n\t<meta property=\"og:image:height\" content=\"130\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"T-SQL Tuesday #58 – Round-Up\",\"datePublished\":\"2014-09-16T17:00:54+00:00\",\"dateModified\":\"2014-11-13T17:04:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/\"},\"wordCount\":650,\"commentCount\":3,\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/09\\\/tsql2sday.png\",\"keywords\":[\"password\",\"password management\",\"SQL Server\",\"T-SQL Tuesday\"],\"articleSection\":[\"General\",\"Passwords\",\"Security\",\"T-SQL Tuesday\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/\",\"name\":\"T-SQL Tuesday #58 - Round-Up - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/09\\\/tsql2sday.png\",\"datePublished\":\"2014-09-16T17:00:54+00:00\",\"dateModified\":\"2014-11-13T17:04:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"Last week was the 58th #tsql2sday party and 11 people showed up. Read on to see what everyone contributed to the password discussion.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/09\\\/tsql2sday.png\",\"contentUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/09\\\/tsql2sday.png\",\"width\":129,\"height\":130,\"caption\":\"T-SQL Tuesday 58: Passwords - #tsql2sday\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2566\\\/tsql2sday-58-roundup\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T-SQL Tuesday #58 – Round-Up\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T-SQL Tuesday #58 - Round-Up - sqlity.net","description":"Last week was the 58th #tsql2sday party and 11 people showed up. Read on to see what everyone contributed to the password discussion.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/","og_locale":"en_US","og_type":"article","og_title":"T-SQL Tuesday #58 - Round-Up - sqlity.net","og_description":"Last week was the 58th #tsql2sday party and 11 people showed up. Read on to see what everyone contributed to the password discussion.","og_url":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2014-09-16T17:00:54+00:00","article_modified_time":"2014-11-13T17:04:50+00:00","og_image":[{"width":129,"height":130,"url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/09\/tsql2sday.png","type":"image\/png"}],"author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"T-SQL Tuesday #58 – Round-Up","datePublished":"2014-09-16T17:00:54+00:00","dateModified":"2014-11-13T17:04:50+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/"},"wordCount":650,"commentCount":3,"image":{"@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/09\/tsql2sday.png","keywords":["password","password management","SQL Server","T-SQL Tuesday"],"articleSection":["General","Passwords","Security","T-SQL Tuesday"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/","url":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/","name":"T-SQL Tuesday #58 - Round-Up - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/#primaryimage"},"image":{"@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/09\/tsql2sday.png","datePublished":"2014-09-16T17:00:54+00:00","dateModified":"2014-11-13T17:04:50+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"Last week was the 58th #tsql2sday party and 11 people showed up. Read on to see what everyone contributed to the password discussion.","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/#primaryimage","url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/09\/tsql2sday.png","contentUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/09\/tsql2sday.png","width":129,"height":130,"caption":"T-SQL Tuesday 58: Passwords - #tsql2sday"},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/2566\/tsql2sday-58-roundup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"T-SQL Tuesday #58 – Round-Up"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/09\/tsql2sday.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-Fo","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=2566"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2566\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media\/2560"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=2566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=2566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=2566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}