CEE MVP Open Days 2015

The event was held on Sunday and Monday: 29 – 30 of March of March 2015 in Belgrade . Serbia. Each year the Microsoft MVPs from each region meet at special “MVP Open Days” event, meeting also professionals from Microsoft Product teams. This was f the biggest Microsoft MVP Open Days for the Central Eastern Europe Region. MVPs met also specialist from the Microsoft Development Lab in Serbia.

Many special thanks to Alessandro Teglia ( EMEA Regional Manager for the MVP Award Program @Microsoft )  , Yulia Belyanina ( Community Program Manager, CEE @Microsoft) and Marina Terzi ( MVP coordinator @ Microsoft ) who did a lot this event to be organized.

This was my first event as a speakers after I joined Strypes / ICT Automatisering . I’m glad that my sessions about modern IoT solutions with Microsoft Azure was included in the schedule. That gave me opportunity to share some impressions about solutions architecture and best practices regarding to the experience gain in Strypes and ICT Automasering .

You can enjoy some photos from the event below:







Event Recap:

– It was the MVP Open Days event with most ever MVPs – participants from CEE

– There was 3 sessions from MVPs from Bulgaria

– My session on “Think Connected – Modern IoT Solutions with Microsoft Azure” was included in the track with technical presentations

You can learn more about the community events in CEE if you follow me on Twitter @mihailmateev , and stay in touch on Facebook, Google+, LinkedIn and Bulgarian BI and .Net User Group !

pass_logo_partner_bw[1] Strypes-LOGO+payoff_FC

Posted in .Net, Azure, Azure NoSQL, Azure Storage, ceeod, COD15, ICT, ict.eu, Internet of Things, IoT, Microsoft, Microsoft Azure, Microsoft cloud, MVP, MVPBuzz, Strypes, Strypes.eu | Leave a comment

Get each eBook and Video prom Packt Publishing only for 5$


If you like eBooks and videos, provided from Pack Publishing you have chance to buy each of them only for 5$. You can do this until 6th of January. Consider this attractive offer – especially if you want to read and watch about the latest technologies for app development and future trentds


Following the success of last year’s festive offer, Packt Publishing will be celebrating the holiday season with an even bigger $5 offer.  

From Thursday 18th December, every eBook and video will be available on the publisher’s website for just $5. Customers are invited to purchase as many as they like before the offer ends on Tuesday January 6th, making it the perfect opportunity to try something new or to take your skills to the next level as 2015 begins.

With all $5 products available in a range of formats and DRM-free, customers will find great value content delivered exactly how they want it across Packt’s website this Xmas and New Year.

Find out more at – http://bit.ly/1wlsbea

Posted in Android, eBonanza, eBooks, iOS, JavaScript, jQuery, JS, mobile, Packt, Packt Publishing, Packtpub, SQL, SQL Server | Leave a comment

SQLSaturday #356 Slovenia 2014–Event Recap


sqlsat356_web2The event was held on Saturday, 13th of December 2014 in Faculty of Computer and Information Science, Ljubljana, Slovenia.   It was one of the most attractive conferences about Microsoft data platform in the region

I was very glad to speak at this event as an independent speaker. My session was about

Entity Framework 6.1 new Features and EF 7 Sneak Peak. Slides are available on the SQLSaturday #356 Slovenia website .

This was the second SQLSaturday in Slovenia.

Administrators of the conference: Dejan Sarka , Mlaqden Prajdic and  Matja Lan demonstrated an awesome organization, that is one of the best examples how one event could be organized. They build a very strong team, that arranged everything in the best way. The registrations drop off was less than 5%.

The #sqlsat356 conference venue: Faculty of Computer and Information Science in Ljubljana

Denny Cherry – @MrDenny is talking about indexes in SQL Server

#sqlsat356 lunch break

Milos Radivojevic in action:

SQLSaturday Slovenia raffle and closing

Event statistics:

  • more than 220 attendees on place
  • 4 tracks
  • 24 technical sessions
  • Speakers and attendees from 16 countries

If you want more information about the event and PASS community feel free to contact me at michael@mateev.net Follow this event on Twitter with hash tag  #SQLSatSlovenia.

You can learn more about the PASS events if you follow me on Twitter @mihailmateev  , and stay in touch on Facebook, Google+, LinkedIn and Bulgarian BI and .Net User Group !


