Using SQLPackage to import or export SQL Server and Azure SQL DB

Purpose: Explain how to easily and quickly use SQLPackage to import or export your SQL Server and Azure SQL Database. Locating the SQLPackage.exe: The SQLPackage.exe is part of the DacFramework which installed with SSMS or with SQL Server Data Tools Or you can download only the DacFramework if you do not have already the management…


How to unconfigure TFS vNext Build Agent Service

There may be times when you need to unconfigure, or remove a build agent configured as a service  TFS 2015 and above and there are a few steps missing from the online documentation. UNCONFIGURE AGENT for TFS 2017 and Above: Open a command prompt in admin mode and navigate to the folder where the build…


Azure Analysis Services Preview -How to add security group

The information posted originally in this blog is now out-of-date due to change in the Azure products. Please open a new support case if you need help with adding security group in Azure Analysis Services. Security group now can be added in format obj:<objid>@<tenanted>  using SSMS or AMO.   Problem: You are not able to…


Understanding Joining

Update 1/19/2017 There are 3 ways to set up Join Logic for objects in the Connector Space of an MA to “Join” to objects in the Metaverse. 1st. Direct Join on the MA , configured on the MA within the properties and by selecting “Join and Projection”, yes this is the same section you would…


Automate SQL server backup file removal/deletion from Azure blob storage

  In this post, we would like to explain one of the interesting issues that we encountered while working with azure backups and restore. Symptoms Cannot delete the .bak files from azure blob storage through maintenance plans or any other options from SQL which have been backed up using backup to URL or managed backup….


Advanced PowerApps visualizations with dynamic SVG’s

PowerApps brings you lots of built-in controls and ways to visualize your data with just a few clicks. Sometimes, however, you might want to build custom visualizations that are not quite achievable with only those controls. This article shows one way in which you can create your own custom visualizations. In particular, we will create…


Recent SAP BW improvements for SQL Server

Over the course of the last few months we implemented several improvements in SAP BW. We already blogged about two improvements separately: https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/14/simplified-and-faster-sap-bw-process-chains https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/25/improved-sap-compression-tool-msscompress In this blog we want to describe a few, additional improvements BW query performance of F4-Help Some BW queries were not using intra-query parallelism, because the BW statement generator did not…


How to configure multiple Home Pages using GPO?

In this blog post, we are covering a few methods you could used to manage secondary home pages on your environment using Group policy objects. Applies to: IE running on Windows 10, Windows 2016, Windows 7, Windows 2008 R2, Windows 2012 R2 Requirement: To a local or domain administrator and be familiar with GPMC.MSC console…


Columnstore Index Performance: BatchMode Execution

In the blog Industry leading analtyics query performance,  we had looked into how SQL Server delivers superior analytics query performance with columnstore index. Besides significant reduction in IO, the analytics queries get order of magnitude better performance boost with BatchMode processing, a unique value proposition in SQL Server. The basic idea of batch mode processing is…