1Gbps internet to be rolled out to a farm near you


Is your current 100-240Mbps internet connection getting you down?

Well starting in September 2015 the Irish government (via Eircom) will be rolling out 1Gbps (1000 Mbps) fibre across the country.

Strangely enough it looks like they will be rolling out to rural communities, villages and farms first.

https://www.siliconrepublic.com/comms/2015/06/25/1gbps-broadband-speeds-are-coming-to-ireland-this-september

https://www.siliconrepublic.com/video/interview-with-carolan-lennon-md-of-eircom-wholesale-on-irelands-broadband-future

https://www.siliconrepublic.com/comms/2015/01/05/the-state-of-the-irish-nation-in-broadband-in-2015

Advertisements

6 rules of success by Arnold Schwarzenegger


This is one of my favourite speeches:

6 rules of success:

  1. Trust yourself.

  2. Break some rules.

  3. Don’t be afraid to fail.

  4. Don’t listen to naysayers.

  5. Work your butt off!

  6. Give something back.

And remember to sleep faster 😉

Learn Electronics


I’ve created this page a quick resource on where to find good training material.

Getting Started

https://learn.sparkfun.com/tutorials/where-do-i-start

Voltage, Current, Resistance, and Ohm’s Law

OhmsLaw  Ohm's_law_triangle  FormulaWheelElectronics

https://learn.sparkfun.com/tutorials/voltage-current-resistance-and-ohms-law

Alternating Current (AC) vs. Direct Current (DC)

https://learn.sparkfun.com/tutorials/alternating-current-ac-vs-direct-current-dc

Powering you projects

https://learn.sparkfun.com/tutorials/how-to-power-a-project

https://learn.sparkfun.com/tutorials/battery-technologies

https://learn.sparkfun.com/tutorials/how-lithium-polymer-batteries-are-made

Voltage regulators

Polarity

https://learn.sparkfun.com/tutorials/polarity

Multimeters

https://learn.sparkfun.com/tutorials/how-to-use-a-multimeter

Wires & Conductive Thread

https://learn.sparkfun.com/tutorials/working-with-wire

https://learn.sparkfun.com/tutorials/sewing-with-conductive-thread

Connectors

https://learn.sparkfun.com/tutorials/connector-basics

Circuits

https://learn.sparkfun.com/tutorials/what-is-a-circuit

Concepts

https://learn.sparkfun.com/tutorials/tags/concepts

Schematics / Diagrams / Fritzing

https://learn.sparkfun.com/tutorials/how-to-read-a-schematic

http://fritzing.org

Series and Parallel Circuits

https://learn.sparkfun.com/tutorials/series-and-parallel-circuits

http://en.wikipedia.org/wiki/Series_and_parallel_circuits

Breadboards

https://learn.sparkfun.com/tutorials/how-to-use-a-breadboard

Breakout board

Soldering

https://learn.sparkfun.com/tutorials/how-to-solder—through-hole-soldering

Resistors

https://learn.sparkfun.com/tutorials/resistors/types-of-resistors#trim

Analog Potentiometers / Rheostats

http://electronics.stackexchange.com/questions/11048/whats-the-difference-between-a-potentiometer-and-a-rheostat

Digital Potentiometers

http://en.wikipedia.org/wiki/Digital_potentiometer

https://www.sparkfun.com/products/10613

http://cdn.sparkfun.com/datasheets/Components/General%20IC/22060b.pdf

Resistor Colour Codes

Capacitors

Voltage Dividers

Voltage Divider

Voltage Divider Equation

https://learn.sparkfun.com/tutorials/voltage-dividers

http://www.electronics2000.co.uk/calc/potential-divider-calculator.php

Diodes

LEDs

https://learn.sparkfun.com/tutorials/light-emitting-diodes-leds

https://learn.sparkfun.com/tutorials/how-leds-are-made

Transistors

https://learn.sparkfun.com/tutorials/transistors

OpAmps

Analog to Digital Conversion & ACD (Analog to Digital Converters)

http://en.wikipedia.org/wiki/Resistor_ladder

Digital to Analog Conversion & DACs (Digital to Analog Converters)

http://en.wikipedia.org/wiki/Resistor_ladder

Motors

http://science.howstuffworks.com/transport/engines-equipment/gear-ratio.htm

https://learn.sparkfun.com/tutorials/pulse-width-modulation

https://learn.sparkfun.com/tutorials/motors-and-selecting-the-right-one

http://en.wikipedia.org/wiki/H_bridge

Sensors

Arduiono / PIC / ARM

https://learn.sparkfun.com/tutorials/data-types-in-arduino

https://learn.adafruit.com/multi-tasking-the-arduino-part-1/using-millis-for-timing

Intel® Edison

https://www.sparkfun.com/products/13024

https://learn.sparkfun.com/tutorials/edison-getting-started-guide

Wifi

ESP8266

http://www.seeedstudio.com/depot/WiFi-Serial-Transceiver-Module-w-ESP8266-p-1994.html

Bluetooth

Manufacturing

https://learn.sparkfun.com/tutorials/how-to-sell-your-widget-on-sparkfun

http://fab.fritzing.org/fritzing-fab