Posted in BI, BI & .Net Geeks, BI & .Net UG, BI & .NET User Group, EF, EF 6, EF 7, Entity Famework 6.1, Entity Framework 6, Entity Framework 7, Entity Framewrok, ORM, PASS, SQL, SQL Saturday, SQL Server, SQL Server 2012, sqlfamily, sqlpass, sqlsat356, sqlsatslovenia, SQLSaturday, SQLServer, SQLServer 2014 | Leave a comment

SQLSaturday #359 Ustanbul 2014 – Event Recap


SQLSAT359_SPEAKINGThe event was held on Saturday, 6th of December 2014 in Microsoft – Bellevue Residences.   It was one of the biggest Microsoft data platform related events in the region

I was very glad to speak at this event as an independent speaker. My session was about

Scaling Out Microsoft Azure SQL Databases Slides are also available for download.

There was an additional event: PreConf , one-day training about SQL Server Query Tuning & Optimization hold by Benjamin Nevarez  on Friday 5-th of December.

This was the fourth SQLSaturday in Istanbul. Administrators of the conference were Yigit Aktan and Turgay Sahtiyan

They organized a team of volunteers who did an awesome event.

0045398f-ccf3-486c-8bda-fbc9751429a5 sqlsat359-1

sqlsat359-3 sqlsat359-4

Event in numbers:

  • more than 250 attendees on place
  • 5 tracks
  • 25 technical sessions

If you want more information about the event and PASS community feel free to contact me at michael@mateev.net Follow this event on Twitter with hash tag  #sqlsatIstanbul.

You can learn more about the PASS events if you follow me on Twitter @mihailmateev  , and stay in touch on Facebook, Google+, LinkedIn and Bulgarian BI and .Net User Group !

Posted in Azure DB Elastic Scale, Azure SQL Datbase Scale Out, Microsoft, Microsoft Azure, Microsoft cloud, Mihail Mateev, PASS, Scale-Out, SQL, SQL Saturday, SQL Server, SQL Server 2012, sqlfamily, sqlpass, sqlsat359, sqlsatistanbul, SQLServer, SQLServer 2014 | Leave a comment

JSNext Bulgaria 2014–Event Recap

On November 23 was held the first event focused on the cutting edge JavaScript technologies – JSNext Bulgaria 2014. JSnext  is the largest conference in Bulgaria for JavaScript technologies.

What is JSNext Bulgaria

  • The very first conference in Bulgaria dedicated to the cutting edge JavaScript and related JS frameworks
  • An event organized with the support of Infragistics, jQuery Sofia UG, Infragistics Friends ( BI & .Net) UG and many volunteers
  • Thanks to the sponsors who helped cover the expenses!
  • An one day event with sessions dedicated to all that is JavaScript.
  • It is a chance for the local community to immerse in their favorite web technologies
  • The largest event for WEB developers in Bulgaria for 2014
  • JSNext Bulgaria inherits jQuery Bulgaria event


Why  JSNext Bulgaria

  • JavaScript is not jQuery any more
  • JSNext (aka JS version next ) Bulgaria is an event about cutting edge JS-related technologies


Event history:

After the few successful “Saturday” format events across different platforms and jQuery Bulgaria conference, the JavaScript event received major interest.

JSNext inherits jQuery Bulgaria conference, but JSNext Bulgaira is a new kind of event :
mainly targeting the latest and the future JavaScript technologies

Infragistics confirmed its support for the event: Thanks to Jason Beres: VP of Development Tools,  Product Management, Community and Evangelism @ Infragistics
Thanks to all community leaders who also confirmed their support!

We chose Sofia Event Center as the best location for this event.

All our speakers are also volunteers – they decided to cover their own expenses to be possible to avoid charging community members











Infragistics participation in the event:

Infragistics was the main sponsor and organizer of the event.

There was one keynote session and one technical presentation from Infragistics Inc.:


Some statistic

  • Nearly 750 registrations
  • More than 600 attendees on site
  • First event in Bulgaria, dedicated to the cutting edge JavaScript related technologies. 
  • The biggest event for WEB developers in Bulgaria this year
  • A Free event for student, academics and community leads
  • 22 sessions in 4 tracks
  • Attendees from 6 countries (Ukraine, Poland, Macedonia, Serbia , Romania and Bulgaria)
  • 25 Speakers from 4 countries (Ukraine, Poland, Macedonia and Bulgaria )

Pictures from the event:

Some photos are available here .

Follow @jsnextconf event on Twitter with hash tag   and get news on all our events with #jsnext and #jsnextconf.  Additional information can be found at the conference website – www.jsnext.net

