Are You Ready for Microsoft SQL Server 2016?
Are you ready to explore Microsoft SQL Server 2016? In this white paper we will examine three key new features that show how SQL Server 2016 provides automatic end-to-end security, seamless generation
Topic: Data & SQL
38 article(s)
Azure Data Lake Analytics – U-SQL
Azure Data Lake Analytics (U-SQL) originates from the world of Big Data, in which data is processed in a scale-out manner by using multiple nodes. These nodes can access the data in several formats, f
Azure Databases
A persistent data store is at the heart of many applications. As you migrate existing applications to the Azure cloud or create new applications, you will likely find yourself needing to interact with
Azure SQL DB - Technical deployment
This document is a step by step guide to creating an Azure SQL DB within the context of an Azure Cloud Solution Provider (CSP) subscription for a customer by the CSP reseller. The purpose is to help s
Building an Application with C#, Cosmos DB, a NoSQL Document Database, and the SQL API
In this chapter, we will use Cosmos DB, the .NET Core SDK, the SQL API, and C# to code our first Cosmos DB application. We will focus on learning about many important aspects related to the SDK in ord
Building High Performance Infrastructure For Databases
Databases drive 60% of the applications in most companies. So, the performance of databases is extremely important to an organization's ability to process transactions as well as analyze data. Recentl
Getting SQL DW table size
During a typical DM Jumpstart POC, one of the key tasks that an architect must execute is getting metrics about the new environment post-migration: collect load times from on-premises to cloud, collec
Getting Started with CosmosDB Development and NoSQL Document Databases
In this chapter, we will provision a Cosmos DB account that uses the SQL API and we will start working with a document database, its collections, and documents. We will work with Cosmos DB on Azure an
Getting Started with SQL Server Graph
The concept of storing data in a graph structure is not new. Generally speaking, the data in graph databases is not stored in a relational structure, so storing graph data in SQL Server therefore requ
Introduction to Amazon Relational Database Service (Amazon RDS)
Database Management Systems (DBMS) are an integral part of almost every large-scale software system. DBMS are large, complex software suites that not only store and retrieve data, but also secure the
Introduction to NoSQL in Cosmos DB
In this chapter, we will start our journey toward developing applications that work with a globally distributed, massively scalable, and multi-model database service provided by Microsoft: Azure Cosmo
Migrating from Teradata to Azure SQL Data Warehouse
This document gives insight into how to approach a Teradata to Azure SQL Data Warehouse migration. This whitepaper is broken into sections which detail the migration phases, the preparation required f