Category Archives: Microsoft

Getting Started With Microsoft Access

December 10, 2012 9:37 am / Leave a Comment /
121012_1537_GettingStar1.png

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:

  1. http://msaccessdevelopment.blogspot.com
  2. http://accessblog.net/
  3. http://accessindepth.blogspot.com/
  4. http://accessexperts.net/blog/
  5. http://msmvps.com/blogs/access/
  6. http://blogs.office.com/b/microsoft-access/

 

Some Really Good Books To Start With:

Also If you’re looking for some templates visit: http://office.microsoft.com/en-us/templates/results.aspx?qu=access&av=zac. I highly recommend checking out the Desktop Northwind 2007 sample database it can show you the full power of this product.

Posted in: Access, Microsoft, SQL

WHS Just Chugging Along

November 20, 2012 1:51 pm / Leave a Comment /
112012_1951_WHSJustChug1.png

 

It’s true when they say no news is good news, my Windows Home Server has been just chugging along currently were approaching 180 days without rebooting, which is quite impressive to even to me. Actually now that think about it I made a major change to my setup back in March. I purchased a Dell PowerEdge 700 for 25 dollars on eBay which a real server instead of an old desktop I had lying around. This was a major performance increase and adds additional room to the cabinet for more hard drives, I think like another 2 or 4 which I’m thinking of throwing all my old drives into the pool to just max out the space. Also I’m not sure what to do with the tape drive currently installed.

Below are the server specs I’m currently running on my most revision to the configuration:

  • 3.2 GHZ Pentium IV
  • 2GB RAM
  • 2 x 500GB SATA
  • External 250GB Backups
  • OS: Windows Home Server

 

 

Posted in: Dell, Microsoft, Windows Home Server

Querying The Most Recent Records

November 13, 2012 1:52 pm / Leave a Comment /
111312_1952_QueryingThe1.png

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.

 

SELECT I.ProductID, I.LocationID, I.Bin, I.Shelf, I.Quantity, P.ProductNumber, P.Name, I.ModifiedDate

FROM AdventureWorks2008R2.Production.ProductInventory AS I LEFT OUTER JOIN AdventureWorks2008R2.Production.Product AS P ON I.ProductID = P.ProductID

WHERE (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.

Posted in: Blogging, Microsoft, SQL

April #Meme15 Assignment

April 10, 2012 11:09 am / 2 Comments /

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.

  1.  http://sqlchicken.com/sql-university/ Great for the newbies and awesome reference points I hope this page never goes away.
  2. http://www.brentozar.com/ I loved Brent’s old content from 2008 maybe it’s because I work on SQL. 2000 and 2008 servers and probably will be for another five years. Must read the take-over posting !!!
  3. http://www.sqljoe.com/ Great webinars a must join and there in Spanish as well occasionally.
  4. http://blogs.lessthandot.com/index.php?disp=authdir&author=420 I love Jes’s blog lot’s of ah ha moments and she’s a Jaycee woo!!! Check out her RDMS comparison chart posting.
  5. http://www.bidn.com/blogs/ Shout out to all the BI bloggers. Lots of interesting content always flowing through this network.
  6. http://www.jasonstrate.com/tag/31daysssis/ Jason put together an amazing series a must read if your new to SSIS development.
  7. http://blog.sqlauthority.com/ This lots of SQL information on Pinal’s site is another gold mine of DBA information.
  8. http://denglishbi.wordpress.com/ Shout out to the BI bloggers.
  9. http://cwebbbi.wordpress.com/ Shout out to the BI bloggers cause we how to know party.
  10. http://sqlblog.com/blogs/jamie_thomson/default.aspx I read a lot of Jamie’s one-off posting.

Peace Out

Posted in: Microsoft, SQL

Post Navigation

← Older Posts