Category: Microsoft

T-SQL Tuesday #050: Automation, Get Work Done While Sleeping

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.

Getting Started With Microsoft Access

I’ve been using Microsoft Access since Access 97 it’s a very powerful tool is you use it right. You can use it for everything from personal Baseball card inventory control to managing home inventories; even fortune 500 companies use it to manage million dollar systems. As I said if you use it right it can be quite a powerful tool built on some amazing framework. Recently a friend who’s getting into access asked me if I could provide him some resources so that he can get better familiar with the tool. Below is a list of resources I put together for him.


Northwind sample database relationship view

MS Access Blog Resources:



Some Really Good Books To Start With:

Also If you’re looking for some templates visit: I highly recommend checking out the Desktop Northwind 2007 sample database it can show you the full power of this product.