Distributed Availability Groups extended

SQL Server 2016 supports distributed availability groups (AG) as additional HA feature of the engine. Today we want to show how this feature can be used to transfer near-real-time productive data around the globe. Based on Jürgens Blog about SQL Server 2016 Distributed Availability Groups we set up a Primary AG with the SAP Database (e.g….


Install SQL Server 2017 Using PowerShell Desired State Configuration

How many times have you clicked through the SQL Server installation interface just clicking the same old buttons, entering the same old information, not giving it much of a second thought? Then the installation finishes and the realization of “I forgot to specify the DBA group in the sysadmins role” hits. Now you have to…


SQL Updates Newsletter – September 2017

Recent Releases and Announcements At Microsoft Ignite, we showcased our work in quantum computing. Watch the Keynote here (quantum computing is discussed ~1hr mark): https://myignite.microsoft.com/sessions/59125 In just hours or days, a quantum computer can solve complex problems that would otherwise take billions of years for classical computing to solve. Microsoft will release a new quantum…


Backup and Restore Strategy for Dynamics AX

Your organization’s deployment of Dynamics AX is going to be one of the most important applications in your enterprise (if not, it is the most important application).  It is absolutely critical to the health of your business that a sound backup and restore strategy is in place for your implementation of Dynamics AX. Ensure that…


Enterprise Data Pipelines using Azure PaaS Services – An Introduction

Authors: Rangarajan Srirangam, Mandar Inamdar, John Hoang Reviewers: Murshed Zaman, Sanjay Mishra, Dimitri Furman, Mike Weiner, Kun Cheng Overview You might have worked with enterprise data pipelines using the SQL Server suite of products on-premises, or using virtual machines in the cloud. Now, you can build a similar enterprise data pipeline on Azure, comprised purely…


Instant Log Initialization for SQL Server in Azure

Reviewed by: John Hoang, Denzil Ribeiro, Rajesh Setlem, Mike Weiner Introduction Instant File Initialization (IFI) is a well-known feature of SQL Server, providing significant performance improvement for operations that require an increase in the size of data files, such as database creation, restore, and file growth. Without IFI enabled, zeroes have to be written into…


Early technical preview of JDBC 6.3.2 for SQL Server released!

We are excited to release a new early technical preview of the JDBC Driver for SQL Server.  Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added new connection property: sslProtocol #422 Added “slow” tag to…


SQL Updates Newsletter – August 2017

Recent Releases and Announcements Our immediate response to Hurricane Harvey https://blogs.microsoft.com/blog/2017/08/29/immediate-response-hurricane-harvey/ Power BI Report Server August 2017 Preview now available https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-august-2017-preview-now-available/ Cumulative Update #7 for SQL Server 2014 SP2 https://support.microsoft.com/en-us/help/4032541/cumulative-update-7-for-sql-server-2014-sp2 SQL Server 2017 Release Candidate 2 (RC2) is now available https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/02/sql-server-2017-release-candidate-2-rc2-is-now-available/ Cumulative Update #4 for SQL Server 2016 SP1 Cumulative Update 4 (CU4) for Microsoft SQL Server 2016 Service Pack…


Visual Studio 2017 で Python 環境を構成し、SQL Server 、 Azure Data Services(Azure SQL Database 、 Cognitive Services 等 ) にアクセスしてみよう

Microsoft Japan Data Platform Tech Sales Team 清水 みなさん、こんにちは。以前の投稿では、 Visual Studio 2015 で Python 環境を構成しましたが、今回は、 Visual Studio 2017 で Python 環境を構成し、 SQL Server  、 Azure Data Services(Azure SQL Database 、 Cognitive Services 等 ) にアクセスする際の手順、ポイントをお伝えします。