{"id":102904,"date":"2024-07-02T07:23:51","date_gmt":"2024-07-02T07:23:51","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=102904"},"modified":"2024-07-02T13:29:02","modified_gmt":"2024-07-02T13:29:02","slug":"t-sql-tuesday-176-one-piece-of-advice-you-wish-past-you-had","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/t-sql-tuesday-176-one-piece-of-advice-you-wish-past-you-had\/","title":{"rendered":"T-SQL Tuesday #176: One piece of advice you wish Past You had"},"content":{"rendered":"<p>After so many years, here in July 2024, I am finally hosting T-SQL Tuesday.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-102905\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/07\/t-sql-tuesday-logo.jpeg\" alt=\"T-SQL Tuesday Logo\" width=\"162\" height=\"162\" srcset=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/07\/t-sql-tuesday-logo.jpeg 300w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/07\/t-sql-tuesday-logo-150x150.jpeg 150w\" sizes=\"auto, (max-width: 162px) 100vw, 162px\" \/><\/p>\n<h2>The challenge<\/h2>\n<p>One of the things I tend to do when I am working on a project is to think of myself over three time periods. The past, present and the future. The past version of me made lots of mistakes. Current Me is living through the mistakes Past Me made and does not want to repeat the same mistakes again and Future Me suffer.<\/p>\n<p>As data professionals we know that what we do is crazy hard at times, and if you remember back in August of last year, Josephine Bush\u2019s <a href=\"https:\/\/sqlkitty.com\/t-sql-tuesday-165-database-job-titles\/\">T-SQL Tuesday entry\u2019s<\/a> replies answered the question \u201cwhat do all the database job titles actually mean?\u201d There are more and more tasks and titles for what we do in the data field every year.<\/p>\n<p>Hopefully this month I will get some people who got their start using SQL Server 1.0 on O\/S 2, some in Data Science and even some who just started in tech pretty recently, maybe even starting with Microsoft Fabric. All replies are welcome because your mistakes are mostly non-unique.<\/p>\n<p>So, what I want to know is:<\/p>\n<p><strong>What advice do you wish Current You could <\/strong><a id=\"post-102904-_Int_2q2VYPB3\"><\/a><strong>go back and give past you as you were starting your first data platform job?<\/strong><\/p>\n<p>Note: even with this fantastical scenario, let\u2019s keep it realistic. No \u201cinvest in Microsoft, Apple, and Amazon\u201d replies, but using the years, and perhaps even decades of experience we gather have, let\u2019s hear it.<\/p>\n<p>Your advice might be technical, like compiling isn\u2019t testing, backups don\u2019t always work. But I bet a lot of you have experiences that led to some major issue that younger you didn\u2019t think of and failed in a way that your blog might help them avoid.<\/p>\n<h2>The rules<\/h2>\n<ul>\n<li>Publish your post on <strong>Tuesday 9th of July<\/strong>, no matter what time zone you are in it is fine.<\/li>\n<li>Include the T-SQL Tuesday logo at the top of your post and link it back to this invitation post.\n<ul>\n<li>It would also be awesome to comment on this post with your link if possible (if you can\u2019t leave a comment, <a href=\"mailto:\/\/drsql@hotmail.com\">email me<\/a>!)<\/li>\n<\/ul>\n<\/li>\n<li>If you\u2019re on social media, share your post using #tsql2sday.<\/li>\n<\/ul>\n<p>If you want to know more, check out the <a href=\"http:\/\/tsqltuesday.com\/rules\/\">T-SQL Tuesday Rules of Engagement<\/a>.<\/p>\n<h2>My example advice<\/h2>\n<p><em>Understand all the details of the problem before you release tables.<\/em><\/p>\n<p>Too many times in my early career, I thought I knew how to solve the problem just after reading the abstract of what the customer wanted. Silly customer, why did you spend all that time describing what you needed, I have built a customer table! I know what the customer is saying when they say address. And so on.<\/p>\n<p>Typically, assumptions were close, but in many ways that was a bigger problem than something that was very wrong because subtle issues often went unnoticed. In one of my first major systems I designed, only when the customer really started using the software in production did the issues really start showing up because what was thought to be a requirement very much wasn\u2019t quite what was expected, and trouble ensued.<\/p>\n<p>Note I specifically mentioned tables and not all code. Code changes easily, even database code. But structures are much harder to change, especially when the eyes of the customer are staring at you!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After so many years, here in July 2024, I am finally hosting T-SQL Tuesday. The challenge One of the things I tend to do when I am working on a project is to think of myself over three time periods. The past, present and the future. The past version of me made lots of mistakes&#8230;.&hellip;<\/p>\n","protected":false},"author":56085,"featured_media":102905,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,45105],"tags":[5150,147171],"coauthors":[19684],"class_list":["post-102904","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogs","category-career","tag-professional-development","tag-tsql-tuesday"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/102904","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=102904"}],"version-history":[{"count":4,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/102904\/revisions"}],"predecessor-version":[{"id":102909,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/102904\/revisions\/102909"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/102905"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=102904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=102904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=102904"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=102904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}