SQL

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

Richard Lewis
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.

Getting Started With Microsoft Access

Richard Lewis
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.

Querying The Most Recent Records

Richard Lewis
Here’s another fun solution for you business intelligence people out there. Suppose you wanted to pull data that was updated in the last 15mins based on when a row was last. I’m sure there are many ways to accomplish this but I like to use the DATEADD() function in Microsoft SQL Server 2008. Below is the query using the AdventureWorks2008R2 database enjoy. SELECTI.ProductID,I.LocationID,I.Bin,I.Shelf,I.Quantity,P.ProductNumber,P.Name,I.ModifiedDateFROMAdventureWorks2008R2.Production.ProductInventoryASILEFTOUTERJOIN AdventureWorks2008R2.Production.ProductASPONI.ProductID=P.ProductIDWHERE(I.ModifiedDate>=REPLACE(CONVERT(VARCHAR(19),DATEADD(minute,-30,GETDATE()),120),'-',‘/'))P.S. Before the query in the example will work on the AdventureWorks database you’ll need to update a couple of rows on the ProductInventory table.

SQL Saturday 119 Recap In 189 Words

Richard Lewis
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!

April Meme 15 Assignment

Richard Lewis
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.