A business partner approached me the other day looking to share information with my company. Since parts numbers are recycled more often than lame jokes in my business one of the things we needed the business partner to provide was the brand of the part. The business partner said that this would be difficult to do since they were unfamiliar with linking data across tables in any manner. After understanding a little about the setup of the partner’s tables I taught them to design a view linking the two primary tables where the data could be seen together through a view.
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.
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.
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.
First off shout out to Thomas Larock for coming up with this idea. Today’s meme is “Write a SQL blog post in 11 words or less”, and here is my entry: Write query. Syntax error. Search Google. run query again. Happy dance!!!! Some more shout outs to my favorite readings from last month: * Pinal Dave (Blog | @pinaldave) * Brent Ozar (Blog | @BrentO) * Thomas Larock (Blog | @sqlrockstar) * BIDN (Blog | @bidn)