3D Printing – Video of my first successful 3D print being created


Adventures in 3D Printing – Part 1 of hundreds


So it’s taken me a little over a year to put my 3D printer together, but I’ve finally done it.

This is what it looks like:

3D Printer

After many hours of trying to calibrate the machine last Thursday, I finally managed to successful print my first 3D object:

First 3D Print

He’s not quite a high quality specimen yet, but he’s strong as hell and a really good start.

I really wasn’t expecting to be able to create objects that are that strong, so I’ve quite excited about the possibilities now.

I’ll be posting a video of the printing process shortly, but here’s a snapshot in the meantime:

3D Printer at work

I’m envisioning creating many more posts related to 3D printing as I learn this craft, so please check back regularly 🙂

The last piece of the puzzle has arrived!!! :-)


I’m feeling so excited, as (hopefully) the last piece of the puzzle has arrived !!! 🙂

I can’t wait to get home and try out my 3D printer.

Stepper driver - DRV 8825

Get 115GB of FREE cloud storage from Microsoft


Microsoft are currently offering 115GB of free online storage for the next 2 years.

All you have to do is follow these links:

  1. Sign up to OneDrive
  2. Claim 100GB of bonus storage

Enjoy 😉

How to trace MDX queries running on Analysis Services


So you’ve got a BI solution up and running and want to find out what MDX queries are actually running on your server?

Well this guide will help you quickly find out.

 

Step 1: – Launch SQL Profiler – You can find it on the Tools menu of SQL Server Management Studio (SSMS):

How to trace MDX queries running on Analysis Services - 1

 

Step 2: – Login to Analysis Services:

How to trace MDX queries running on Analysis Services - 2

 

Step 3: – Start a new Trace:

How to trace MDX queries running on Analysis Services - 3

 

 

Step 4: – Remove a lot of the noise by removing all the events you don’t care about:

Just leave the ‘Query End’ event ticked.

If your server isn’t very busy then you can probably just click ‘Run’ to start profiling, otherwise continue onto the next step.

How to trace MDX queries running on Analysis Services - 4

 

 

Step 5: – Filter the traces even more

Before clicking ‘Run’ you can do some more filters by clicking on the ‘Column Filters’ button.

How to trace MDX queries running on Analysis Services - 5

 

 

Step 6: – Show queries for only a specific user

Here I’m adding a filter to only show results where the NTUserName = grudman ( grudman is my username)

How to trace MDX queries running on Analysis Services - 6

 

 

Step 7 – Click run, and watch the trace logs come in 🙂

How to trace MDX queries running on Analysis Services - 7

 

 

Step 8 – Optionally create a template for all this

Please see my next article for the steps you’ll need to perform

 

As always all feedback is welcome 🙂

Setting up my work PC – After SSD upgrade


I’m busy re-installing my work notebook and decided to create a list of all the tools I’ll be installing – Hopefully this helps someone out there.

If you have any choice in the matter I would highly recommend using SSD drives – If you could only upgrade one thing in you PC then this should be it.

The software I’m planning on installing:

  • Base image = Windows 7 x64, Office 2013, Antivirus, Full disk encryption 😦
  • Chrome – Browser
  • Firefox – Browser
  • Lastpass – An essential tool to help you manage your passwords
  • Crowd Rename – Tool for quickly renaming files
  • Virtual Clone Drive – Mount ISOs to a virtual DVD drive
  • Visual Studio – Best IDE ever 😉
    • Update the Plugins – Menu:Tools-> Extensions & Updates
  • Web Essentials
  • Microsoft SQL Server Data Tools for Visual Studio 2013 – Adds Database project templates to Visual Studio
  • Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013 – BI tools
  • ADO MD.Net (search for ENU\x64\SQL_AS_ADOMD.msi) – These client components provide the functionality for client and middle-tier applications to easily query data and metadata from an analytical data store, such as Microsoft SQL Server Analysis Services.
  • Resharper – Essential tool to help you code quicker and cleaner
    • My personal ReSharper templates
  • DotPeek – .NET decompiler
  • SQL Server Management Studio – Best way to interact with Microsoft SQL Server – Make sure to get the latest version
  • Irfanview – Image software. Useful for screenshots and basic image manipulation
  • Notepad 2 – Just better than Notepad in every way
  • JDK 8 – A good reminder of what the web looked like in the early 90’s 😉
  • Android Studio
  • FreeMind – Free Mind Mapping tool
  • mRemoteNG – Remote desktop management tool
  • Treesize – Tool that shows you which folders are using up the most space
  • WinMerge – compare/synchronization tool
  • GrepWin – Search for text in files
  • WinRar – File archiving tool
    • Create template for time based archive filenames
  • 7-Zip – File archiving tool

Other Great tools, but I’m not currently using them:

  • VisualSVN
  • VisualSVN Server
  • HardLink Shell Extention

Other useful tools, but much care is require when installing these!:

  • FileZilla – FTP Client – WARNING Read the Installer Steps Carefully, otherwise it’ll install other rubbish!
  • Unlocker – tool to release locked files and folders – WARNING Read the Installer Steps Carefully, otherwise it’ll install other rubbish!