Microsoft R Server 9.0.1 is Packed with Exciting New Capabilities

Microsoft R Server has just released a feature-packed version 9.0.1. Customers can download from MSDN from this link. Enterprise customers with EA agreement will be able to download from Microsoft Volume Licensing Software Center in January 2017. There are major enhancements and brand new face lifts in some of the capabilities in Microsoft R Server that worth mentioning: –…


Lesson Learned #11: Connect from Azure SQL DB using an external table where the source of the data is a SQL Datawarehouse

One of our customer tries to connect from Azure SQL DB using an external table where the source of the data is a SQL Datawarehouse database. This first question was if there is supported or not and I received the confirmation from Azure Product Team that there is not supported and they are working on…


Lesson Learned #10: Monitoring TempDB usage

We are receiving several support cases when our customers are getting the following error message “The database ‘TEMPDB’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.” and their query ends with an exception. As any SQL Server instance every Azure SQL Database Tier has a…


Lesson Learned #9: sp_execute_fanout was deprecated and replaced by sp_execute_remote

Within Cross-Database Queries we have the option to run a procedure using parameters using sp_execute_fanout. This execution could be a Transact-SQL statement on a single remote Azure SQL Database or set of databases serving as shards in a horizontal partitioning scheme. From time ago, if you try to execute sp_execute_fanout you will have an error that this…


Data Exploration in XDF Files using ScaleR Functions

In this article, let us see few examples to explore data in XDF Files using ScaleR functions. For all the following examples, we will be using input XDF file AirlineDemoSmall.xdf from the SampleData Directory in Microsoft R Server. 1. Obtain the different types of variables present in the dataset OUTPUT :       2….


Public Readiness for Dynamics 365 for Operations

Hi all, Please find below all public information related to Dynamics 365 for Operations.  [last update 15/06/2017] Product information Roadmap and Update Policy Service Level Agreement Dynamics 365 Documentations and public Wiki site Product availability white paper, Localization portal and Localization per countries Trust Center for Dynamics 365: compliance, security, Privacy and transparency. Experience Dynamics 365 Support…


Hardware Dev Center Dashboard に関するサポートについて

Windows ハードウェア互換性プログラムでは、プログラムに関連する各ハードウェア申請の新しいポータルサイトとして、Hardware Developer Center Dashboard (Hardware Dev Center) をこの度設立いたしました。 Hardware Developer Center Dashboard へのアクセスは、以下のサイトから可能となります。     URL: https://developer.microsoft.com/dashboard/hardware   また、Hardware Dev Center の紹介ページでは、2016 年 11 月 10 日 をもちまして、HLK のテスト結果を基にしたハードウェア ダッシュボードへの申請は Hardware Dev Center を利用する必要がある旨のご案内をしております。   前回のエントリ「Windows ハードウェア互換性プログラムに関するサポート連絡先について」では、Sysdev Dashboard を含めた、ハードウェア互換性プログラム関連のお問い合わせ先に関するご案内をしましたが、Hardware Dev Center の設立に伴い、新たなサポート窓口が開始されましたことをご報告いたします。   どのようなお問い合わせを受け付けるのか? Hardware Dev Center Dashboard に関するお問い合わせは、カスタマー サービス アンド サポート部門 (CSS) の、Dev…


SQL 2016 – Temporal Tables – Can you change the schema?

I was recently asked if after you setup a Temporal Table, can you modify the schema?  It was a great question because if you cannot change the schema, then you would have to drop and recreate the table every time you need to change the schema which means you would potentially lose all the history. …


BACPAC Export failing with Unable to reconnect – Timeout expired

I had a support case recently where the export of a SQL Server database into a BACPAC file was failing. The first attempt was done through SQL Server Management Studio 2016, by right-clicking the database -> Tasks -> Export Data-Tier Application. Another attempt using the sqlpackage.exe command-line tool showed the identical results though. The following operations…


Azure Support Academy (Spanish): SQL Server, Next Station Azure

Welcome to our session delivered in 24Hours Pass Virtual Chapter – Global Spanish, covering the main aspects to start or migrate from an OnPremise model  to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment  for our requirements. Watch:  SQL Server, Next Station Azure We covered: Red…