A lot of small releases were made by Microsoft’s SQL Server team last month. Some of the highlights include Power BI for on-site servers, System Center support for SQL Server 2014, and updated Java/PHP drivers.
As announced at Web Summit last week, Dropbox has partnered up with Microsoft. Dropbox already hosts over 35 Billion Office documents, spreadsheets and presentations. This is value that Microsoft is willing to capture and allow for deeper integration between Office and Dropbox users. We examine what this partnership brings to both ends and the user and how the Cloud Storage market is shaping.
Office 365 is expanding developer support by adding new APIs and key SDKs for native app development on the Android and iOS platforms. These SDKs will let developers utilize Objective-C and Java while constructing apps that leverage Office 365 functionality.
In their latest Patch Tuesday, Microsoft issued 9 bulletins covering a total of 37 common vulnerabilities and exposures (CVE) spread across some of their products.
The file formats used by Microsoft Word, Excel, and PowerPoint have been fully opened source via the latest release of Microsoft's OpenXML SDK. This provides developers with the familiar Apache 2.0 License, providing an easier path to incorporating support for these documents into their own projects.
Microsoft recently announced the initial release of the OneNote API, which enables programmatic integration of its free-form information gathering and multi-user collaboration tool across different programming languages and platforms like Windows, Windows Phone, iOS, Mac OS, Android and the web.
Microsoft in collaboration with Google has recently released an app for Android based phone for users with a valid Office 365 subscription.
Microsoft updated several tools for developers targeting SQL Server, SharePoint, and Office. The Business Intelligence tools support analysis, integration, and reporting for SQL Server. The Office/SharePoint tools suite bring support for the 2013 versions of each and .NET Framework 4.5.
Few months back, Microsoft announced HDInsight, Microsoft’s Hadoop distribution for managing, analysing and making sense out of large volumes of data. InfoQ connected with Val Fontama, Senior Product Marketing Manager for SQL Server, to know more about how the Enterprise Big Data @ Microsoft story is panning out.
The addition of the app store to Office and SharePoint 2013 provides new opportunities for both users and developers. These new features provide greater awareness for Internet data sources and bring customization to users.
OpenXML SDK 2.0 for MS Office provides strongly typed part classes to manipulate Open XML documents. WorddocGenerator, an open source utility for generating template driven word files is one example of what can be done with this SDK. InfoQ got in touch with Atul Verma the developer of this utility to ask him a few questions about this project.
The Office Integration Pack enables Visual Studio LightSwitch developers to work with data in Microsoft Office 2010. With this extension, users are able to create documents, spreadsheets, and PDFs; send Outlook appointments and emails; and move data to and from Excel.
When working with Excel documents, developers usually use raw XML or rely on the Office Automation libraries. But the Office Automation library is not appropriate for servers and working with XML can be quite tedious. ClosedXML bridges the gap by providing an easy to use Office-like API without the overhead of COM. To introduce this library we spoke with Manuel De Leon of the ClosedXML project.
Open XML SDK 2.0 offers a moderately high level API for manipulating Open XML documents using strongly typed classes. It includes the Open XML SDK v2.0 Productivity Tool, which can reverse engineer a Word, PowerPoint, or Excel document and display the C# code needed to recreate it.