Showing posts from September, 2014

Mini-ITX Build

I was going to build this bad boy, but I decided to buy a road bicycle instead :S

You can't have everything!  But I thought I'd throw this list up as a reference of price changes and if anyone else is looking for a build that I've double (triple) checked will definitely fit in the box provided.

This kit will fit 1 x 3.5" HDD and 1 x 2.5" HDD very comfortably.  You can fit 2 of each, the problem being that you have to start suffocating the box from air-intake, increasing heat considerably from all reports.

$49 - Cooler Master Elite 110
$171 - EVGA 02G-P4-3753-KR G-SYNC Support GeForce GTX 750 Ti Superclocked 2GB 128-Bit GDDR5 PCI Express 3.0 Video Card
$129 - Corsair RM 450
$104 - 8G Kit (4Gx2) DDR3 G.skill 2133
$164 - Gigabyte Z97N-WiFi
$100-$130 - CPU Cooling
$267 -  i5-4690K

TOTAL: $984-$1014

Prices based off and on 15/08/2014

How Do I Create a New User in a SQL Azure Database?

Had to look at a few different KB articles for this one so thought I'd throw all the steps together in one quick blog.

First you need to create a login, to do this, connect to the master database and run the following query:

CREATE LOGIN login1 WITH password='SuperSecretPassword';
Then connect to the Database you wish to give access to, you need to create the user, then supply the access.  Run the following scripts:

CREATE USER login1User FROM LOGIN login1;EXEC sp_addrolemember 'db_owner', 'login1User';

Push & Pull data to SQL via SharePoint Online and BCS

Ever wondered what sort of SQL data connections are possible in SharePoint Online? Ever wondered of the limitations when trying this type of setup?
If so, read on...  This tutorial will go over all the steps to setup everything from scratch.  Every step is important, you miss one, it won't work.
WHAT YOU NEED SharePoint Online Plan 2 (you cannot achieve this with the basic version of SharePoint online as you require access to the Admin panel to setup Secure Store access permissions and BCS permissions.A windows azure account (which you can get a free 30 day trial as long as you're willing to provide your credit card.SharePoint Designer 2013 installed locally (required to create the final connection to the azure DB.
Please note, you'll make this a hell of a lot easier if all these accounts are setup using the same office logon.  Otherwise you'll be logging in and out like a madman.
Step 1 - Create SQL Database: Log into Azures Management portal (https…