As always, you can follow us on Twitter @mihailmateev and @Infragistics and stay in touch onFacebook,Google+andLinkedIn!


Warm Regards,
Team JSNext Bulgaria

Posted in .Net, Angular, Angular.js, AngularJS, ASP, ASP.Net MVC, Azure Web Sites, IG, Ignite UI, IgniteUI, Infragistics, Infragistics Bulgaria, Infragistics Friends, Infragistics Inc., jQuery, jQuery Sofia, JS, JSNext, JSNext 2014, JSNext Bulgaria, Knockout, Knockout.js, KnockoutJS, Node, Node.js, Node.js and Azure, NodeJS, Polymer, React.js, Three.js, TypeScript, UX | Leave a comment

SQLSaturday #311 Bulgaria 2014–Event Recap and Follow-up

After the successful SQLSaturday # 152 and SQLSaturday # 199 for the third time in Bulgaria SQLSaturday was held for the third on 11 of October, 2014. It was the biggest SQLSaturday organized in Bulgaria and the region around. This event is organized from PASS with the major support of Infragistics, Infragistics Friends User Group ( BI & .Net Geeks) and many partners, sponsors and volunteers.


What is SQL Saturday:

Infragistics as a company that develops solutions for data visualization and business solutions has many common points in with areas covered from the  conference: BI, Reporting, SQL Server related solutions


Our statistics:

  • 400 registrations + 91 people in the wait list.
  • around 250 real attendees from 16 countries (USA, UK, Portugal, Poland, Holland, Belgium, Turkey, Ukraine, Russia, Bulgaria and Serbia).
  • Speakers and attendees from 16 countries
  • 27 speakers from 15 different countries( Austria, Germany, UK, Denmark, Nederland, Portugal,  Poland, Hungary, Romania, Slovenia, Macedonia, Russia, Ukraine, Turkey and Bulgaria )
  • 16 Microsoft MVPs
  • 3 Microsoft MCMs
  • 30 sessions in 5 tracks
  • Attendees from 5 countries ( Serbia, Macedonia, Romania, Ukraine and Bulgaria )
  • The biggest event on Microsoft Data Platform ever organized in the region


Some pictures from this event:

Dejan Sarka is talking about Optimizing Temporal Queries


Magi Naumova is presenting


Lunch break:


Milos Radivojevic (  @MilosSQL ) in action:


Some of the speakers:


The SQLSaturday #311 Bulgaria raffle


Some of the raffle winners:


You can see more pictures from the conference here:

Feedback in Twitter about SQLSaturday #311 Bulgaria



Infragistics participation in the event:

  • Infragistics was SQLSaturday Bulgaria  conference host , main supporter and a  gold sponsor.
  • Administrators at the conference were Jason Beres and Mihail Mateev
  • There was more than 15 volunteers from Infragistics Bulgaria who helped  the conference to be held
  • There was 1 technical presentation from Infragistics:
    Node.js for SQLServer Nerds : Mihail Mateev

The conference schedule is available here:

Now SQLSaturday Bulgaria Team is looking for appropriate dates for SQLSaturday Bulgaria 2015.

More information about SQLSaturday Bulgaria is available  on the website of the conference http://www.sqlsaturday.com/311/  ,  SQL Saturday Bulgaria Facebook page and you can follow #sqlsatBulgaria and #sqlsat311  on Twitter.

Follow news from Infragistics for more information about new Infragistics events.

As always, you can follow us on Twitter @mihailmateev and @Infragistics and stay in touch on Facebook, Google+andLinkedIn!

Warm Regards,
SQLSaturday Bulgaria Team

 sqlsat311 Saturday

Posted in Azure Blob Storage, Azure NoSQL, Azure Storage, Azure Table Storage, Infragistics, Infragistics Bulgaria, Infragistics Friends, Infragistics Inc., PASS, SQL, SQL Saturday, SQL Server, SQL Spatial, sqlfamily, sqlpass, sqlsat311, sqlsatbulgaria, sqlsatsofia, SQLSaturday, SQLSaturday #311, SQLSaturday #311 Bulgaria, SQLSaturday Bulgaria, SQLServer 2014 | Leave a comment

How to manage Microsoft Azure Table Storage with Node.js

Node.js is one one of the the most popular growing platforms for development.  I started a series of posts dedicated to Node.js , starting with two articles about Node.js and Microsoft SQL Server ( you can see part 1 and part 2 ) .  This blog discusses how you can use Node.js and Microsoft Azure Table Storage . Open source solutions (OSS),  are very suitable for the implementation of platform independent and/or cloud applications. Node.js is widely used in the actual implementation of such cloud applications. I will try demonstrate in several blogs some details how to use Node.js with  Microsoft Azure Storage .


