30Nov

Things to make my life easier

Filed in Apple | Blackberry | Blogging | Google | Grooveshark | Microsoft | Netflix | Windows Home Server Leave a comment

I thought it was time to put together a little list of my favorite computer things i use to make my life easier.  No big deal just the things i use everyday no matter if I’m at work or at home. I find myself using these products all the time.

Hope you enjoy my list and post comments and share your thoughts

1) Evernote – I first found the app for my the iPad before i knew about the website. But it’s be came one of my favorites and there’s a desktop version and one for my blackberry too.

2) Grooveshark – This is one awesome little music service no need to download the music or playlist you can stream it from anywhere. They even have a app for blackberry’s too.

3) Click for more screenshotsiPad – Web browsing, video, music, and wide range of other things all in the palm of your hand.

  1. Flipboard – It’s like a magazine with my twitter and facebook feeds.
  2. Keynote – I can make amazing presentations on it very quickly and wow the hell out of people.
  3. RDP Lite – in case i get inspired to do some real work from it and it’s free.

4) Toggl – I love this program it helps me manage my Jaycees development task and hours.

5) Lifehacker – All around good reading and excellent tips

6) Google Doc’s – It’s like Microsoft Office but free and online.

7) Windows Home Server – Every need a file on your home pc while on the road? well this little thing can serve you up the files from anywhere anytime.

8 ) Google Chrome – it’s not just a another browser it’s one of the fastest ones out there and i like how fast it loads pages on my laptop and desktop.

20Oct

Using DateDiff to Control Content

Filed in SQL | Work 1 Comment

 

Last Friday I got a data request from a group asking for a report to be generated bi-hourly for customer request that were not responded to in a time span of two hours. So looking at the data I noticed that there were two columns that were time stamped one when the request was submitted and another when the request was completed, so this was easy I filtered out where the completed data was null and wrote a where statement using a Datediff syntax to breakdown the input date time stamp by hour and then subtracting two so my sql statement looks like the following example.

 

————————————————————————————————————–

SELECT recID, inputDateTime, customername, phonenumber, address, emailaddress, requestcomment
FROM      dbo.VIEW_CustomerOrders_SCRUB
WHERE  (DATEDIFF(hh, inputDateTime, GETDATE()) = 2)

————————————————————————————————————–

Now if you wanted to change it up and make the date two days instead of hours you could easily change the hh argument to dd and so fourth. On the MSDN page from Microsoft they do a good job at covering how to use the datediff arguments to get different results. http://msdn.microsoft.com/en-us/library/ms189794(v=SQL.90).aspx

12Oct

Favorite Business Intelligence Blogs

Filed in Blogging | SQL | Work 1 Comment

As I start to dive deeper into the Business Intelligence area I’ve started putting together a list of my favorite blogs covering this area, in no particular order.

05Oct

SSIS Reference Points

Filed in Blogging | Microsoft | SQL | Work Leave a comment

This is a shout out to my former team member learning about SSIS packages for the first time and getting ready to move from SQL 2000 to SQL 2008. Here’s some good reference points for how to do the basics.   Now before you call me and ask what does SSIS stands it stands for SQL Server Integration Services. So below is a couple links that i found i think you may find helpful in your new adventure.

Some Awesome SQL Development Blogs  
http://jessicammoss.blogspot.com/ http://www.sqlservian.com/
http://adventuresinsql.com/ http://sqlblog.com/blogs/andy_leonard/
http://www.sqlis.com/sqlis/ http://www.brentozar.com/
http://agilebi.com/jwelch/ http://blogs.msdn.com/b/mattm
http://sqlblog.com/blogs/jamie_thomson/ http://blog.sqlauthority.com/
http://crysmanson.com/ http://thesqlagentman.com/
http://jesborland.wordpress.com/ http://sqlchicken.com/
http://www.sqlskills.com/blogs/paul/ http://sqllunch.com/Default.aspx

30Sep

Virtual Meetings For Free

Filed in Blogging | Jaycees/JCI 2 Comments

image

You every want to plan a project or host a committee meeting virtually but don’t have a conference call imagenumber of your own or know where to start?  Well your in luck thanks to a little company called Dimdim you can now host online meetings, trainings, and brainstorming sessions from the comfort of your own home for free. Dimdim is a software company that provides a web-based platform for real-time, rich-media  collaboration and meetings. Dimdim provides free web conferencing service where users can share desktops, show slides, collaborate, chat, talk and broadcast via webcam. Dimdim was recognized in 2009 as a up and coming startup and received many awards over the years. Dimdim is free for meetings under 20 people and only 25 dollars month for meetings larger then 20 but with that extra cost you get tons of premium features such ask online meeting logging meeting attends automatically and recording of the meeting and online signups of the meetings. Which comes in handy for tracking who attended your training and allowing for people to sign up for it up for them online.  Dimdim is a awesome product i found out about from Kevin Rose and it comes in handy so often. if you have questions about it let me know and i would love to tell you more about it.

TOP