Opinions, tips, and news orbiting Microsoft
First published on MSDN on Oct 16, 2017
Authored by Arvind Shyamsundar (Microsoft)
Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the
Sayint
by
Zen3
team)… Continue reading Performance implications of using multi-Statement TVFs with optional parameters
First published on MSDN on Oct 06, 2017
Authored by Kun Cheng
Reviewed by: Dimitri Furman, John Hoang, Mike Weiner, Rajesh Setlem
Most people familiar with Azure SQL DB (aka SQL Database) are aware o… Continue reading Secure your on-premises network outbound connection to Azure SQL Database by locking down target IP addresses
First published on MSDN on Oct 03, 2017
SQL 2017 bits are generally available to customers today. One of the most notable milestones in the 2017 release is SQL Server on Linux. Setup has been relatively simple for SQL Server on Linux, … Continue reading Unattended install and configuration for SQL Server 2017 on Linux
First published on MSDN on Sep 19, 2017
Authored by Rangarajan Srirangam
Authors: Rangarajan Srirangam, Mandar Inamdar, John Hoang
Reviewers: Murshed Zaman, Sanjay Mishra, Dimitri Furman, Mike Weiner, Kun Chen… Continue reading Enterprise Data Pipelines using Azure PaaS Services – An Introduction
First published on MSDN on Sep 11, 2017
Reviewed by: John Hoang, Denzil Ribeiro, Rajesh Setlem, Mike Weiner
Introduction
Instant File Initialization (IFI) is a well-known feature of SQL Server, providing signifi… Continue reading Instant Log Initialization for SQL Server in Azure
First published on MSDN on Sep 05, 2017
Authored by John Hoang
Author: John Hoang
Technical Reviewers: Dimitri Furman, Murshed Zaman, Sanjay Mishra
Overview
Thi… Continue reading Common ISV application patterns using Azure SQL Data Warehouse
First published on MSDN on Sep 05, 2017
Authored by Murshed Zaman
Reviewed by: John Hoang, Dimitri Furman, Mike Weiner, Sanjay Mishra
We often get questions from customers related to Azure SQL DW bei… Continue reading Azure SQL Data Warehouse Workload Patterns and Anti-Patterns
First published on MSDN on Aug 11, 2017
Reviewed by:
Suresh Kandoth,Rajesh Setlem, Steven Schneider, Mike Weiner, Dimitri Furman
When analyzing SQL Server performance related issues, c… Continue reading Collecting performance data with PSSDIAG for SQL Server on Linux