What is Azure Storage?

Microsoft Azure storage services allow us to store/retrieve the NON RELATIONAL data to/from Microsoft Cloud environment. (For relational data, SQL Azure services are used).

In Microsoft Azure Storage, the data can be stored in 4 different formats (v.i.z. Blobs, Tables and Queues, File Storage (in preview )). The retrieval/storage of the above data is done in RESTful way.

  • Blob storage stores file data. A blob can be any type of text or binary data, such as a document, media file, or application installer.
  • Table storage stores structured datasets. Table storage is a NoSQL key-attribute data store, which allows for rapid development and fast access to large quantities of data.
  • Queue storage provides reliable messaging for workflow processing and for communication between components of cloud services.
  • File storage offers shared storage for legacy applications using the standard SMB 2.1 protocol. Azure virtual machines and cloud services can share file data across application components via mounted shares, and on-premise applications can access file data in a share via the File service REST API.



This article is focused on how to handle Azure Table services with Node.js


Table Storage

The Azure Table storage service stores large amounts of structured data. The service is a NoSQL datastore which accepts authenticated calls from inside and outside the Azure cloud.

The Table service contains the following components:



Table Entities:

Table entities represent the units of data stored in a table and are similar to rows in a typical relational database table. Each entity defines a collection of properties. Each property is key/value pair defined by its name, value, and the value’s data type. Entities must define the following three system properties as part of the property collection:

  • PartitionKey – The PartitionKey property stores string values that identify the partition that an entity belongs to. This means that entities with the same PartitionKey values belong in the same partition. Partitions, as discussed later, are integral to the scalability of the table.
  • RowKey – The RowKey property stores string values that uniquely identify entities within each partition.
  • Timestamp – The Timestamp property provides traceability for an entity. A timestamp is a DateTime value that tells you the last time the entity was modified. A timestamp is sometimes referred to as the entity’s version. Modifications to timestamps are ignored because the table service maintains the value for this property during all inserts and update operations.


Consider PartitionKey, RowKey in your design. Think of PartitionKey and RowKey as being a primary index.


Table Partitions:

Azure Tables use keys that enable efficient querying, and you can employ one—the PartitionKey—for load balancing when the table service decides it’s time to spread your table over multiple servers. A table doesn’t have a specified schema.



Partitions represent a collection of entities with the same PartitionKey values. Partitions are always served from one partition server and each partition server can serve one or more partitions.



Dealing with an Azure Table Storage

You can use different NodeJS packages to handle Azure Table Storage. In this post we will cover azure and azure-table-node Node packages.


  • Microsoft Azure SDK for Node.js

It is an official Microsoft Azure SDK for Node.js. This project provides a Node.js package that makes it easy to consume and manage Microsoft Azure Services.

The listed snippets below demonstrate how to manage Azure Table service using Microsoft Azure SDK for Node.js.


This is easy to do since the Azure SDK will look for credentials using environment variables first. The magical environment variable names are AZURE_STORAGE_ACCOUNT and AZURE_STORAGE_ACCESS_KEY.


  • Create a table service

Set credentials using environment variables

   1: var azure = require('azure');


   3: //using enviroment variables for credentials

   4: var tableService = azure.createTableService(); // implicitly use env variables


   6: tableService = azure.createTableService(

   7:   process.env.AZURE_STORAGE_ACCOUNT,

   8:   process.env.AZURE_STORAGE_ACCESS_KEY); // explicit



Set credentials explicitly using local variables

   1: var accessKey = '[accountKey]';

   2: var storageAccount = '[accountName]';


   4: var tableService = azure.createTableService(

   5:   accessKey, storageAccount); // explicit


  • Insert an entity
   1: var tableService = azure.createTableService();


   3: //insert an entity

   4:  var   task1 = {

   5:         PartitionKey : 'myPartitionKey',

   6:         RowKey: '1',

   7:         Description: 'Row description',

   8:         DueDate: new Date(2011, 12, 14, 12)

   9:  };


  11: tableService.insertEntity('tasktable', task1, function(error){

  12:     if(!error){

  13:         // Entity inserted

  14:     }

  15: });


  • Query entities
   1: //query an entity

   2: var tableService = azure.createTableService();

   3: tableService.queryEntity('demotable', 'myPartitionKey', '1', function(error, serverEntity){

   4:     if(!error){

   5:         // Entity available in serverEntity variable

   6:     }

   7: });



  • azure-table-node:

