PASS

It’s been a while since I’ve written a #tsql2sday post, but thought that this month’s topic was worthy of me hoping into the pool with the #sqlfamily. This month the subject is “Automation”. chosen by Hemanth D. (Blog | @SqlChow). If you want to read the opening post, please click the image above. I’m lover of software automation and been a fan since writing my first macro in Excel when I was in high school. I loved anything that makes it easier for you to get more done with less. Back in the 2000’s I got introduced to SQL 2000 and DTS and it changed my world. My first package I created was awesome and so exciting it took data from database and put it into another one and then truncated the table, once I scheduled it to run I was able to not worry about handling that task anymore and sleep peacefully. Since then I’ve found my passion and made a living improving businesses through process improvement using automation.

So I’m about a month late or maybe three in writing my recap on the event so here goes. It was awesomeness !!!! 2012 marked my second SQL Saturday that I’ve attended and have to say it just keeps getting better. This year I was able to volunteer with registration which is an awesome way to meet all the attendees well at least most of them. Also I hooped into five awesome sessions “A Complete BI Solution in About an Hour!” With Arron King, SRS Report Builder for Business Intelligence with David Eichner, Kama Sutra of SSIS: A guide to loving ETL with Bill Fellows, and The Script Task, powerhouse of SSIS with Norman Kelm, and Join Us! Getting Started as a Technical Speaker with Eddie Wuerch cause I would love to start speaking at SQL events outside of work. Biggest take a way’s from this year event was networking with others in the profession and the knowledge I picked up from all the sessions. I’m already looking forward to the 2013 event.

Another #Meme 15 topic brought you by MVP Jason Strate (Blog | twitter). This month topic “What are ten blogs that you think other SQL Server professionals should be following but might not be?” Coming up with a list of just 10 is harder than I thought narrowing it down to ten is just way to hard but i was able to do. The list I  put together covers everyone from the newbie to SQL to the all-round DBA.

This month’s Meme15 assignment and the first was chosen by Jason Strate (Blog|Twitter) he posed the assignment of writing about why do I blog and why I started.

I started blogging back in 2003 just about a one year after launching Gogorichie.com, back then it was the social network of its time along with AIM and YIM. As me and my high school friends went off to college we stayed in contact via our blogs. You know this topic made me go back to the very beginning and read my very first blog posting. It brought up memories of living in LA and the good times I had out there. Wait most of those post were written after coming home from a night out so a lot of the postings were run but all fun.

This month’s T-SQL Tuesday topic is from Allen White. He posed the question of what is my favorite little SQL trick. I can’t wait to see what tips the #SQLFamily write about. I discovered one of my favorite tricks last year, just a little background my first SQL version I started out administrating and developing on 8 years ago was SQL 2000 back then to get table statistics was no easy task. These days you just need to right-click on the database and go the reports to get much of the information you’ll need about a database. I started using SQL 2008 last year so when I when wrote a blog post about this little trick I came across online on how to quickly pull the table size information it had been one of my favorite tricks then. Since I’m still dealing with data in SQL 2000 server production environment still this trick still comes in handy. Thanks to the posting by Mitchel Sellers on How to Determine Table Size it’s become quick and easy to get the information I need about my databases.

I saw this topic a few weeks back on @sqlrockstar’s site but never got around to writing a post.

I’ve been in working on databases for about 6 years now a mixture of Access, SQL, Teradata, and MySQL. So when I saw the topic thoughts began to flow through my brain. What does the SQL Family mean to me?? it means that there is a network of people with the same interest, challenged by the same problems as me. Now with my discovery of twitter, hence the hashtag I’ve been able to discovered the family and discovered local events such as the user groups in Chicago and SQL Saturday’s events and many others including a yearly cruise. Now when i need help with programming question I can turn to the #sqlfamily, the people are so cool that when its someone’s birthday or other special occasion they get acknowledged by the #sqlfamily or even a sad event the family member off words of comfort.