Browse by Tags

• 2016
• Apache Zeppelin
• AppDev
• Azure
• Azure DW
• Azure Functions
• Big Data
• Dapper
• Data Exploration
• Data Visualization
• Development
• ElasticSearch
• JSON
• Microsoft Data Platform
• NoSQL
• PASS
• SQL Azure
• SQL Server
• SQL Server 2016
• Temporal Data
• Temporal Tables
• vNext

• Azure SQL: work with JSON files where they are

  Dealing with CSV or JSON data today is more and more common. I do it on daily basis, since the our application send data to our microservice gateway backend is in a (compressed) JSON format. Sometimes, especially when debugging or developing a new feature, Read More... Posted Monday, August 7, 2017 9:10 AM by Davide Mauri | 18 Comments Filed under: JSON, SQL Azure, Azure SQL

• From ElasticSearch back to SQL Server

  Sharing with the community why we decided to move back from ElasticSearch to SQL Server Sometimes it happens: you move to something that is considered cool and bleeding edge back to something that has dust over it. Well, at least this is how SQL Server Read More... Posted Wednesday, May 24, 2017 3:01 AM by Davide Mauri | 11 Comments Filed under: SQL Server, NoSQL, JSON, SQL Server 2016, Azure SQL, ElasticSearch

• PASS AppDev Recording: “Building REST API with SQL Server using JSON functions”

  Last week Jovan Popovic (SQL Server Program Manager for JSON support and other nice things) delivered a very interesting webinar on JSON and SQL Server / Azure SQL for the PASS Application Development Virtual Group. If you’re interested in the subject, Read More... Posted Monday, May 1, 2017 5:44 AM by Davide Mauri | 234 Comments Filed under: SQL Server, PASS, JSON, SQL Azure, SQL Server 2016, Azure SQL, Development, AppDev

• PASS Application Development Virtual Group

  I've been involved with PASS, once named Professional Association of SQL Server users, now just... PASS , since 2006 when I stepped up as president of SQL Server Italian User Group. Now that I moved to Redmond, WA, I'm still involved with it, but of course, Read More... Posted Wednesday, April 12, 2017 4:45 AM by Davide Mauri | 17 Comments Filed under: SQL Server, PASS, JSON, SQL Server 2016, Azure SQL, Development, Microsoft Data Platform, AppDev

• Speaking at the SQL Server Seattle User Group in April

  I’m happy to share that I’ll be speaking at the next SQL Server Seattle User Group meeting on April 13th. The topic is again Temporal Tables a subject I love a lot and that is 100% useful in possible roles: dev, dba or bi guy. Temporal Tables with SQL Read More... Posted Saturday, March 25, 2017 5:09 AM by Davide Mauri | 4 Comments Filed under: Temporal Data, 2016, SQL Azure, Temporal Tables, SQL Server 2016, Azure SQL, vNext

• Azure Functions, Dapper and SQL Server JSON to store form data

  A common problem Recently we had to setup a couple of contact form pages to allow users to register to the App 2.0 Beta program ( now RTM ) or to tell us which of the products we launched at CES 2017 they are interested into. Such kind of request are Read More... Posted Sunday, February 5, 2017 7:01 PM by Davide Mauri | 16 Comments Filed under: JSON, Azure Functions, Azure SQL, Dapper

• Run Apache Zeppelin 0.6.2 for SQL Server

  As promised in my last post here is the first post that aim to show how to use Apache Zeppelin with SQL Server. First thing first: installation. Or maybe not. The first thing to do, usually, is installing the product. Since we’re talking Java here, things Read More... Posted Monday, December 5, 2016 10:57 PM by Davide Mauri | 10 Comments Filed under: SQL Server, Azure, Big Data, SQL Azure, Data Exploration, Apache Zeppelin, Azure DW, Data Visualization, Azure SQL