SQL Server

Official Documentation




Latest Content

Subscribe to News about SQL Server

Title  
Blog
Blog
Blog
Blog
Blog
Blog
Blog
Blog
Video
Blog
Blog
Blog
more...


Azure Documentation

Online Training Content

Date Title
5/24/2017 Orchestrating Big Data with Azure Data Factory
5/24/2017 Provisioning SQL Server and Azure SQL Databases
9/30/2016 Migrating SQL Server Databases to Azure
1/19/2016 Design and Implement Cloud Data Platform Solutions
7/16/2015 Getting Started with Azure Security for the IT Professional
6/4/2015 Platform for Hybrid Cloud with SQL Server 2014 Jump Start
5/4/2015 Windows Azure Pack: Database as a Service (DBaaS)
4/18/2015 Querying with Transact-SQL
8/22/2014 Hybrid Cloud Workloads SQL
8/22/2014 Hybrid Cloud Workloads SQL

Page 1 of 2

Tools

Tool Description
Enable diagnostics and OMS on Azure SQL DB DescriptionThis PowerShell automation runbook enables diagnostics on a SQL Database and forward logs to OMS. The script can enable multiple SQL Servers at once and multiple SQL Databases - but also with the possibility to enable single items. 
Microsoft Data Migration Assistant Data Migration Assistant (DMA) delivers scenarios that reduce the effort to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality after an upgrade. It recommends performance and reliability improvements for your target environment. DMA replaces SQL Server Upgrade Advisor.
Azure Feature Pack for Integration Services (SSIS) SQL Server Integration Services (SSIS) Feature Pack for Azure for SQL Server 2016 is an extension that provides the following components for SSIS to connect to Azure, transfer data between Azure and on-premises data sources, and process data stored in Azure.
Virtual Machine Optimization Assessment Tool The free Virtual Machine Optimization Tool automatically inspects SQL Server, Active Directory, and SharePoint deployments and provides a detailed set of prioritized recommendations and step-by-step instructions for improvement. Aimed especially at IT pros, this tool is a companion to the Virtual Machine Readiness Assessment Tool.
SQL Database Migration Wizard SQL Database Migration Wizard (SQLAzureMW) is designed to help you migrate your SQL Server 2005/2008/2012/2014 databases to Azure SQL Database.

Videos

Date Title Length
10/17/2017 Introducing the new Import Flat File Wizard in SSMS 17.3 0:11:29
9/30/2017 Keep your data in sync between SQL Server and Azure SQL Database 1:22:04
9/30/2017 Building a better data solution: Microsoft SQL Server and Azure Data Services 0:40:38
9/30/2017 Deep dive into SQL Server Integration Services (SSIS) 2017 and beyond 1:25:20
9/30/2017 Microsoft makes artificial intelligence real 0:19:37
9/29/2017 Running tier 1 workloads on SQL Server on Microsoft Azure Virtual Machines 1:13:30
9/29/2017 DirectQuery in Analysis Services: Best practices, performance, use cases 1:15:18
9/29/2017 Maximum availability and extreme read scale-out with Microsoft SQL Server 2017 1:19:25
9/29/2017 SQL Server Data Warehouse reference architectures 0:46:57
9/29/2017 Cert Exam Prep: Exam 70-764: Administering a SQL Database Infrastructure 1:16:02

Page 1 of 21