Here is my End of Year Presentation and Training Schedule:
 
sqlsatwinnipegI will be presenting at SQLSaturday #350 about “Graph Databases for SQL Server Professionals”. SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Nov 22 2014 at Red River Community College – downtown, 160 Princess St., Winnipeg, MB R3B 1K9, Canada. Admittance to this event is free register here
 
 
 
it-camp-bannerOn December 5 I will be teaching a free 1-day course “IT Camps: SQL Server 2014 and Power BI” at the Ottawa ctc TrainCanada offices. This 1-day hands-on technical training workshop focuses on scenario or lab based learning. This course enables database administrators (DBAs) to explore SQL Server 2014, In-Memory for OLTP and DW, Hybrid Cloud with Microsoft Azure for backup and DR, and Power BI. For more information and to register click here
 
I will also be hosting our monthly Ottawa SQL Server User Group (Ottawa PASS Chapter) meetings.

Configuring SharePoint 2013 as a BI Platform

Thursday, Nov 27, 2014, 6:15 PM

Coradix
151 Slater St., Suite 1010, Ottawa, ON Ottawa, ON

21 Members Attending

Presentation: Configuring SharePoint 2013 as a BI PlatformWith SharePoint as the business collaboration platform of choice for the enterprise, it has become an important piece in the overall Microsoft BI stack. However, deploying and configuring it to support Microsoft BI solutions has become a cumbersome task for the IT professional.In this sess…

Check out this Meetup →

 

SQL Server Lightning Talks Night

Tuesday, Dec 9, 2014, 6:15 PM

Pythian Office
1200 St. Laurent Blvd #261 (in the St. Laurent Shopping Centre) Ottawa, ON

8 Members Attending

With just a few weeks before the holidays, let’s make this a fun and relaxed evening!Participants (Yes you!) speak about their ideas and personal or professional passions about SQL Server and related technologies.Kinda like Ignite talks -> “Enlighten us, but make it quick!”Lightning Talks Format: max. 5 to 10 minutes each presentation (slides n…

Check out this Meetup →

Lately been experimenting and playing around with different javascript data visualization libraries and found this interesting one Vis.js, a great dynamic browser based visualization library that can handle large amounts of dynamic data. A Visual Interactive System, which the library consists of the following components; Dataset, Timeline, Network, Graph2D and Graph3D.

So I built this Network Graph… Astérix Network Graph, about characters and albums.
(Yep, you must have figured out by now that I am a fan… and that I have data!)

The result can be viewed at the following GitHub page -> sfrechette.github.io

Model:

  • Vertices (Nodes) : Characters, Albums
  • Edges (Links): fellow_companion, appeared_in

GitHub Repo: https://github.com/sfrechette/visjs-asterix

nwg_asterix

Source: http://www.asterix.com
Astérix, all characters and images are © 2014 Les Editions Albert René

When I am on the hunt and scouting for some data, either to prepare and use for a demo or to help me learn new technologies these are the following resources, listing of public datasets I consult;

[Some contain redundant links, if you have others that you use please share and I will gladly add them to the list]

Enjoy!

  • datalibre.ca – Open Data (contains list of Canada – Open Data Cities, Provinces, Feds + International)
    http://datalibre.ca/links-resources/
    1. KDnuggets – Data: Government, State, City, Local and Public
      http://www.kdnuggets.com/datasets/government-local-public.html
    2. KDnuggets – Datasets for Data Mining and Data Science
      http://www.kdnuggets.com/datasets/index.html
    3. Kevin Chai’s Dataset list
      http://kevinchai.net/datasets
    4. Microsoft Azure Marketplace
      https://datamarket.azure.com/
    5. Yahoo! GeoPlanet Data
      https://developer.yahoo.com/geo/geoplanet/data/
    6. OSDC – Public Data Sets
      https://www.opensciencedatacloud.org/publicdata/
    7. figshare – store, share, discover research
      http://figshare.com/
    8. Quandl – Find and Use Data. Easily.
      https://www.quandl.com/
    9. Enigma – Navigate the world of public data
      http://enigma.io/
    10. Datahub – The easy way to get, use and share data
      http://datahub.io/
    11. Linked Data – Connect Distributed Data accross the Web
      http://linkeddata.org/
    12. IAPR – Public datasets for machine learning
      http://homepages.inf.ed.ac.uk/rbf/IAPR/researchers/MLPAGES/mldat.htm
    13. CRAWDAD – A Community Resource for Archiving Wireless Data At Dartmouth
      http://crawdad.org/
    14. The R Datasets Package
      https://stat.ethz.ch/R-manual/R-devel/library/datasets/html/00Index.html
    15. R Datasets
      https://vincentarelbundock.github.io/Rdatasets/datasets.html
    16. inside-R – Finding Data on the Internet
      http://www.inside-r.org/howto/finding-data-internet
    17. Gephi sample datasets
      https://wiki.gephi.org/index.php/Datasets
    18. Stanford Large Network Dataset Collection
      http://snap.stanford.edu/data/
    19. Tableau Public – Sample Data Sets
      http://www.tableausoftware.com/public/community/sample-data-sets
    20. Tableau Public – Viz of the Day
      http://www.tableausoftware.com/public/community/viz-of-the-day

      My Meetup presentation at the Ottawa SQL Server User Group(Ottawa PASS Chapter) – Graph Databases for SQL Server Professionals

      Graph databases are used to represent graph structures with nodes, edges and properties. Neo4j, an open-source graph database is reliable and fast for managing and querying highly connected data. Will explore how to install and configure, create nodes and relationships, query with the Cypher Query Language, importing data and using Neo4j in concert with SQL Server… Providing answers and insight with visual diagrams about connected data that you have in your SQL Server Databases!