It is a simplified Azure Table Storage client library for Node.js that supported:

  • creating, deleting and listing tables
  • creating, updating, querying and deleting entities
  • batch operation support
  • generating SAS (Shared Access Signature) and using it for authentication


Code samples below show how to use azure-table-node module to work with Azure Table Storage

  • Set Azure Storage credentials
   1: var azureTable = require('azure-table-node')


   3: //set azure storage credentials

   4: azureTable.setDefaultClient({

   5:     accountUrl: 'http://[accountName].table.core.windows.net/',

   6:     accountName: '[accountName]',

   7:     accountKey: '[accountKey]'

   8: });


  • Create an Azure Table
   1: //create azure table

   2: app.get("/createTable", function (req, res) {


   4:     var client = azureTable.getDefaultClient();

   5:     client.createTable('testtable', function (err, data) {

   6:     });


   8:     client.insertEntity('testtable', {

   9:         PartitionKey: 'tests',

  10:         RowKey: '1',

  11:         value1: 'ABCDEFG'

  12:     }, function (err, data) {

  13:         res.write("Got error 😦 " + err);

  14:     });


  16:     res.end("Table created.");

  17: });


  • Display an Azure Table
   1: //display an azure table

   2: app.get("/displayTable", function (req, res) {


   4:     var client = azureTable.getDefaultClient();


   6:     client.queryEntities('testtable', {

   7:         query: azureTable.Query.create('PartitionKey', '==', 'tests') 


   9:     }, function (err, data, continuation) {

  10:         if (err) {

  11:             res.writeHead(500, { 'Content-Type': 'text/plain' });

  12:             res.write("Got error 😦 " + err);

  13:             res.end("");

  14:             return;

  15:         }


  17:         var json = JSON.stringify(data);

  18:         res.writeHead(200, { 'Content-Type': 'text/plain' })


  20:         res.end("Table displayed: " + json);

  21:        });


  23: });



  • List  all Azure Tables
   1: //list all azure tables

   2: app.get("/listTables", function (req, res) {    


   4:     var client = azureTable.getDefaultClient();


   6:     client.listTables(function (err, data, continuation) {

   7:         if (err) {

   8:             res.writeHead(500, { 'Content-Type': 'text/plain' });

   9:             res.write("Got error 😦 " + err);

  10:             res.end("");

  11:             return;

  12:         }


  14:         res.writeHead(200, { 'Content-Type': 'text/plain' })


  16:         for (var i = 0; i < data.length; i++) {

  17:             res.write("Table[" + i + "]: " + data[i] + " " );

  18:         }       


  20:         res.end("Tables listed." + data);

  21:     });


  23: });



  • Delete an Azure Table
   1: //delete azure table

   2: app.get("/deleteTable", function (req, res) {


   4:     var client = azureTable.getDefaultClient();

   5:     client.deleteTable('testtable', function (err, data) {

   6:     });

   7:     res.end("Table testtable has been deleted.");


   9: });



There’s so much more to learn about Azure Table services and Node.  The features and capabilities of table storage continue to grow. This post is just an intro how to start, covering the base cases and most popular Node.js modules for Azure Tables. It will be useful for both – JavaScript developers who don’t have experience with Microsoft Azure and Azure developers who have less experience with JavaScript and/or Node.js.

Developers on the Microsoft Azure Platform should become familiar with how Table Storage works and how it differs from the relational databases they are used to. Knowing how table storage works will help you determine if it is a good fit for your particular requirements.

My original post is published on Infragistics community blog .

You can download source code from Git repository .


If you want more information about how to use Microsoft Azure Storage  & Node.js feel free to contact me at mmateev@infragistics.com

You can learn more about Node.js , Microsoft Azure and related events like Azure Bootcamp Bulgaria if you follow us on Twitter @mihailmateev  and @Infragistics and stay in touch on Facebook, Google+, LinkedIn and Infragistics Friends User Group !

Posted in Azure, Azure NoSQL, Azure Storage, Azure Table Storage, Cloud, Cloud computing, Microsoft Azure, Microsoft Azure SDK for Node.js, Microsoft Azure SQL Database, Microsoft cloud, Node, Node.js, Node.js and Azure, NodeJS, NoSQL, Open Source Solutions in Microsoft Azure, Table Storage, Windows Azure | Leave a comment