{"id":384,"date":"2010-11-02T08:40:47","date_gmt":"2010-11-02T13:40:47","guid":{"rendered":"https:\/\/clarkcreations.net\/blog\/?p=384"},"modified":"2010-11-01T20:47:52","modified_gmt":"2010-11-02T01:47:52","slug":"tsql-tuesday-why-are-dba-skills-necessary","status":"publish","type":"post","link":"https:\/\/clarkcreations.net\/blog\/tsql-tuesday-why-are-dba-skills-necessary\/","title":{"rendered":"TSQL Tuesday – Why are DBA skills necessary?"},"content":{"rendered":"

\u00a0\"\"<\/a><\/p>\n

2.5-3 years ago I would of answered this question with some smart-ass response about how DBA skills are really only necessary if you ARE a DBA.\u00a0 But 2 years ago KLT (@airbornegeek) scored a job in Nashville and left me in Indiana holding 2 houses, 2 dogs, 2 yards, a pool, 2 systems at work to admin and of all things the databases to take care of.\u00a0 At that point I became the most beloved accidental DBA.\u00a0 Don\u2019t get me wrong I was really bored at work and how much of your time can you really spend looking for a job.\u00a0 I decided to use this opportunity to build more skills.\u00a0<\/p>\n

I was asked to fix some queries that a co-worker had written and published in reports in SSRS.\u00a0 Now I had never been an expert in T-SQL but I had been spending some time learning about SQL Server performance, performance tuning of queries and whatever else free training I could find online.\u00a0 I opened his query and was shocked that ANYONE would do such a thing to the server.\u00a0 What Kerry then explained to me is that most people don\u2019t know any better and I left it at that.\u00a0<\/p>\n

Here we are nearly a year later and I find myself shocked at what the ETL devs don\u2019t know.\u00a0 I had no idea that the things I had picked up trying to manage all of our SQL installs and aspiring to be s SSRS master were more along the DBA knowledge and not so much the simple T-SQL writer.\u00a0<\/p>\n

Examples?! Well for instance how indexes work.\u00a0 Knowing what indexes are on a table and leading your where clause with those improves performance; I work with people who don\u2019t even know what an index is.\u00a0 CAST and CONVERT, most average statement writers have no clue that the SERVER has to perform those actions every place that you put it in the statement, yes BRET that is once in the select, once in the WHERE, once in the GROUP BY and once in the ORDER BY.\u00a0 I am pretty sure that server hates you!!!<\/p>\n

So maybe not everyone aspires to be a DBA, I understand.\u00a0 But knowing some basic level DBA skills 1) surely won\u2019t kill you 2) makes you write better SQL and 3) might make you seem cooler amongst your friends (BAHAHAHH! Prolly not but the SQL community will adore you).<\/p>\n","protected":false},"excerpt":{"rendered":"<\/p>\n

2.5-3 years ago I would of answered this question with some smart-ass response about how DBA skills are really only necessary if you ARE a DBA. But 2 years ago KLT (@airbornegeek) scored a job in Nashville and left me in Indiana holding 2 houses, 2 dogs, 2 yards, a pool, 2 systems at work to admin and of all things the databases to take care of. At that point I became the most beloved accidental DBA. Don\u2019t get me wrong I was really bored at work and how much of your time can you really spend looking for a job. I decided to use this opportunity to . . . → Read More: TSQL Tuesday – Why are DBA skills necessary?<\/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":[147,8],"tags":[],"class_list":["post-384","post","type-post","status-publish","format-standard","hentry","category-sql","category-technology","odd"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/384","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=384"}],"version-history":[{"count":0,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/384\/revisions"}],"wp:attachment":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/media?parent=384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/categories?post=384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/tags?post=384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}