Azure

Posts that relate to cloud computing with Azure

Introducing the Azure Key Vault

If you need to store secrets in the Azure cloud, such as connection strings, passwords, or even keys, the Key Vault may be for you. In this post I will provide an overview of the Azure Key Vault and discuss certain implementation details to help you determine if the Key Vault is for you. Service Overview The Azure Key Vault is a highly secured service allowing you to store sensitive information and even help you with compliance initiatives. The Azure Key Vault is designed to store secrets and keys, ......

Exploring Microsoft Azure DocumentDB

In this blog post, I will provide an introduction to DocumentDB by showing you how to create a collection (a collection is a container that stores your data), and how to connect to your collection to add and fetch data. DocumentDB is a newer no-sql data storage engine that is hosted in the Microsoft Azure cloud exclusively. Because DocumentDB stores records as JSON objects, it is a natural database engine for developers. Unlike other offerings however, it also offers key features such as automatic ......

HANDS-ON LAB: Emulating Devices for Azure IoT Hub with SQL Server

In this post, I will explain how you can easily simulate dozens (or hundreds) of IoT devices to test your Azure IoT Hub configuration. Simulating IoT devices with dynamic data can help you test your Azure IoT Hub configuration settings, along with downstream consumers such as Stream Analytics and Power BI reports. In order to facilitate the communication between SQL Server and an Azure IoT Hub, we will use Enzo Unified (http://www.enzounified.com) which abstracts the underlying cloud APIs, allowing ......

Real-Time Data Aggregation

I had the privilege of being interviewed by Microsoft, on Channel 9, regarding real-time data aggregation from distributed heterogeneous data sources, using the platform my company has created (Enzo Unified). This video introduces you to Enzo Unified, and shows how to easily merge data from from multiple sources, and create simple solutions that remove the complexities of APIs and traditional ETL data staging. You can find the video here: https://channel9.msdn.com/S... Thank ......

Windows 10 Core and Azure IoT Hub

I recently had the opportunity to follow an IoT Lab following the instructions provided in the Nightlight workshop, as found here: http://thinglabs.io/worksho... No need to say, I jumped on the opportunity to learn about Windows 10 Core and have some fun with direct Azure integration with live Power BI reporting in the backend. You will need the Azure IoT kit in order to go through this lab: https://www.adafruit.com/pr... – it costs a bit over $100; money well spent! In the ......

Managing Multiple SQL Servers

If you deal with SQL Server on a regular basis, or if you are a DBA dealing with production databases, you are most likely using a monitoring tool to gather performance statistics and receive alerts. However when it comes to performing real-time analysis, such as finding out which databases are low in log space, querying all your error logs to search for a specific event, or even to find out which databases contain a specific stored procedure or column name, it can get a bit tricky. Most DBAs will ......

Accessing SharePoint Online Data Directly From SQL Server and REST

If you have ever worked with SharePoint, either on premises or online, and ever needed to fetch records or manage Lists programmatically, you know how hard of a task this can be. Learning the SharePoint API presents a significant learning curve even for senior developers. In this post, you will see how you can interact with SharePoint Online using simple SQL statements or simple REST commands, and how you can tap into SharePoint directly from within SQL Server (such as triggers, views, and functions). ......

Accessing No-SQL data from SQL Server 2016 and R Services

In this post, I will show how to easily extend SQL Server 2016 R Services to consume No-SQL data in real-time, such as Azure Tables. This example could easily be modified to access other No-SQL services such as Couchbase for example. As you may know, SQL Server 2016 (currently in Release Candidate 1) now offers the ability to call an R service for statistical analysis using an SQL statement. What is interesting is that you can execute an R script (that contains the statistical computation) directly ......

Azure Roadshow for IT Pros in Florida

Hi – this is HUGE!!! Microsoft (Blain Barton) is planning a roadshow in Florida starting in March 2013 until June 2013. We will visit many cities (twice), so if you haven’t signed up yet, now is the time! Space is running short already! I will be one of the presenters at most of the locations, along with Adnan Cartwright, MVP, (http://www.fisg.us/). We will talk IaaS (Infrastructure as a Service) in Microsoft Azure, so don’t miss out! Here are some key links for you: http://aka.ms/blainbarton http://aka.ms/msproducts ......

Developers, Get Ready for Windows 10

The wave of Windows 10 development has already started. With many cool features, and the Universal Windows Platform (with APIs that are guaranteed to be present on all devices running Windows 10), you can start your engines and kick the tires! Here are a few resources you may find useful: Visual Studio 2015 Download: https://www.visualstudio.co... Here is an overview of what’s new with Windows 10 for developers: https://dev.windows.com/en-... ......

Full Azure Archive