In preparation for my presentation “Graph Database for SQL Server Professionals” (details here) I thought it would be worthwhile to quickly demonstrate and walkthrough installing Neo4j on Windows and get started creating graphs.

With the exception of our Windows Installer, you’ll need a Java Virtual Machine installed on your computer. It is recommended that you install either OpenJDK 7 or Oracle Java 7.

Then you need to download the latest stable version of Neo4j for Windows, which you can get here -> http://neo4j.org

Once the download completed run the executable and follow these simple steps:
[for the purpose of this demonstration Neo4j 2.1.3 was installed on a Windows Server 2012 R2 VM]

neo4j_install01

neo4j_install02

neo4j_install03

neo4j_install04

neo4j_install05

Not quite done! Before you click Start let’s you will need to change some default settings.

Click on Settings…

neo4j_install06

Then click the Edit… button for the Database Configuration

neo4j_install07

In the neo4j.properties file we want to enable Autoindexing which is disabled by default.
Simply remove the number sign (#) at the beginning of the following lines:

node_auto_indexing=true
node_keys_indexable=name,age

Once completed the file should look similar to the following – Close the file to Save and Close the Neo4j Settings

neo4j_install08

Now you can click on Start and browse to http://localhost:7474

neo4j_install09

You are now ready to explore Neo4j and create graphs. Do the Getting started and go through the Movie Graph sample

neo4j_install10

Some useful resources to explore:

In the near future I will posting more Neo4j topics; Graph Data Modeling, Importing data and Cypher.
Enjoy!

I have created Canadian cities Polygons for Tableau. They are either Electoral Districts or Wards and the source shapefiles comes from the following cities Open Data Portals:

You can access these polygon points csv files from my public Dropbox here: Polygons for Tableau

City of Ottawa Wards

OttawaWards

If you want to know how to create and prepare polygon maps from shapefiles to use in Tableau, I recommend the following articles:

Keep you posted on new files from other Canadian cities…

Slides from my presentation at the Ottawa SQL Server 2014 Day.
Thank you to everyone who attended the full day presentations on SQL Server 2014.

SQL Server 2014’s mission is to deliver for our customers mission critical performance for the most demanding database applications, hitting on all aspects of mission critical criteria from performance to security, scalability and high availability along with the mission critical support.

When it comes to business intelligence the mission is to deliver faster insights into any data big data, small data, all data and most importantly deliver BI in a consumable manner for business users through familiar tools.

Crisis Text Line is the first US nationwide, free, 24/7 text hotline for teens in crisis.
Millions of teens are quietly suffering every day with bullying, homophobia, suicidal thoughts, and more. The solution is beautifully simple: Crisis Text Line will provide crisis intervention services to teens via a medium they already use and trust: text.

A sample dataset (real data) is available from the Data Visualization Contest. This is what I came up with using Tableau… You can also browse and download other workbooks from my Tableau Public Profile

sqlserver2014
 
 
 
 
 
 
 
Now that SQL Server 2014 is out, it’s time to get busy and learn! Below you will find a series of resources that will help you get started. First get an evaluation copy (180-day trial) here Download SQL Server 2014

Learn & Experience
Get free training and guided experience on learning about SQL Server.

Community & Social Media

pass
Want to Connect, Learn, and Share? Join the SQL Server Community by becoming a PASS member here PASS – Professional Association SQL Server and find a Local PASS Chapter where you can share your passion and knowledge about Microsoft SQL Server and Business Intelligence with other enthusiasts.
 
 
 
 
 
A minimal list of “SQL Server Community” Twitter accounts worth following:

  • @SQLServer
  • @SQLTechCenter
  • @MicrosoftBI
  • @MSAzureCat
  • @SQLPass
  • @pass24hop
  • @SQLServerMag