Click here to monitor SSC
Robert Sheldon

Using SSIS to Load Data Into Azure SQL Data Warehouse

It is a good time to get familiar with Azure SQL Data Warehouse. The first objective must be to get data into it. SSIS is a good way to start, and it’s certainly worth gaining confidence with the ETL processes supported by SSIS before setting off in other directions. Rob Sheldon provides a simple guide to getting up and running. Read more...

Robert Sheldon

Taking Azure SQL Data Warehouse for a Test-Drive

Azure SQL Data Warehouse uses SQL to query the data, but there are some differences to SQL Server's dialect of TSQL, and queries don't necessarily work in the same way. DBAs are also required to use SSDT to access Azure SQL Data Warehouse. It is worth taking the time to try the preview of the product, and take it for a 'spin around the block', following Robert Sheldon's walk-through. Read more...

Robert Sheldon

Connecting to SQL Data Warehouse

The most frustrating thing with any new system is often just working out how to connect to it. Oddly, you can’t use SSMS with SQL Data Warehouse, but it is fine with SSDT, SSIS, Power BI desktop, sqlcmd, BCP, and a range of Microsoft cloud services - there are PowerShell Cmdlets too. Rob Sheldon provides the details. Read more...

Robert Sheldon

Getting started with Azure SQL Data Warehouse

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running. Read more...

Adam Bertram

Comparing Networking Options in Azure

What are your options for connecting to an Azure VM? Sure, a Remote Desktop Protocol (RDP) connection will get you started but you'll soon need a full secure VPN connection. Azure can provide three different options for doing this: Point-to-Site (P2S), Site-to-Site (S2S), and ExpressRoute, but what are their relative advantages, and which one is right for the way you need to use Azure? Read more...

Robert Sheldon

In Search of the Cortana Analytics Suite

Cortana Analytics Suite is important and significant, but it is difficult to work out why or how from the existing 'information'. After more setbacks than Dr Livingstone, Bob Sheldon emerged from the jungle of marketing hyperbole triumphantly with a small diagram which explained it. Here he reveals the individual components, and finds them, in combination, to be a curiously interesting attempt to bring Big Data under control Read more...

Robert Sheldon

Azure SQL Data Warehouse

Azure SQL Data Warehouse is a fully-managed and scalable cloud service. It is still in preview, but solid. Not only is it compatible with several other Azure offerings, such as Machine Learning and Data Factory, but also with various existing SQL Server tools and Microsoft products. It talks Power BI. Are we now seeing the final piece of the Azure jigsaw fall into place? Read more...

Christos Matskas

Using Azure KeyVault with Node.js

Some of the most intractable problems of application design are concerned with how to store credentials for accessing sensitive application data, keys and, configuration settings in code. With Azure Key Vault you don't have to. You can, instead just authorise an application to access and use a Key Vault and perform operations that require authentication against a KeyVault. Christos Matskas shows how an application can interact with the service, using a node.JS application as an example. Read more...

Adam Bertram

How to Build and Deploy Azure IaaS VMs with PowerShell

The whole point of using a cloud service is to be able to use it intensively for a brief period just when it is needed and then clear out all your work when you've finished. This means automation to make the process as quick and easy as possible. It is likely to mean creating a VM, provisioning it from scratch and spinning it up using PowerShell. Relax, grab the popcorn, and let Adam Bertram show you how he does it in Azure. Read more...

Christos Matskas

Setting Up and Configuring an Azure Key Vault

No longer do developers need to store sensitive application data, keys and, configuration settings in code - Azure Key Vault can store them for our applications on the cloud. Christos Matskas shows how to provision a new Key Vault in Azure using the Azure PowerShell cmdlets, and how to authorise an application to access and use a Key Vault. Read more...

Christos Matskas

Application Security with Azure Key Vault

The name 'Azure Key Vault' hides a valuable Azure service that allows us to easily protect our Cloud data by putting sound cryptography in Cloud applications without having to store or manage the keys or secrets. This makes it far easier to manage cloud data in applications in a way that that complies with industry-standards for sensitive data. Read more...

