April 2017 - Posts

• Data Juice

  The data ecosystem explained in 10 simple images Couple of weeks ago I was explaining how IoT and BigData can be a game changer in sports and human activities. Yeah, it’s cool to put a sensor in your own grill so that it can automatically tell you the Read More... Posted Tuesday, April 25, 2017 10:07 PM by Davide Mauri | 13 Comments Filed under: Data Warehouse, Data Lake, Data Science, Data Juice, Data Mart

• 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 | 15 Comments Filed under: SQL Server, PASS, JSON, SQL Server 2016, Azure SQL, Development, Microsoft Data Platform, AppDev

• For the Better Developer: Notes

  I want to be clear about the target and the scope of the “For the Better Developer” series. The articles doesn’t want to be 100% precise, but the aim is to give you, the developer, who understand how important in today work is the ability to manipulate Read More... Posted Sunday, April 2, 2017 5:40 AM by Davide Mauri | 1 Comments Filed under: For The Better Developer

• Know your data(base), or Introduction to the “For the Better Developer” series

  After 15 years in Database Performance Tuning, Database Optimization, Data Modeling, Business Intelligence, Data Warehousing, Data Analytics, Data Science, Data Whatever, I’m back in the development space , where I lived also for the first 10 years of Read More... Posted Sunday, April 2, 2017 5:37 AM by Davide Mauri | 7 Comments Filed under: For The Better Developer

• For The Better Developer: SQL Server Indexes

  Indexes? Indexes are a key factor for a database, relational or not. Without indexes the only option for a database would be to read all the data and discard what is not needed. Very inefficient. If a query has a where or a join or a group by clause and Read More... Posted Sunday, April 2, 2017 5:25 AM by Davide Mauri | 8 Comments Filed under: Indexes, SQL Server 2016, For The Better Developer