pict-ice-hockey-rink-view-from-long-side-hockey-rinks-vector-stencils-library-png-diagram-flowchart-exampleWorking on something interesting from a back-end and data visualization perspective and I needed to get all of the NHL Play by Play game statistic data files, So I wrote a Node.js application called nhlplaybyplay-node that provides the means for accessing, fetching the NHL Schedule and Play by Play game data files which are in JSON format.

Hope your familiar with this…
The following URL retrieves the complete 2016-2017 NHL season schedule
http://live.nhl.com/GameData/SeasonSchedule-20162017.json

Read Full Post →

In-memory distributed processing for large datasets… How to connect to SQL Server using Apache Spark? The Spark documentation covers the basics of the API and Dataframes, there is a lack of info. and examples on actually how to get this feature to work.

spark-logosql-server

First, what is Apache Spark? Apache Spark is an open source big data processing framework built around speed, ease of use, and sophisticated analytics. A fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark’s standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.

Read Full Post →

ottawapass Hope you are all enjoying the last stretch of summer! Just wanted to inform you that The Ottawa SQL Server User Group will be back on Thursday September 15, 2016 for yet another great season. We are looking forward to share and deliver great content about SQL Server 2016, Power BI, Azure Cloud and many more related topics…

Speakers, if you would like to present at one of our scheduled meetups, please submit your session title and abstract to stephanefrechette@ukubu.com with “Ottawa SQL Server User Group” in the subject header

To register and confirm your attendance and for more details please visit our Meetup page -> http://www.meetup.com/OttawaSQLServerUserGroup/

Read Full Post →

With SQL Server 2016 literately just days away from being officially available to public for download (Get ready, SQL Server 2016 coming on June 1st). I wanted to highlight one important new key future called Row-Level Security. So what is Row Level Security? Row-Level Security enables customers to control access to rows in a database table based on the characteristics of the user executing a query (e.g., group membership or execution context).

sql-server-2016-row-level-security-04

Read Full Post →