Microsoft Power Query for Excel

Posted by bink on July 10 2013, 8:38 AM.

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access.

Microsoft Power Query for Excel is an add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Power Query enables users to easily discover, combine, and refine data for better analysis in Excel. Power Query includes a public search feature that is currently intended for use in the United States only.

With Power Query, you can:

  • Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).
  • Discover relevant data using the search capabilities within Excel.
  • Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in Excel and PowerPivot.

Download http://www.microsoft.com/en-us/download/details.aspx?id=39379

PoweShell 4.0 preview released

Posted by bink on July 3 2013, 8:11 AM.

Windows Management Framework 4.0 Preview includes updates to Windows PowerShell, Windows PowerShell ISE, Windows PowerShell Web Services (Management OData IIS Extension), Windows Remote Management (WinRM), Windows Management Instrumentation (WMI), the Server Manager WMI provider, and a new feature for 4.0, Windows PowerShell Desired State Configuration (DSC).

This software is a prerelease version. Features and behavior are likely to change before the final release.

This preview release lets you explore new features and functionality in Windows Management Framework 4.0, including the following:

  • Windows PowerShell 4.0
  • Windows PowerShell ISE
  • Windows PowerShell Web Services (Management OData IIS Extension)
  • Windows Remote Management (WinRM)
  • Windows Management Instrumentation (WMI)
  • The Server Manager WMI provider
  • A new feature for 4.0, Windows PowerShell Desired State Configuration (DSC)

Your feedback about Windows Management Framework 4.0 Preview is valuable to us; we invite you to provide feedback before features are finalized. For important information about changes in behavior from Windows PowerShell 3.0, and a list of known issues with this release, be sure to read the WMF 4.0 Preview release notes that are available for download with this package. You can log bugs and suggestions by using the Microsoft Connect website.

Windows Management Framework 4.0 Preview makes updated management functionality available for installation on Windows 7 SP1, Windows Server 2008 R2 SP1, and Windows Server 2012.

Windows PowerShell 4.0
Some of the new features in Windows PowerShell 4.0 include:

  • Support for workflow and remote script debugging
  • Improved workflow authoring experience to make it more consistent with script authoring
  • Added PipelineVariable as a common parameter
  • Better support for downloading updatable help by using Save-Help and Update-Help in offline scenarios
  • Updated version from 3.0 to 4.0
  • Several bug fixes and performance improvements


Windows PowerShell Integrated Scripting Environment
Windows PowerShell ISE in Windows Management Framework 4.0 Preview introduces:

  • Support for Windows PowerShell Workflow debugging
  • Support for remote script debugging
  • IntelliSense support for Windows PowerShell Desired State Configuration providers and configurations


Windows PowerShell Web Services
Windows PowerShell Web Services (Management OData IIS Extension) enables an administrator to expose a set of Windows PowerShell cmdlets as a RESTful web endpoint accessible by using OData (Open Data Protocol). This provides remote access to run cmdlets from both Windows-based and non-Windows-based client computers or devices.

  • Improved error messages in event logs
  • Endpoint versioning support
  • Autopopulation of OData dispatch schema fields
  • Support for complex types
  • Multilevel association support
  • Ability to perform large binary stream transfers
  • Support for non-Create/Read/Update/Delete (CRUD) actions
  • Key-As-Segment URL syntax support
  • Constrained resource operations


WMI, WinRM, and Server Manager CIM Provider
These features were included with WMF 3.0, and continue to be included in WMF 4.0 Preview. There are no significant changes to these features.

Windows PowerShell Desired State Configuration
Windows Management Framework 4.0 Preview introduces Windows PowerShell Desired State Configuration (DSC), with the following highlights:

  • Local configuration manager for applying configurations on the local computer
  • Windows PowerShell language extensions for authoring DSC documents
  • PSDesiredStateConfiguration module and DSC-related cmdlets
  • A set of built-in DSC configuration providers
  • DSC service for distributed access to DSC resources

Download

Sebastiaan Bink’s live performance drumming Queen “Somebody to Love”

Posted by bink on July 1 2013, 5:53 PM.

I’m very proud of my son’s drum performance yesterday at the student concert of his drum school.

Sebastiaan just turned 9. Please check it out Open-mouthed smile and Thumbs up it on YouTube.
It is uploaded in 1080p so should be great full screen viewing (click watch on YouTube button)

