주간닷넷 2017년 5월 30일

금주의 패키지: Open XML SDK 이번 주에 소개해 드릴 패키지는 엑셀, 워드, 파워포인트 문서 작업에 활용할 수 있는 ‘Open XML SDK’ 오픈소스 라이브러리입니다. 워드 ,엑셀, 파워포인트 문서의 고성능 편집 및 작성이 가능하며 워드 문서를 HTML로 변환 혹은 XLSX 포멧으로 데이터를 추출할 수 있으며 다양한 형태의 문서 변경작업이 가능합니다. using (var doc = WordprocessingDocument.Open(strDoc, true)) {…


vswhere version 2.0 released

One of the features of the new setup engine is to enable Visual Studio to be installed side-by-side with other minor releases, including minor upgrades and preview releases. After introducing the Visual Studio Preview channel a short while ago, some partners asked for the ability to filter out those Preview releases from vswhere.exe. Because this is…


Application Insights Planned Maintenance – 06/15 – Final Update

Final Update: Friday, 23 June 2017 22:05 UTCMaintenance has been completed on infrastructure for Application Insights Availability Web Test feature.Necessary updates were installed successfully on all nodes, supporting Availability Web Test feature. -Deepesh Planned Maintenance: 17:00 UTC, 20 June 2017 – 00:00 UTC, 24 June 2017 The Application Insights team will be performing planned maintenance on Availability Web…


Why are we still not unit testing?

Unit testing. At least unit testing. I thought this was a solved problem, people. Agile has come out of the shadows and dominated the techie buzzword machine for years now. Everyone is doing Scrum now, right? Well, OK, they’re usually doing “ScrumBut”. “We’re doing Scrum, but we’re not demoing our software to the customer.” Or, “We’re doing…


New Azure VPN Gateway SKU’s provide much higher bandwidth for hybrid workloads

Background:  Education customers, particularly Higher Education customers, tend to invest in Internet connectivity differently than the average company focused on making or selling widgets.  Commodity Internet connectivity investments are measured in multiple Gigabits/Sec of bandwidth for many of these customers.  A good number of my EDU customers are members of Internet2 (I2), a networking consortium…


Example Python Program Reading SQL Azure Blob Auditing Data

I recently had a case that a customer needed a way to read the blob auditing data from Linux. This was the quickest and easiest way I could think of. First install msodbcsql following the instructions here https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server You will also need to install the pyodbc module.


SharePoint 2013 Multiple App Domain with Host Named Site Collections Issue

SO, the other day I ran into a problem at a customer: Summary My client has setup an environment where they can only utilize sub domains of their primary domain. For example: command.com Hence different sites would be sub domains such as: release.command.com forward.command.com To save time, maintenance and resources these two web applications are…


Rules Extensions – MA Extension

  The following is just an example of what an MA Extension would like like and should only be used as a reference on how to build your own MA Extension, I use this post as a reference for all my MA Extension Post which I have broken up into sections Rules Extensions – ShouldProjectToMV…


Rules Extensions – Helper Functions

  This post is focused on Helper Functions  that Multiple Methods can call to complete a task, additionally talks about Function Overloading, “Overloaded functions enable programmers to supply different semantics for a function, depending on the types and number of arguments.” See Referenced Documents: Understanding the Helper Function Function Overloading Account-Expires attribute Pwd-Last-Set attribute Last-Logon-Timestamp…