{"id":432,"date":"2011-01-11T17:25:26","date_gmt":"2011-01-11T23:25:26","guid":{"rendered":"https:\/\/clarkcreations.net\/blog\/?p=432"},"modified":"2011-01-11T17:25:26","modified_gmt":"2011-01-11T23:25:26","slug":"tsql2sday-resolutions","status":"publish","type":"post","link":"https:\/\/clarkcreations.net\/blog\/tsql2sday-resolutions\/","title":{"rendered":"#TSQL2sDay Resolutions"},"content":{"rendered":"

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

As part of my 2011 resolutions I feel the need to participate in T-SQL Tuesday (we’ll get to more about that later).\u00a0 First some of you reading this are expecting a recipe and some FOOD PORN, sorry not today I am a geek and sometimes like to show that off and today is it!!!\u00a0 T-SQL Tuesday was started by Adam Machanic (guess what? He has a blog <\/a>and is on twitter<\/a>!)\u00a0 and the basic rule is that someone new each month host and chooses a topic.\u00a0 This month it is our friends MIDNIGHTDBA (Jen and Sean – guess what they blog <\/a>and twitter<\/a> too!!).\u00a0 If you are able to stay up that late on Friday night I highly recommend you stop by, it’s generally a good time.\u00a0 So here it is January 2011 and it’s the second Tuesday of the month therefore T-SQL Tuesday and this month topic RESOLUTIONS! What techie resolutions are you pondering, and why?<\/p>\n

I know, I know I already did something simular to resolutions but in my defense those were pretty general and not as work\/career\/geeky as they should be.\u00a0 But I have a few things up my sleeve that I have been thinking about and mostly it’s a good idea.\u00a0You have to be careful, if someone at work reads your blog and you “resolve” to look for a new job that might just not work out so well.\u00a0 \ud83d\ude00<\/p>\n

In my list of items to concentrate on for this year I included : #3 Keep up with the new blog, off to a good start here at the end of the year now just to keep it moving. Now what wasn’t detailed here is that I would really like to include a sprinkling of SQL post to go along with the food.\u00a0 I mean anyone who knows me and has to talk to me for very long I am all about geek, food, my dogs and a few other misc. things.\u00a0 Participating in T-SQL Tuesdays is a great way to do this.\u00a0 So here we are and now you know why.<\/p>\n

Also included in the list was this: #4 Professional development shall be worked into my work week.\u00a0 Every week.\u00a0 Will need to work this out with the boss. But I got a Kindle to help with this.\u00a0 I don’t see this as a problem as she’s all about it. This week she issued a challenge “JIRA-123” is a report currently on BOE go redo it as an SSRS report, it’s not a group project and I will buy the winner a $25 gift card to the place of their choice.\u00a0 Hands down I have more experience than any of them with SSRS so this should be fairly easy.\u00a0 But using your brain to think out the obvious 1 we only use SPROC in our reports for production and I have never done this 2 SHIT! who knows if we even have access to do any of this 3 there is a list of standards we are suppose to adhere to and 4 there appears to be a “design” issue to work with.\u00a0 Well I did the research and obtained the access.\u00a0 I now have an SSRS report on the DEV server with a SPROC on our reporting server and I fixed the design issue properly not like the “hack” my co-workers used.\u00a0 This should be fun and help my goal.<\/p>\n

So for new items.<\/p>\n

I am going to make it a life-long resolution to start looking for a new job at any point in time if the job becomes not challenging (I don’t mean a pain in the butt challenging I mean for my brain) or\u00a0I figure out that I am no longer growing with no future growth.\u00a0 I was in my last postion for more than 5 years and many of those at the end would of allowed me to waste away to nothing but I took that stupid bull by the horns and hopped on for a ride. I used that last\u00a02 years to develop skills on their dime.\u00a0 I watched online presentations, practiced and read.\u00a0 So that time it was worth it and okay but never again will I let myself start to wither.\u00a0 THANK YOU SQL Server community for providing me such great opportunities to learn!<\/strong><\/p>\n

Which brings me to another resolution, I wasn’t sure how ready I was to say this outloud but here it goes.\u00a0 I would like to present something at our local SQL users group.\u00a0 Whew, that was painful.\u00a0 Actually it will be more painfull if I get to November and haven’t done it yet.\u00a0 But yes I want to give back. Currently my giving back is by answering questions when I can and providing morale support.\u00a0 I am usually pretty good at being the team cheerleader so I guess that isn’t always bad.<\/p>\n

So to make my life geekier, errr I mean easier I would like to get a few of those random\u00a0.xls files laying dumped into SQL and turned into something I can access online.\u00a0 Now that KLT (guess what? He blogs<\/a> and is on twitter<\/a> too!) has set up a SQL server and given me access we can work on this.\u00a0 Currently we have a wine list that includes the qty, location, where to find the tasting notes\u00a0and cost if we grabbed it at the time.\u00a0 I also have a material list for sewing and we are going to make an inventory of the freezers in the basement,you guessed it I\u00a0have started the\u00a0list in excel. Hey it isn’t a bad program there are actualy a couple really cool features, like conditional formatting.\u00a0 If the bottle count is <1 it turns red so I know to buy more.\u00a0 \ud83d\ude00<\/p>\n

Well this\u00a0is all I have to say about resolutions.\u00a0 Of course I could make\u00a0a list that is a mile long but when 2012 rolled around I might be sad that I didn’t get it all done.\u00a0 You really should keep the goals to obtainable and not overwhelming.\u00a0 I mean I already have to get less fat and cook some vegetarian stuff.<\/p>\n

\u00a0Good luck everyone with your 2011 resolutions, may you be safe and successful all year!!!<\/p>\n","protected":false},"excerpt":{"rendered":"<\/p>\n

As part of my 2011 resolutions I feel the need to participate in T-SQL Tuesday (we’ll get to more about that later). First some of you reading this are expecting a recipe and some FOOD PORN, sorry not today I am a geek and sometimes like to show that off and today is it!!! T-SQL Tuesday was started by Adam Machanic (guess what? He has a blog and is on twitter!) and the basic rule is that someone new each month host and chooses a topic. This month it is our friends MIDNIGHTDBA (Jen and Sean – guess what they blog and twitter too!!). If you are able . . . → Read More: #TSQL2sDay Resolutions<\/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":[5,147,8,178],"tags":[],"class_list":["post-432","post","type-post","status-publish","format-standard","hentry","category-everyday-life","category-sql","category-technology","category-tsql2sday","odd"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/432","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=432"}],"version-history":[{"count":0,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/432\/revisions"}],"wp:attachment":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/media?parent=432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/categories?post=432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/tags?post=432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}