Shutdown and Restart added to Windows 8.1 "start menu"

Posted by bink on June 25 2013, 4:28 PM.

In Windows 8.1 and Windows Server 2012 R2 the right-click menu has been positively expanded with a quick access to Shutdown and Restart. Now that is a welcome addition.

Also Network Connections is added.

 

Microsoft and Oracle announce enterprise partnership

Posted by bink on June 25 2013, 8:30 AM.

Deal will help customers embrace cloud computing by providing greater choice and flexibility.

Microsoft and Oracle announce enterprise partnershipMicrosoft Corp. and Oracle Corp. today announced a partnership that will enable customers to run Oracle software on Windows Server Hyper-V and in Windows Azure. Customers will be able to deploy Oracle software — including Java, Oracle Database and Oracle WebLogic Server — on Windows Server Hyper-V or in Windows Azure and receive full support from Oracle. Terms of the deal were not disclosed.

As part of this partnership, Oracle will certify and support Oracle software — including Java, Oracle Database and Oracle WebLogic Server — on Windows Server Hyper-V and in Windows Azure. Microsoft will also offer Java, Oracle Database and Oracle WebLogic Server to Windows Azure customers, and Oracle will make Oracle Linux available to Windows Azure customers.

Java developers, IT professionals and businesses will benefit from the flexibility to deploy fully supported Oracle software to Windows Server Hyper-V and Windows Azure.

“Microsoft is deeply committed to giving businesses what they need, and clearly that is the ability to run enterprise workloads in private clouds, public clouds and, increasingly, across both,” said Steve Ballmer, chief executive officer of Microsoft. “Now our customers will be able to take advantage of the flexibility our unique hybrid cloud solutions offer for their Oracle applications, middleware and databases, just like they have been able to do on Windows Server for years.”

“Our customers’ IT environments are changing rapidly to meet the dynamic nature of the world today,” said Oracle President Mark Hurd. “At Oracle, we are committed to providing greater choice and flexibility to customers by providing multiple deployment options for our software, including on-premises, as well as public, private, and hybrid clouds. This collaboration with Microsoft extends our partnership and is important for the benefit of our customers.”

Additional information about support and the licensing mobility changes that went into effect today is available on Oracle’s blog at https://blogs.oracle.com/cloud/entry/oracle_and_microsoft_join_forces.

Evaluation Guide for System Center 2012 R2 and the Windows Azure Pack

Posted by bink on June 25 2013, 8:28 AM.

This documentation provides the information to help you set up and test an evaluation environment for tenant and administrator portals.

The Evaluation Guide for System Center 2012 R2 and the Windows Azure Pack is designed for hosting providers and large enterprises who want to create tenant and administrator portals to provide the same Infrastructure as a Service experience that is available through the Windows Azure Portal. Use this guide to set up and test these capabilities. The deployment guide describes how to set up the evaluation environment and the walkthroughs demonstrate the value and functionality of key scenarios enabled in this release.

 

Download

Database as a Service Reference Architecture Guide

Posted by bink on June 25 2013, 8:27 AM.

Provides hardware, software, system design, and component configurations to create secure, scalable, distributed, multitenant database services that use the latest virtualization technologies.

    This guidance is targeted at hosting providers who want to create secure, scalable, distributed, multitenant database service offerings that use the latest virtualization technologies. It scales through small- to large-sized organizations that want to provide consolidated, cost-effective database services.

    Download

    Desktop Hosting Reference Architecture Guide

    Posted by bink on June 25 2013, 8:23 AM.

    Defines how to create secure, scalable, and reliable desktop hosting solutions for small- and medium-sized organizations based on Remote Desktop Services, Hyper-V, virtual networking, and other virtualization technologies.

     

    Download

    Remote Server Administration Tools for Windows 8.1 Preview

    Posted by bink on June 25 2013, 8:23 AM.

    Remote Server Administration Tools for Windows 8.1 Preview enables IT administrators to manage roles and features that are installed on computers that are running Windows Server 2012 or Windows Server 2012 R2 Preview from a remote computer that is running Windows 8.1 Preview.

     

    Download

    Microsoft Integration Platform Poster

    Posted by bink on June 25 2013, 8:22 AM.

    The poster depicts the MS integration platform, including enterprise integration with the cloud.

    image

    Click picture to download