{"id":51,"date":"2013-12-30T23:27:10","date_gmt":"2013-12-30T23:27:10","guid":{"rendered":"http:\/\/www.tinymoe.com\/bigbookomaths\/?p=51"},"modified":"2014-03-31T18:49:53","modified_gmt":"2014-03-31T18:49:53","slug":"sql-query-of-the-day-301220131625","status":"publish","type":"post","link":"http:\/\/www.tinymoe.com\/bigbookomaths\/?p=51","title":{"rendered":"SQL Query of the Day #301220131625"},"content":{"rendered":"<p><span style=\"text-decoration: underline;\">Query<\/span>:<\/p>\n<pre>SELECT name FROM Deep13.sys.tables WHERE name like '%Forrester%'<\/pre>\n<p><span style=\"text-decoration: underline;\">Function<\/span>: Find all the tables in the database <em>Deep13<\/em> with the string <em>Forrester<\/em> in the name.<\/p>\n<p><span style=\"text-decoration: underline;\">Source<\/span>: Me. This is helpful if you&#8217;re looking around a database with hundreds\/thousands of tables for a clue about where relevant data might be.<\/p>\n<p><span style=\"text-decoration: underline;\">Comments<\/span>: I need a neologism for the phenomenon where you start entering your password at a blank Windows terminal, and by the time the screen emerges from hibernate mode, you realize you forgot to enter your login and have just been typing your password in the Windows &#8220;User name&#8221; field for everyone in the office to see. And then you realize you&#8217;re back in 8th-grade geometry class with no pants on &#8230;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Query: SELECT name FROM Deep13.sys.tables WHERE name like &#8216;%Forrester%&#8217; Function: Find all the tables in the database Deep13 with the string Forrester in the name. Source: Me. This is helpful if you&#8217;re looking around a database with hundreds\/thousands of tables &hellip; <a href=\"http:\/\/www.tinymoe.com\/bigbookomaths\/?p=51\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-51","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=\/wp\/v2\/posts\/51","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=51"}],"version-history":[{"count":1,"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions"}],"predecessor-version":[{"id":52,"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions\/52"}],"wp:attachment":[{"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.tinymoe.com\/bigbookomaths\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}