SQL Server 2016 Exploring Contained Databases
Microsoft SQL Server is an enterprise class relational database management platform and is an integral and indispensable component in most computing environment today with a significant application ec
Topic: Data & SQL
38 article(s)
SQL Server 2016 Highly Efficient and Performant Database
Typical SQL Server relational database implementations that need to support mission critical workloads need to implement high availability (HA) and disaster recovery (DR) strategies with demanding hig
Hybrid Hyperscale using SQL Server 2016
One of the major trends in the last few years has been a huge explosion in amount of data being generated by OLTP systems often coupled with the need to retain ever longer durations of historical data
Reference Architecture for SQL Server 2016 In-Memory Columnstore
The Microsoft in-memory columnstore technology provides hosting service providers the opportunity to support following key business scenarios:
Reference Architecture for SQL Server 2016 In-Memory OLTP
The Microsoft In-memory OLTP technology provides hosting service providers the opportunity to support following key business scenarios:
Secure Database using SQL Server 2016
Over the last few years there has been a huge focus on data security in light of increasingly high profile data breaches and security incidents. This had led to customers adopting increasingly rigorou
Deployment Guide for SQL Server 2016 In-Memory OLTP and In-Memory Columnstore
In-Memory was introduced in SQL Server 2014. SQL Server 2016 is continuing the investment in In-memory OLTP by removing many of the limitations found in SQL Server 2014, and enhancing internal process
SQL Server 2016 Real-Time Operational Analytics - Deployment Guide
Traditionally, businesses have had separate systems for operational (i.e. OLTP) and analytics workloads. For such systems, Extract, Transform, and Load (ETL) jobs regularly move the data from the oper
SQL Server 2016 Real-Time Operational Analytics - Reference Architecture
The Real-Time Operational Analytics feature provides hosting service providers the opportunity to support a key business scenario:
Tuning and Managing Scalability with Cosmos DB
In this chapter, we will analyze many aspects that allow us to design and maintain scalable architectures with Cosmos DB. We will use our sample application to understand how many important things wor
U-SQL - Performance optimization
This document provides details of some points to consider for performance optimization of U-SQL tables and the queries running against them.
Whitepaper for Azure SQL Database in CSP leveraging Analytics Solutions
The Microsoft Cloud Solution Provider (CSP) program enables partners to sell Microsoft Online services to customers with additional value added services like assessment, consulting, deployment, migrat