[まとめ] SQL Server Japan Support Team Blog インデックス

★Welcome to Microsoft SQL Server Japan Support Team Blog ==================================== ■1. 一般情報 ◆a. SQL Server Update 情報 ◆b. DO’s&DONT’s やった方がいいこと やらない方がいいこと ◆c. How to系 ◆d. 若葉マークブログ ◆e. Known issue ◆f. SQL Connectivity ■2. SQL Serverエンジン ◆a. ツール ◆b 機能 ◆c. SQL トラブルシューティング ◆d. インストール/アップグレード/アンインストール ■3. SQL Database (Azure) ■4. Analysis Services ■5. Reporting Service ■6….


TableAdapter 構成ウィザードは、Oracle 固有の構文をサポートしていない

佐藤 靖典 SQL Developer Support Engineer   今回は、Visual Studio の TableAdapter 構成ウィザードで TableAadpter を生成できない事象について紹介します。   1. 事象 データソースとして Oracle を使用し、TableAdapter 構成ウィザードで特定のクエリを指定した場合、次のエラーなどにより TableAdapter の生成に失敗します。 クエリ テキストを解析できません。 Unable to parse query text.   現在までに、クエリで以下を使用した場合にエラーが発生することが報告されています。 SELECT ~ FOR UPDATE (+) を使用した外部結合 ROW_NUMBER 関数 “||” による文字列の連結   2. エラーが発生する理由 Visual Studio がクエリ構文解析のために使用しているクエリ パーサーが、Oracle 固有の構文をサポートしていません。また、大変恐れ入りますが、現時点で Oracle 固有の構文をサポートする予定はございません。   3. 対処案…


HDInsight:- Attach additional Azure storage accounts to the cluster

HDInsight supports a notion of the default file system. The default file system implies a default scheme and authority. It can also be used to resolve relative paths. During the HDInsight creation process, an Azure Storage account and a specific Azure Blob storage container from that account is designated as the default file system. In…


Get free hands-on experience with OMS Security and Compliance

Cloud has changed a lot of things, and many of them for the better. But one thing that I’ve heard, and experienced myself, is the frustrating experience of getting realistic hands on experience with some cloud service offerings. In the on-premises days we’d have an enduring lab environment that had dozens, maybe hundreds or even…


How to get Azure Log Information into your on-premises SIEM

Azure IaaS and PaaS services generate a ton of information that you can use to improve your overall security posture. The age old problem is getting to all that information and bringing into a single system so that you can crunch it. If you can crunch it, you can turn data into information and convert…


ARM template enforcing script execution order and timing in a loop

In a recent project we were trying to setup an active-active MariaDB cluster with custom script extension in an ARM template.  The VMs were created in a loop.   The scripts were written to have strict order of execution.  Script for second VM should not start to execute until script for the first VM has completed…


Road to APC: rhipe embraces the Spotify and Netflix models to deliver cloud consumption

The calibre of companies which have been named as finalists in the Microsoft Australia Partner Awards (MAPA) has never been higher. These are businesses that are deeply engaged in the digital transformation initiatives of their customers, and are contributing more broadly to the innovation fabric of Australia. In this story we meet rhipe, which is…


Using Amazon Lambda or Google Cloud Function check out Azure Functions

Azure Functions are the answer to Amazon’s Lambda or Google’s Cloud Functions, which perform similar roles, though Azure already had something similar, called WebJobs, and Azure Functions use the WebJobs SDK. “Azure functions are an evolution of WebJob. So what are Azure WebJobs The following article goes into great detail on Web Jobs such as…


Issue with Azure portal for Visual Studio Team Services new users – 8/25 – Investigating

Initial Update: Thursday, 25 August 2016 12:06 UTC We are actively investigating issues with login in Azure portal https://portal.azure.com/.  New users of VSTS may not be able to use Azure portal extension and VSTS features like Cloud Load Test, creation of team projects. We are actively working on hotfix for this, which will be deployed soon. Work Around: New users…


New book: Microsoft Azure Security Infrastructure

We’re pleased to announce the availability of Microsoft Azure Security Infrastructure (ISBN 9781509303571), by Yuri Diogenes, Dr. Thomas Shinder, and Debra Littlejohn Shinder.