SQL Server Integration Services ( SSIS ) の使い方

Microsoft Japan Data Platform Tech Sales Team 坂本 禎尚 今回は SQL Server Integration Services 、通称 SSIS の使い方をご紹介します。 SSIS とは SQL Server が持つ ETL ツールです。 Extract - データ ソースからの情報の抽出・取り込み Transform - 抽出したデータの変換や加工 Load - 変換や加工が完了したデータのロード ETL という言葉は以前はデータウェアハウスを構築・維持をしていくうえでの工程を表した用語でしたが、最近ではそもそもデータベースに限定することなく様々なデータ ソース間のデータ連携手段として用いられることが多くなってきています。 SSIS の前身は SQL Server 2000 まで提供されていた DTS という COM ベースのコンポーネントでしたが、SQL Server 2005 で今日の SSIS という .NET ベースのものに生まれ変わり、かつこのタイミングで DTS…


Issues with CodeLens – 9/27 – Resolved

Final Update: Wednesday, 28 September 2016 00:23 UTC We’ve confirmed that all systems are back to normal as of 28 September 2016 00:16 UTC. The failure was due to an incorrect CNAME configuration on the service certificate which had to be fixed to resolve the issue. We will be conducting a detailed postmortem and ensure that we have…


Resize Azure Resource Manager (ARM) VM OS & Data disk using Azure Portal

If you have an Azure VM that was created using the Azure Resource Manager (ARM) stack you can now easily resize the OS or the data disk within the Azure Portal. Of course, you can also use PowerShell but way too easy using the GUI. 1. Navigate to the Virtual Machine (VM) that you would…


Installing Microsoft Antimalware extension in Azure Gov’t VM using PowerShell

Microsoft Antimalware for Azure Virtual Machines is a real time protection that will monitor the VM’s to detect and block malwares. You can read more about Microsoft Antimalware here. Please follow the below steps to enable the Antimalware extension for Azure Gov’t VM. You will need to use Azure PowerShell to enable the extension. You…


Access Denied – Checking Registry and File Access permissions

Permission issues related to accessing files, folders and the registry can cause applications to crash, hang or work incorrectly.  There are several tools which are helpful for diagnosing these issues.   Process Monitor: Process Monitor (procmon) can be used to log access to files, folders, registry and network.  Each log entry shows the access…


Paper and pencil. Evolved! – What do young learners think of digital inking?

Tablets like Surface with an active pen and tools like OneNote give students and educators the freedom to teach the way they want. And with the recent updates to Windows 10, there are now even more ways in which students and teachers can experience the feel of a pen in their hand while enjoying all the productivity and collaboration benefits of a digital environment. Handwrite your notes, annotate documents, or sketch out your next big idea. Get creative with a variety of tools and effects. The natural feel of pen and paper meets the power of digital ink.


Migrating to CRM Online – Tips and Tricks – Ignite 2016

Here are the 15 tips that we shared as part of our Migrating to Microsoft Dynamics CRM Online interactive discussion at Ignite 2016. We wanted to share them in a blog article to those who attended (to reduce the need for notes), for those who could not attend, and help reduce our own need for…


Application Insights Planned Maintenance – 09/20 – Initial Notice

Planned Maintenance: 17:00 UTC, 20 September 2016 – 23:00 UTC, 28 September 2016The Application Insights team will be performing planned maintenance on Availability Web Test feature. During the maintenance window we will be installing necessary updates on underlying infrastructure. During this timeframe some customers may experience very short availability data gaps in one test location…