About Us

Learn more about us.

Dynamics GP

A Microsoft Dynamics GP table reference was created to help users create SQL queries.

Read More

Lesson Plans

Lesson plans created by certified members of the Ontario College of Teachers.

Read More

Service Pricing

Learn about Datacrunch Canada services and competitive rates.

Read More

RemoteFX on Windows 10 Pro

Start with Windows 10 Professional (64-bit) and add the Hyper-V component.  You can find the Hyper-V Manager in the Administrative Tools folder. Create a Virtual Machine.  For this test, a Generation 2 Virtual Machine was used with .VHDX virtual Hard Disk. In the Hyper-V Settings, click on Physical GPUs and select a GPU from the list.

Read More

Sample SQL Test

Sample SQL Server Test Q = Question A = Answer C = Comments Q1. What does SQL Stand for? A1. Structured Query Language C1. This question was probably asked to weed out candidates who answer “Sequel” or guess. Q2. Write a SQL query to select everything in a table. A2. SELECT * FROM <table> C2.

Read More

Jamaican Stew Chicken Recipe

Ingredients Chicken Grace Browning Caramel Sauce West Indian All-Purpose Seasoning Soy Sauce Onions and Garlic or Garlic Powder Oregano Black Pepper Instructions Add all ingredients in teaspoon amounts Sear the chicken in very hot oil Throw away excess oil when done Add two cups water, along with onion and diced garlic and more All-Purpose Seasoning

Read More

Basic T-SQL Join Where…

Lets say you have two tables: Employees and Profile.  You need to find everyone who is over 21. Employees: UserID, int Name, varchar(5) 1, Peter 2, Cathy 3, Manuel 4, Jonathan Profile: UserID, int Birthday, date 1, 2010-03-13 2, 1997-06-21 3, 1988-04-16 4, 2013-08-22 select Name from Employees as e join Profile as p on e.UserId=p.UserID where DATEADD(YY,21,Birthday) <

Read More

FFVII: Re-Imagined

Head over to http://ffvii-reimagined.com to download the game. Feels like playing Megaman with Zero.  Wasn’t able to get it working with my PS3 controller though.  Default keyboard mapping is awkward for a side-scroller.  Looking forward to the completed game!