19Dec
Filed in Blogging | SQL | Work
Leave a comment
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. Since their tables where normalized all they needed was an INNER JOIN statement to make this happen. Below is a sample of the statement i wrote for the partner.
SELECT Inventory.[Prt#], Cross.Brand, Inventory.[OH-QTY], Inventory.Desc, Inventory.[Alloc-QTY], Inventory.[Pkg-QTY], Inventory.Cost, Inventory.Lstupdt
FROM [Cross] INNER JOIN Inventory ON Cross.[Brand-ID] = Inventory.[Brand-ID]
See what I mean by quick and simple inner join.
15Dec
Filed in Blogging | SQL
1 Comment
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.
These days I still blog for many different reasons. I put together for my top reasons why and here’s what I came up with.
- Documenting key moments in my life still. 2010 In Review
- Sharing a solution to a problem that I’ve come across while programming. USING DATEDIFF TO CONTROL CONTENT
- Share my opinion on a product or tool. THE DAY AFTER THE 120 DAYS ARE UP
- Share my thoughts with the world and advice. HOW TO SPEND 10 DOLLARS
After all these years of blogging i still have fun and love sharing stuff on my blog.
13Dec
Filed in Microsoft | SQL
1 Comment
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.
05Dec
Filed in Blogging | Microsoft | SQL | Windows Home Server | Xbox 360
1 Comment
Thomas LaRock (blog|Twitter) came up with another fun topic to write about this month. What I want from Microsoft for Christmas I can’t wait to see what all my #sqlfamily peeps write about.
Well this is an interesting topic cause I’m not a devoted fan of Microsoft products. I do have my favorites Xbox 360, Windows Home Server at home and SQL 2000,2005,2008 and Express at work. I can do without office products, and the OS’s and oh yes I said Express, it’s my secret little favorite local database tool. At work getting stuff done with Access only would kill me so I cache what I need locally using SQL Express, design tables there and do a lot of data cleansing using and I mean a lot of freaking cleansing. But yeah all want I want for christmas from Santa Ballmer and Microsoft is a great reason to upgrade all my home computers to Windows 8. That’s simple enough right ????? maybe Santa will bring that oh and Roku box for my wife.
25Nov
Filed in Blogging | SQL
Leave a comment
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.