Robert Sheldon

Azure DocumentDB Server-Side Scripting

DocumentDB only uses SQL for querying data. To create procedures and functions, you have to flex your JavaScript skills to create JavaScript functions that are saved to a DocumentDB collection. Robert Sheldon shows how it is done. Read more...

Robert Sheldon

Microsoft Azure DocumentDB

DocumentDB is a late-entrant in the Document-oriented database field. However, it benefits from being designed from the start as a cloud service with a SQL-like language. It is intended for mobile and web applications. Its JSON document-notation is compatible with the integrated JavaScript language that drives its multi-document transaction processing via stored procedures, triggers and UDFs. Read more...

Robert Sheldon

Azure Data Lakes

The Data Lake is basically a large repository of data for 'big data' analytic workloads, held in its original format. The Azure Data Lake adds Data Lake Analytics, and Azure HDInsight. Although the tools are there for Big Data Analysis, it will require new skills to use, and a heightened attention to Data Governance if it is to appeal to the average enterprise. Read more...

Robert Sheldon

The Logical Data Warehouse - Towards a Single View of All the Data

What is wrong with the Enterprise Data Warehouse? Quite a lot, it seems. By taking the narrow view that the struggle is that of accommodating and interrogating huge quantities of data, then initiatives such as the Virtual Data Warehouse and Logical Data Warehouse could make sense. But what about data quality, security, access control, archiving, retention, privacy and regulatory compliance? Read more...

Matt Milner

Azure BizTalk Services: Monitoring and Managing BizTalk Services Solutions

Once you've built your BizTalk solution, you will need to deploy and monitor it. Matt Milner shows that, while there are several ways to monitor your solution, and manual deployment via Visual Studio, the automated deployment of BizTalk solutions is probably best served by Azure IaaS with BizTalk Server virtual machines. Read more...

Krishna Kumar

Creating and Managing Docker VM Extensions in Azure

Docker technology is Linux-based. Although the concept of a container isn't new, the common toolset, packaging model and deployment mechanism of Docker has made the use of containers far simpler. As a quick introduction to the technology for Windows users, Krishna shows, step by step, how to set up, and configure a Docker Daemon in Azure within a VM, and install a MySQL image in a container from the Docker Repository. Read more...

Matt Milner

Azure BizTalk Services: Connecting to On-Premises Resources

By moving applications to Azure, you can't always avoid the requirement for accessing data from applications that are based within your intranet. You have a wide range of choices for doing this. Matt Milner explains that there are several technologies that can achieve this for BizTalk, but that will apply more generally. Read more...

Robert Sheldon

OpenStack: The Good and Not-So-Good Bits

OpenStack holds a great deal of promise as a cloud platform built on open standards, and has support from the major players in cloud services. It has the potential for allowing organisations to set up their own private cloud services that are designed to inter-operate. Is it ready yet for companies that want the convenience of cloud solutions, but with more control, and without the large subscription fees? Robert Sheldon finds out. Read more...

Matt Milner

Azure BizTalk Services: EDI

The Electronic Data Interchange has been around a long time. Azure BizTalk Services supports this important protocol for transmitting business transactions, and it is reasonably easy to set up, as Matt Milner explains Read more...

Most Viewed

Windows Azure Virtual Machine: A look at Windows Azure IaaS Offerings (Part 2)
 We continue our introduction of the Azure IaaS by discussing how images and disks are used in the Azure... Read more...

An Introduction to Windows Azure BLOB Storage
 Azure BLOB storage is persistent Cloud data storage that serves a variety of purposes. Mike Wood shows... Read more...

An Introduction to Windows Azure Table Storage
 Windows Azure Tables are intended for the storage of large amounts of schemaless data. Tables are just... Read more...

Windows Azure Management Certificates
 Although Windows Azure can be used from the portal, it comes into its own once provisioning,... Read more...

An Introduction to Windows Azure Service Bus Brokered Messaging
 As applications grow, a message queue system soon becomes the best way of achieving scalability. It is... Read more...