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…


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…


Application Insights Planned Maintenance – 09/27 – Initial Notice

Planned Maintenance: 09/27/2016 15:00 UTC – 9/29/2016 07:00 UTC The Application Insights team will be performing planned maintenance on Alerting. During the maintenance window, we will be migrating the alerting infrastructure to new backend services. During this timeframe some customers may receive an extra email and webhook notification for existing active alerts. Resolution notifications are…


Working around the bug “Instead Of Trigger on View returns no output”

This post is to help developers implement a workaround on the bug mentioned in https://connect.microsoft.com/SQLServer/feedback/details/427666/instead-trigger-return-zero-number-into-output-identity Read my post at http://microsoftprogrammers.jebarson.com/bug-instead-of-trigger-on-view-returns-no-output/ which explains one of the work around which may come handy to you


C++ code analysis: tell us what you think!

We’d love to hear more about what you would like to see in C++ code analysis. We’re running a short survey–just 20 questions–to help us understand how to make C++ code analysis and Visual C++ better. Please take a couple of minutes to fill out our C++ Code Analysis survey and let us know your…