Thursday, June 22, 2017
 
Updates from SQL-CAT (Customer Advisory) Team @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

Performance impact of memory grants on data loads into Columnstore tables

Friday, June 02, 2017

Reviewed by: Dimitri Furman, Sanjay Mishra, Mike Weiner, Arvind Shyamsundar, Kun Cheng, Suresh Kandoth, John Hoang Background Some of the best practices when bulk inserting into a clustered Columnstore table are: Specifying a batch size close to 1048576 rows, or at least greater than 102400 rows, so that they land into compressed row groups directly.... Read more

Azure SQL Data Warehouse loading patterns and strategies

Wednesday, May 17, 2017

Authors: John Hoang, Joe Sack and Martin Lee Abstract This article provides an overview of the Microsoft Azure SQL Data Warehouse architecture. This platform-as-a service (PaaS) offering provides independent compute and storage scaling on demand. This document provides data loading guidelines for SQL Data Warehouse. Several common loading options are described, such as SSIS, BCP,... Read more

Build a recommendation system with the support for graph data in SQL Server 2017 and Azure SQL DB

Friday, April 21, 2017

Authored by Arvind Shyamsundar and Shreya Verma Reviewed by Dimitri Furman, Joe Sack, Sanjay Mishra, Denzil Ribeiro, Mike Weiner, Rajesh Setlem Graphs are a very common way to represent networks and relationships between objects. Historically, it is not easy to represent such data structures in relational databases like SQL Server and Azure SQL DB. To... Read more

Try and try again: not always a good idea (at least not for SSMS!)

Thursday, April 06, 2017

Contributions from, and reviewed by: Ken Van Hyning, David Shiflet, Charles Gagnon and Alan Ren (SSMS dev team), Dimitri Furman, Mike Weiner and Rajesh Setlem (SQLCAT) Background SQL Server Management Studio (SSMS) is the most popular client used to administer and work with SQL Server and Azure SQL DB. Internally, the SSMS code uses the... Read more

SQLCAT at SQLBits 2017

Thursday, March 30, 2017

The widely popular SQLBits conference will take place April 5-8 2017 in Telford, UK. Several SQLCAT team members will be presenting a number of breakout sessions. Our topics this year are SQL Server on Linux and Azure SQL Database. SQLCAT sessions are unique. We bring in real customer stories, and present their deployments, architectures, challenges,... Read more

Backing up a VLDB to Azure Blob Storage

Friday, March 10, 2017

Reviewed by: Pat Schaefer, Rajesh Setlem, Xiaochen Wu, Murshed Zaman All SQL Server versions starting from SQL Server 2012 SP1 CU2 support Backup to URL, which allows storing SQL Server backups in Azure Blob Storage. In SQL Server 2016, several improvements to Backup to URL were made, including the ability to use block blobs in... Read more

SQL Server Availability Groups in Azure VM setup with AAD Domain Services

Thursday, February 23, 2017

Reviewed by: Steven Schneider, Sanjay Mishra, Mike Weiner, Kun Cheng, Dimitri Furman, Arvind Shyamsundar, Mahesh Unnikrishnan, and Luis Carlos Vargas Herring Deploying SQL Server Availability Groups in Azure VMs typically involved provisioning two additional VMs to host an Active Directory Domain Controller. With Azure Active Directory (AAD) Domain Services (aka managed domain services on Azure), it... Read more

Migration from SQL Server to Azure SQL Database Using Transactional Replication

Friday, February 03, 2017

Written by: Josh Gnanayutham, Program Manager, SQL Engineering Introduction As users are increasingly moving their data to the Azure cloud, migration from SQL Server to Azure SQL Database is a common task. There are many migration methods and they each have their pros and cons. This blog post will explore how to migrate your database... Read more

How to Check Database Availability from the Application Tier

Sunday, January 29, 2017

Reviewed by: Mike Weiner, Murshed Zaman A fundamental part of ensuring application resiliency to failures is being able to tell if the application database(s) are available at any given point in time. Synthetic monitoring is the method often used to implement an overall application health check, which includes a database availability check. A synthetic application... Read more

Azure SQL DW: Moving to a different region with restore from backup option

Tuesday, December 20, 2016

Reviewers: Dimitri Furman, John Hoang, Mike Weiner, Denzil Ribeiro, Joe Yong Background: Azure SQL Data Warehouse service (SQL DW) uses a snapshot backup to back up your data at a regular (8 hour) interval. DBAs can use this backup to restore a SQL DW database into a new database in the same region, or to... Read more

HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM