SQL Updates Newsletter – November 2014

Recent Releases and Announcements

Ø  SQL Server 2012 SP1 CU 13 (released Nov 2014)

o   http://support.microsoft.com/kb/3002044

Ø  SQL Server 2012 SP2 CU 3 (released Nov 2014)

o   http://support.microsoft.com/kb/3002049

Ø  SQL Release Services Blog

o   http://blogs.msdn.com/b/sqlreleaseservices/

Ø  Lync is now Skype for Business

o   In the first half of 2015, the next version of Lync will become Skype for Business with a new client experience, new server release, and updates to the service in Office 365

o   http://blogs.skype.com/2014/11/11/introducing-skype-for-business/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SkypeGarage+%28Skype+Garage%29

Ø  The Oracle and Teradata connector V3.0 for SQL Server 2014 Integration Service is now available for download

o   Microsoft SSIS Connectors by Attunity Version 3.0 is a minor release. It supports SQL Server 2014 Integration Services and includes bug fixes and support for updated Oracle and Teradata product releases.

o   http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/11/04/the-oracle-and-teradata-connector-v3-0-for-sql-server-2014-integration-service-is-now-available-for-download.aspx

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

Ø  Visual Studio 2013 Update 4

o   http://blogs.msdn.com/b/chuckw/archive/2014/11/24/visual-studio-2013-update-4.aspx

o   http://support.microsoft.com/kb/2994375?ln=en-us

Ø  SQL Server Data Tools November update

o   We’d like to announce the availability of the latest November 2014 release of SQL Server database tooling for Visual Studio. This update is now available for Visual Studio 2012 and 2013. For Visual Studio 2012 use the “SQL –> Check for Updates” tool inside Visual Studio. For Visual Studio 2013 download check the Visual Studio update channel (Tools –> Extensions and Updates –> Updates) for this update.

o   http://blogs.msdn.com/b/ssdt/archive/2014/11/13/sql-server-database-tooling-november-update.aspx

o   Download: http://msdn.microsoft.com/en-us/data/hh297027

Ø  Excel Power Map November Update

o   Adds a new feature requested by many Power Map users: the ability to play any tour directly from any scene.

o   http://blogs.msdn.com/b/powerbi/archive/2014/11/13/excel-power-map-november-update.aspx

Ø  CA Technologies and Microsoft Azure Team Up to Enhance Cloud Solutions for the Enterprise

o   http://blogs.msdn.com/b/stevengu/archive/2014/11/06/ca-technologies-and-microsoft-azure-team-up-to-improve-cloud-solutions-for-the-enterprise.aspx

Ø  Status of the Service Pack plans for SQL Server

o   We released SQL Server 2012 SP2  in June 2014

o   We  released SQL Server 2008 R2 SP3 in September 2014

§  SQL 2008 R2 SP3 download: http://www.microsoft.com/en-us/download/details.aspx?id=44271

o   We released SQL Server 2008 SP4 in September 2014

§  SQL 2008 SP4 download: http://www.microsoft.com/en-us/download/details.aspx?id=44278

o   How does this affect the product lifecycle?

§  It is still the case that mainstream support for the SQL 2008 and SQL 2008 R2 products has ended on July 8, 2014

§  This affects the service pack support for these products. With every new service pack a new lifecycle start date is set (for service pack support). Also, as an exception, the Service Pack Support end date of the previous service packs, SQL Server 2008 SP3 and SQL Server 2008 R2 SP2, have been extended by 12 months to facilitate the upgrade projects of our customers. Previously, both of these service packs were scheduled to end support this year.

§  http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/05/29/update-on-the-service-pack-plans-for-sql-server-2008-and-sql-server-2008-r2.aspx

o   For more details, this article provides a nice guideline of how to interpret the product lifecycle table: http://blogs.msdn.com/b/psssql/archive/2010/02/17/mainstream-vs-extended-support-and-sql-server-2005-sp4-can-someone-explain-all-of-this.aspx

Ø  Microsoft Security Bulletin Summary for November 2014

o   There is a critical IE and Kerberos update for this month:

o   https://technet.microsoft.com/library/security/ms14-nov

o   Customers running Windows Server 2008 R2 or Windows Server 2012 who installed the 2992611 update prior to the November 18 reoffering should reapply the update. https://technet.microsoft.com/library/security/ms14-066

Ø  Windows 10 Technical Preview

o   Join the Windows Insider Program. Get all the latest Windows 10 preview builds as soon as they’re available. This means you’ll be one of the first to experience the new ideas and concepts we’re building. In return, we want to know what you think.

§  https://insider.windows.com/

o   Windows 10 will evolve the universal Windows app model. The ability for Windows Store apps to run on the desktop (in a window) is one of the important new ways that we are creating developer opportunity.

§  http://blogs.msdn.com/b/dave_voyles_for_gaming_html5_and_xbox/archive/2014/10/01/internet-explorer-and-the-windows-10-technical-preview.aspx

o   Hyper-V and the Windows Server Technical Preview

§  Rolling Hyper-V Cluster Upgrade

§  Storage quality of service (QoS)

§  Virtual Machine Configuration Version

§  New virtual machine configuration file format

§  Production checkpoints

§  Hyper-V Manager improvements

§  Integration Services delivered through Windows Update

§  Hot add and remove for network adapters and memory

§  Linux secure boot

§  Compatible with Connected Standby

§  http://technet.microsoft.com/library/dn765471.aspx

o   You can now add and remove network adapters from running virtual machines

§  http://blogs.msdn.com/b/virtual_pc_guy/archive/2014/11/03/windows-10-technical-preview-hot-add-remove-of-network-adapter.aspx

o   The Windows 10 Technical Preview brings key advances to Chakra, the JavaScript engine that powers Internet Explorer and store based Web apps across a whole range of Windows devices – phones, tablets, 2-in-1’s, PC’s and Xbox

§  http://blogs.msdn.com/b/ie/archive/2014/10/09/announcing-key-advances-to-javascript-performance-in-windows-10-technical-preview.aspx

o   IE Interoperable Top Level Domain Parsing

§  http://blogs.msdn.com/b/dave_voyles_for_gaming_html5_and_xbox/archive/2014/10/01/internet-explorer-and-the-windows-10-technical-preview.aspx

§  http://blogs.msdn.com/b/ie/archive/2014/10/06/interoperable-top-level-domain-name-parsing-comes-to-ie.aspx

o   We will be adding a new role called MultiPoint Services to Windows Server. MultiPoint allows multiple users, each with their own independent Windows experience, to simultaneously share one computer. Some example use-case scenarios include: Teachers/students in computer labs + Point of sale  in retail

§  http://blogs.msdn.com/b/rds/archive/2014/10/27/announcing-the-multipoint-services-role-in-window-server-vnext-technical-preview.aspx

o   Internet Explorer on the Windows 10 Technical Preview includes support for new the HTTP/2 networking protocol

§  http://blogs.msdn.com/b/ie/archive/2014/10/08/http-2-the-long-awaited-sequel.aspx#10564904

§  http://blogs.msdn.com/b/ie/archive/2014/10/01/internet-explorer-and-the-windows-10-technical-preview.aspx

o   if you are running Windows Technical Preview (server or desktop) and you have virtual machines running: Windows Server 2012, Windows Server 2008 R2, Windows 8, Windows 7 updated integration components will  be coming through Windows Update instead of through our old “Install Integration Services” mechanism.

§  http://blogs.msdn.com/b/virtual_pc_guy/archive/2014/11/12/updating-integration-components-over-windows-update.aspx

o   Share integration from File Explorer. This lets you share files through any Store app that participates in the so called “sharing contract”. There’s also a new landing page for File Explorer, called “Home” in the Technical Preview. This is a new node in File Explorer where we show you your most recently used files, and your most frequently used folders.

§  http://blogs.msdn.com/b/asklar/archive/2014/11/13/windows-10-and-file-explorer.aspx

o   The final version of Windows 10 will ship with DirectX 12

§  http://blogs.msdn.com/b/directx/archive/2014/10/01/directx-12-and-windows-10.aspx#10572978

o   Failover Clustering

§  Cluster Operating System Rolling Upgrade

§  Storage Replica

§  http://technet.microsoft.com/en-us/library/dn765474.aspx

o   Storage

§  Storage Quality of Service

§  Storage Replica

§  http://technet.microsoft.com/en-us/library/dn765475.aspx

Ø  Windows Management Framework 5.0 Preview November 2014 is now available

o   This Windows Management Framework (WMF) preview includes everything from WMF 5.0 Preview September 2014 plus some new improvements.

§  OneGet

§  PowerShellGet

§  Windows PowerShell Desired State Configuration

§  Classes for Windows PowerShell

§  Debugging in Windows PowerShell

o   http://blogs.msdn.com/b/powershell/archive/2014/11/18/windows-management-framework-5-0-preview-november-2014-is-now-available.aspx

Ø  Update for RDCMan

o   Updated version introduces the ability to connect directly to virtual machines through Hyper-V.

o   http://blogs.msdn.com/b/virtual_pc_guy/archive/2014/11/24/update-for-rdcman.aspx

Ø  Visual Studio 2015 Preview and Entity Framework

o   We are pleased to announce the availability of Visual Studio 2015 Preview

o   http://blogs.msdn.com/b/adonet/archive/2014/11/12/visual-studio-2015-preview-and-entity-framework.aspx

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

Ø  Windows November 2014 Hotfixes

o   http://blogs.msdn.com/b/winsdk/archive/2014/11/19/windows-hotfixes-for-november-2014.aspx

Ø  Recent Whitepapers/E-books/Training:

o   Partner Practice Enablement: Azure Technical Training

§  http://support.microsoft.com/kb/3009979

o   Hour of Code will help inspire the next generation of dreamers and developers

§  http://blogs.msdn.com/b/stevengu/archive/2014/11/08/hour-of-code-will-help-inspire-the-next-generation-of-dreamers-and-developers.aspx

o   From Data to Insight and Impact: The BI Revolution

§  This course was designed for finance professionals, but the tools and techniques taught will benefit anyone who is not a business intelligence (BI) specialist. Join the experts to find out how easy it is to get data, shape it for your business needs, and maximize your impact.

§  http://www.microsoftvirtualacademy.com/training-courses/from-data-to-insight-and-impact-the-bi-revolution

o   Implementing Tabular Data Models

§  http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models?loc=zYFCz&prod=zSQLz&tech=zBIz&prog=zMVAz&type=zTRz&media=zWCz&country=zUSz

o   Modernizing Your Datacenter Jump Start

§  http://www.microsoftvirtualacademy.com/training-courses/modernizing-your-datacenter-jump-start

o   Microsoft Azure Fundamentals

§  http://www.microsoftvirtualacademy.com/training-courses/microsoft-azure-fundamentals

o   Getting Started with Microsoft Azure Machine Learning

§  http://www.microsoftvirtualacademy.com/training-courses/getting-started-with-microsoft-azure-machine-learning


Fany Carolina Vargas | SQL Dedicated Premier Field Engineer | Microsoft Services

Comments (0)

Skip to main content