{"id":938,"date":"2014-03-11T19:47:50","date_gmt":"2014-03-12T01:47:50","guid":{"rendered":"https:\/\/clarkcreations.net\/blog\/?p=938"},"modified":"2014-03-12T13:36:27","modified_gmt":"2014-03-12T19:36:27","slug":"tsql-tuesday-052","status":"publish","type":"post","link":"https:\/\/clarkcreations.net\/blog\/tsql-tuesday-052\/","title":{"rendered":"TSQL Tuesday #052 &#8211; Argue Against A Popular Opinion"},"content":{"rendered":"<h2>Don\u2019t Be that Guy<\/h2>\n<h3>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 or 10 things I hate about you<\/h3>\n<p><a href=\"http:\/\/michaeljswart.com\/2014\/03\/argue_against_a_popular_opinion\/\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" alt=\"TSQL2sDay150x150\" src=\"http:\/\/farm6.staticflickr.com\/5112\/7159832136_b5d25d8a17_o.jpg\" width=\"150\" height=\"150\" \/><\/a><\/p>\n<p>It always comes to me as a surprise that it is TSQL Tuesday again. I guess time just slips by so quickly these days.\u00a0 This awesome month of March is brought to us by Michael Stewart [\u00a0 <a href=\"http:\/\/michaeljswart.com\/\" target=\"_blank\">BLOG<\/a>\u00a0\u00a0 |\u00a0\u00a0 <a href=\"https:\/\/twitter.com\/MJSwart\" target=\"_blank\">TWITTER<\/a>\u00a0 ]. March is awesome by the way because it contains my birthday. If you haven\u2019t heard about or figured out what this Tuesday stuff is all about drop me a line and I will not only sell you on the concept I will convince you to write your first post for next month.<\/p>\n<p>So at first I thought I would write up how my first database exercise outside of class was to create a fancy mail merge application in Access. It was a long manual process that took and entire week to complete, then I came along and said WHOA! We can make this really fast in a database. Cut processing down to just\u00a0few short hours. But then I felt sad as Access is so old and the new hotness of Sharepoint and SSRS really will make it obsolete. Then I got to thinking\u2026. I said to myself you know what is popular and makes me mad? THAT GUY! AND HER! But they are so popular and so powerful that the point is probably mute. But since it\/they are popular I have decided to argue against it!<\/p>\n<p>1. Always saying \u201cWell I worked at XYZ.\u201d<\/p>\n<p>Ok, you know who this person is, you have worked with them or talked to them at some point in time. For me it was a woman I worked with in a past position. She\u2019d always say \u201cWell I used to work at Microsoft.\u201d\u00a0 We finally started in saying to each other things like \u201cI used to work at Pizza Hut.\u201d and \u201cWell I used to work at Kmart.\u201d The point is that using that as your crutch and reasoning as to why we should listen to you isn\u2019t really working. And here are the common causes as to why we don\u2019t care; 1) you haven\u2019t worked there in so long it doesn\u2019t matter, 2) you couldn\u2019t get a job there now if you wanted, 3) It really just makes you sound like an ass, and 4) We know people who do work there and they are nice, and much to your surprise they would offer to help me because #sqlfamily wins!<\/p>\n<p>&nbsp;<\/p>\n<p>2. Setting rules and standards but not being alive enough to know when to say you\/it was wrong.<\/p>\n<p>So this one comes from some pent up energy in a past position, but as I have talked about it with others and looked back over my life I realize it happens everywhere. But it might be more commonly known as \u201cNO CHANGE HAPPENIGN HERE!\u201d\u00a0 There was a rule that said if the the query plan said you needed an index you had to build said index to have your release approved. Now it seems like a good idea to get silly old developers and the BI gang to stop and look at the query plan once in a while but this particular rule was an issue. I once had to build an index on a table that already had 32 indexes built on it and guess what it was a heap. But NO ONE would admit that this rule was dumb\/counterproductive and let it stand. There was also the requirement to use WITH(NOLOCK) on everything, but I set my isolation level. That one did finally get over turned but as far as I know that index rule lives on.<\/p>\n<p>3. Starting every answer with NO.<\/p>\n<p>Really? I mean I know you think your cool image of being a hard ass makes you well respected but honestly it makes me feel sad for you. Stop and listen to what people have to say, they will respect you and they will feel like you took a minute to care. Doesn\u2019t mean the answer has to change it is just the delivery.<\/p>\n<p>4. You are not a celebrity, the paparazzi doesn\u2019t follow you and TMZ doesn\u2019t even know who you are.<\/p>\n<p>Shania Twain sings \u201cThat don\u2019t impress me much\u201d and you know what she is right. I mean there are some pretty popular people in the community but it would be of my opinion that if you are one of them then you need to hold yourself to a higher standard. That\u2019s right you need to set a good example. You need to encourage the next generation of leaders and help them find their way.\u00a0 No poking the rhino, causing trouble or acting like you are too good for the common folk because as I recall it you too were one of those common folk.<\/p>\n<p>5. Being a BULLY!<\/p>\n<p>No those days are over! There is no reason on this earth for people to treat each other so poorly. You know I finally found a home, a community where I fit in and people understood me but then I found its dark side \u2013 the bullies. Knock that shit off! Be kind to one another and stop using scare tactics and intimidation to get your way. To be honest folks we need to hold each other accountable on this one. Really, next time you see a bully try calling them out.<\/p>\n<p>6. One trick ponies or single solutions.<\/p>\n<p>I have worked with far too many people that can quickly solve and application problem but their solution leaves out any consideration for Business Intelligence. Back when I started we just called it Reporting, but it was always forgotten or an afterthought. Now so many companies have to pay big money to get simple data put together to help them run their business. One of my favorite answers is XML, it makes for fast writes into the database. Yeah so what it is a bitch to get that data back out and slower than it should be. Design a BI solution at the same time or meet in the middle, simple as that.<\/p>\n<p>&nbsp;<\/p>\n<p>7. Stop treating women differently.<\/p>\n<p>I am so tired of hearing this and I am so tired of having to say this. Really, why can\u2019t we all just get along? I can\u2019t even count the number of situations where a man is considered \u201cjust that way\u201d or \u201cthat\u2019s just his personality\u201d, even \u201cbut he gets the job done\u201d. I can say those same things and hear nothing but \u201cwhat\u2019s wrong with Tammy, she\u2019s so bitchy any more\u201d. I will spell this one out better if a woman comes to a meeting prepared it should not intimidate you, you should be happy to know her. If a woman knows what she\u2019s talking about and is offering opinions or answers you should listen to her, because a fair number of women are still afraid to speak up.\u00a0 If a\u00a0woman ask you a question, you should answer it. You wouldn\u2019t ignore Bill that you eat lunch with every day. This problem will not go away on its own, we have to all work on it together.<\/p>\n<p>&nbsp;<\/p>\n<p>8. We are a team, let\u2019s act like it.<\/p>\n<p>In so many work places I see everyone placing blame and pointing fingers. But if everyone just thought about the end goal and worked towards it life would be so much easier. This problem is most generally set at the management level. But teams can pull together and make a difference. Realistically I like to think that I am living for data integrity and server health maybe if we all did life would be easier.<\/p>\n<p>&nbsp;<\/p>\n<p>9. You are not always right.<\/p>\n<p>Come on admit it you thought you made a mistake once but you were wrong. Seriously I have had to use tactics in order to make senior developers see that they had made a mistake. If I said anything that sounded like \u201cI don\u2019t think this is right\u201d, \u201cI don\u2019t know that this is going to work\u201d or \u201cI think you did this wrong\u201d all conversations ended. But when I approached them with this stupid look on my face and said \u201cI don\u2019t get it what is this suppose to do, can you explain it\u201d they\u2019d start explaining and then say something about well look there I made a mistake. Now this is stupid, why do I have to act dumb and pretend to not get it to get you to see the error?\u00a0 At the end of the day there is no prize for being right. To be honest at the end of life no one will ever say \u201cGee you held your ground and made everyone think you were right all the time, you proved it to everyone so here is your golden pony.\u201d<\/p>\n<p>&nbsp;<\/p>\n<p>10. Wil Wheaton\u2019s rule #1 Don\u2019t be a dick.<\/p>\n<p>The question was asked the other day on twitter, \u201cDoes a DBA need to be confident to be a good DBA?\u201d My answer was yes but not to the point of cocky. We all still have something to learn, let us not forget that. We\u2019ve all had a bad day, let\u2019s treat each other like it matters.<\/p>\n<p>&nbsp;<\/p>\n<p>Ok so maybe I didn\u2019t pick a single popular opinion to go against, maybe just don\u2019t be that guy isn\u2019t enough. I want to leave you with this final thought. The popular opinion is to \u201cjust let things go\u201d, \u201cnot to cause trouble\u201d, \u201ckeep your nose clean\u201d and the list goes on. What I want to challenge you with is not letting that happen. Don\u2019t let the bully get by with acting that way, don\u2019t let someone be a dick and call someone out for treating women differently. WHY do we just let things go? I am not calling for vigilante\u00a0justice I am just asking you to help out once in a while, stand up for someone or even just back them a little. I think every little bit helps.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Don\u2019t Be that Guy or 10 things I hate about you <\/p>\n<p>It always comes to me as a surprise that it is TSQL Tuesday again. I guess time just slips by so quickly these days. This awesome month of March is brought to us by Michael Stewart [ BLOG | TWITTER ]. March is awesome by the way because it contains my birthday. If you haven\u2019t heard about or figured out what this Tuesday stuff is all about drop me a line and I will not only sell you on the concept I will convince you to write your first post for next month.<\/p>\n<p>So at first I thought <span style=\"color:#777\"> . . . &rarr; Read More: <a href=\"https:\/\/clarkcreations.net\/blog\/tsql-tuesday-052\/\">TSQL Tuesday #052 &#8211; Argue Against A Popular Opinion<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,178],"tags":[308],"class_list":["post-938","post","type-post","status-publish","format-standard","hentry","category-technology","category-tsql2sday","tag-tsql2sday","odd"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/938","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/comments?post=938"}],"version-history":[{"count":0,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/938\/revisions"}],"wp:attachment":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/media?parent=938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/categories?post=938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/tags?post=938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}