SQL Updates Newsletter - June 2015

Recent Releases and Announcements

• Cumulative Update #1 for SQL Server 2014 SP1
  • https://support.microsoft.com/en-us/kb/3067839
• Cumulative Update #8 for SQL Server 2014 RTM
  • https://support.microsoft.com/en-us/kb/3067836
• HP and Microsoft announce a new Superdome X Reference Configuration Guide for SQL Server 2014
  • https://blogs.technet.com/b/dataplatforminsider/archive/2015/06/04/hp-and-microsoft-announce-a-new-superdome-x-reference-configuration-guide-for-sql-server-2014.aspx
• New NIC Teaming Documentation for Windows Server Technical Preview
  • https://blogs.technet.com/b/wsnetdoc/archive/2015/06/09/new-nic-teaming-documentation-for-windows-server-technical-preview.aspx
• Windows 10 will be available on 29th July, 2015
  • https://blogs.technet.com/b/keep_your_business_moving/archive/2015/06/15/windows-10-is-around-the-corner.aspx
• Announcement: General Availability of Azure RMS (Rights Management Services) Departmental Templates
  • https://blogs.technet.com/b/rms/archive/2015/06/10/announcement-general-availability-of-departmental-templates.aspx
• Microsoft a Leader in Gartner Magic Quadrant for Client Management Tools 2015
  • https://blogs.technet.com/b/enterprise_mobility_belgium/archive/2015/06/15/microsoft-a-leader-in-gartner-magic-quadrant-for-client-management-tools-2015.aspx
• Announcing the official SSIS blog
  • https://blogs.msdn.com/b/ssis/archive/2015/06/25/welcome-to-the-official-ssis-blog.aspx
• Announcing the Microsoft Operations Management Suite (OMS) to Assess the health of SQL Server deployments in Azure VM
  • https://blogs.technet.com/b/dataplatforminsider/archive/2015/06/02/assess-the-health-of-sql-server-deployments-in-azure-vm-using-microsoft-operations-management-suite.aspx
• Power BI The new Get Data experience - a cleaner and simpler experience to Get Data
  • https://blogs.msdn.com/b/powerbi/archive/2015/06/23/the-new-get-data-experience.aspx
• The SQL Server 2016 version of Master Data Services deprecates Explicit Hierarchies (EH) and Collection and all related components
  • https://blogs.msdn.com/b/mds/archive/2015/06/02/deprecated-explicit-hierarchies-and-collections.aspx
• Microsoft Joins the R Consortium
  • https://blogs.technet.com/b/machinelearning/archive/2015/06/30/microsoft-joins-the-r-consortium.aspx
• Microsoft SQL Server 2014 Integration Services (SSIS) Feature Pack for Azure released
  • https://www.microsoft.com/en-us/download/details.aspx?id=47366
• SSDT June 2015 Preview
  • https://blogs.msdn.com/b/ssdt/archive/2015/06/24/ssdt-june-2015-preview.aspx
• Announcing Refresh Support for Power BI Designer files in the Power BI service. This enables support for refreshing data, reports & dashboards coming from select data sources.
  • https://blogs.msdn.com/b/powerbi/archive/2015/06/22/announcing-refresh-support-for-power-bi-designer-files-in-the-power-bi-service.aspx
• Announcing SQL Server Management Studio – June 2015 Release
  • https://blogs.msdn.com/b/sqlreleaseservices/archive/2015/06/24/sql-server-management-studio-june-2015-release.aspx 
• SQL Server 2016 CTP 2.1 now available. In addition to the new CTP model, SQL Server Management Studio (SSMS) is now being offered as a stand-alone install outside of the SQL Server release. This means Azure SQL database customers can use SSMS for the new features being released in cloud as well as their on-premises SQL Server. SSMS as a standalone tool will also follow the rapid preview model with frequent updates to keep pace with the new features being released in Azure SQL Database
  • https://blogs.technet.com/b/dataplatforminsider/archive/2015/06/24/sql-server-2016-community-technology-preview-2-1-is-available.aspx 
  • https://blogs.technet.com/b/stbnewsbytes/archive/2015/06/24/cloud-platform-release-announcements-for-june-24-2015.aspx
• Participate in the Power BI Designer Survey + Sweepstakes
  • https://blogs.msdn.com/b/powerbi/archive/2015/06/11/we-re-on-for-a-great-designer-summer.aspx
• Microsoft Power BI Content Pack(SweetIQ) and Azure SQL Data Warehouse connector generally available
  • https://blogs.technet.com/b/stbnewsbytes/archive/2015/06/24/cloud-platform-release-announcements-for-june-24-2015.aspx 
  • https://blogs.msdn.com/b/powerbi/archive/2015/06/24/exploring-azure-sql-data-warehouse-with-power-bi.aspx
• Announcing the Limited Public Preview of Azure SQL Data Warehouse. The initial public preview will target data warehouses in the 5-10 TB range to give you the ability to start testing and providing feedback on the service. Participation in the preview will be limited based on capacity so customers will first request access to the preview and access will be approved based on availability.
  • https://azure.microsoft.com/en-us/services/sql-data-warehouse/
  • https://blogs.technet.com/b/stbnewsbytes/archive/2015/06/24/cloud-platform-release-announcements-for-june-24-2015.aspx
• Azure Key Vault generally available. Key Vault enables you to store and control cryptographic keys and other secrets used by cloud applications 
  • https://blogs.technet.com/b/stbnewsbytes/archive/2015/06/24/cloud-platform-release-announcements-for-june-24-2015.aspxhttps://azure.microsoft.com/en-us/documentation/videos/episode-169-azure-key-vault-with-sumedh-barde/
• Azure Active Directory Connect, the simple, fast and lightweight tool to connect Active Directory and Azure Active Directory in a few clicks is now generally available.
  • Also generally available, Connect Health, will help monitor and gain insights into your identity infrastructure that is used to extend on-premises identities to Azure Active Directory and Office 365.
  • https://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnect/
  • https://blogs.technet.com/b/stbnewsbytes/archive/2015/06/24/cloud-platform-release-announcements-for-june-24-2015.aspx
• Azure Application Gateway provides application-level routing and load balancing services to enable you to build a scalable and highly-available web frontend in Azure.
  • https://azure.microsoft.com/en-us/services/application-gateway/
• MapR-based Hadoop data clusters will arrive on the Azure Marketplace this summer. When MapR is available in the Azure Marketplace, customers will be able to launch a full Hadoop cluster based on MapR as an Azure Virtual Machine with a few clicks.
  • https://blogs.technet.com/b/dataplatforminsider/archive/2015/06/10/mapr-based-hadoop-clusters-coming-to-the-azure-marketplace.aspx
• Hortonworks Data Platform (HDP) 2.3 recently released and will be available for Windows Server and Azure IaaS
  • https://blogs.technet.com/b/dataplatforminsider/archive/2015/06/09/guest-blog-delivering-transformational-outcomes-with-hortonworks-data-platform-2-3.aspx
• Microsoft acquires Wunderlist
  • https://blogs.microsoft.com/blog/2015/06/02/welcome-6wunderkinder-microsoft-acquires-wunderlist/?linkId=14664882&filter-products=windows-phone,oem

 

Recent Whitepapers/E-books/Training

• Windows 10 Readiness: Introducing Windows 10 for IT Professionals, Preview Edition
  • https://blogs.technet.com/b/uspartner_ts2team/archive/2015/06/29/windows-10-readiness-introducing-windows-10-for-it-professionals-preview-edition.aspx
• Workshops, Webcasts, and Tech Talks – June 2015
  • https://blogs.msdn.com/b/premier_developer/archive/2015/06/08/workshops-webcasts-and-tech-talks-june-2015.aspx
• Azure Readiness Catalog
  • https://blogs.msdn.com/b/wriju/archive/2015/06/16/azure-readiness-catalog.aspx
• [Webinar] Microsoft Power BI Preview Technical Overview
  • https://blogs.msdn.com/b/powerbi/archive/2015/06/23/webinar-microsoft-power-bi-preview-technical-overview.aspx
• Free ebook: Microsoft System Center Data Protection for the Hybrid Cloud
  • https://blogs.msdn.com/b/microsoft_press/archive/2015/06/15/free-ebook-microsoft-system-center-data-protection-for-the-hybrid-cloud.aspx
• Free ebook: Microsoft Azure Essentials: Azure Web Apps for Developers
  • https://blogs.msdn.com/b/microsoft_press/archive/2015/06/09/free-ebook-microsoft-azure-essentials-azure-web-apps-for-developers.aspx
• Visio 2013 Power User Part 2 & 3 video courses
  • https://blogs.msdn.com/b/microsoft_press/archive/2015/06/05/visio-2013-power-user-part-2-amp-3-video-courses-from-author-scott-helmers.aspx
• Free Webinar: Azure ML for Software Engineers
  • https://blogs.technet.com/b/machinelearning/archive/2015/06/03/free-webinar-azure-ml-for-software-engineers.aspx
• Performance Series | EP10, Network Congestion
  • https://blogs.technet.com/b/the_9z_by_chris_davis/archive/2015/06/21/performance-series-ep10-network-congestion-how-it-pros-should-troubleshoot-slow-pc-39-s-and-servers.aspx
• Performance Series | EP8, Kernel Memory Leaks
  • https://blogs.technet.com/b/the_9z_by_chris_davis/archive/2015/06/05/performance-series-ep8-kernel-memory-leaks-how-it-pros-should-troubleshoot-slow-pc-39-s-and-servers.aspx
• Big Data and Advanced Analytics: On-demand and Upcoming Live Webinars
  • https://azureinfo.microsoft.com/BigDataAdvancedAnalyticsWebinars.html
• [Webcast Video]: Group Managed Service Accounts in Windows 2012
  • https://blogs.technet.com/b/meagbs/archive/2015/06/01/webcast-video-group-managed-service-accounts.aspx
• The Path to Windows 10 Webcast–Replay
  • https://blogs.technet.com/b/uspartner_ts2team/archive/2015/06/02/the-path-to-windows-10-webcast-replay.aspx
• Register for July 30 Webcast "What Time Is It? A Guide to Time for Software Developers
  • https://blogs.technet.com/b/cdnitmanagers/archive/2015/06/30/register-for-july-30-webcast-with-george-neville-neil-quot-what-time-is-it-a-guide-to-time-for-software-developers.aspx

Monthly Script Tips

• Using PowerShell and Excel PivotTables to understand the files on your disk
  • https://blogs.technet.com/b/josebda/archive/2015/06/01/using-powershell-and-excel-pivottables-to-understand-the-files-on-your-disk.aspx
• [Script Of Jun. 05] Find the SQL Server databases that contain a certain table or stored procedure
  • https://blogs.technet.com/b/onescript/archive/2015/06/05/script-of-jun-05-find-the-sql-server-databases-that-contain-a-certain-table-or-stored-procedure.aspx
• [Script Of Jun. 02] How to add startup parameters for all the SQL Server instances (PowerShell)
  • https://blogs.technet.com/b/onescript/archive/2015/06/02/script-of-jun-02-how-to-add-startup-parameters-for-all-the-sql-server-instances-powershell.aspx
• PowerShell - Passing Parameters as Variables using Remote Management and Invoke-Command
  • https://blogs.technet.com/b/ralphkyttle/archive/2015/06/04/powershell-passing-parameters-as-variables-using-remote-management-and-invoke-command.aspx
• Use PowerShell to Enter-PSSession from the Active Directory Users and Computers MMC
  • https://blogs.technet.com/b/poshchap/archive/2015/06/05/use-powershell-to-extend-dsa-msc.aspx
• PowerTip: Convert All Uppercase String to Lowercase
  • https://blogs.technet.com/b/heyscriptingguy/archive/2015/06/29/powertip-convert-all-uppercase-string-to-lowercase.aspx
• Creating PDF notes programmatically in CRM 2015
  • https://blogs.technet.com/b/tvishnun1/archive/2015/06/24/creating-pdf-notes-programmatically-in-crm-2015.aspx
• Security Focus: Check Active Directory for Anonymous Access
  • https://blogs.technet.com/b/poshchap/archive/2015/06/12/security-focus-check-active-directory-for-anonymous-access.aspx

Issue Alert

• Critical issue in SQL Server 2012 Service Pack 1 that could crash your SQL server
  • https://blogs.msdn.com/b/axinthefield/archive/2013/10/31/sql-server-2012-service-pack-1-issue-that-could-crash-your-server.aspx
• Critical: Do NOT delete files from the Windows Installer folder. C:\windows\Installer is not a temporary folder and files in it should not be deleted. If you do it on machines on which you have SQL Server installed you may have to rebuild the operating system and reinstall SQL Server.
  • https://blogs.msdn.com/b/sqlserverfaq/archive/2013/04/30/do-not-delete-files-from-the-windows-installer-folder.aspx
• Important: You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server
  • https://support.microsoft.com/kb/239530
• Quick Issue Alert - WMF 4.0 installation on W2012 fails with 0x80096002 if W8 package is selected
  • https://blogs.msdn.com/b/sqlupdates/archive/2015/06/22/quick-issue-alert-wmf-4-0-installation-on-w2012-fails-with-0x80096002-if-w8-package-is-selected.aspx
• When you use a query that scans a clustered columnstore index in Microsoft SQL Server 2014, you may, under rare conditions, receive partial query results.
  • https://support.microsoft.com/en-us/kb/3067257
• Incorrect results are returned in an indexed view after an Insert or Delete operation on the base table occurs in SQL Server 2014
  • https://support.microsoft.com/en-us/kb/3067896
• FIX: "Error converting data type nvarchar to datetime" error occurs when you use business rule in SQL Server 2014 MDS
  • https://support.microsoft.com/en-us/kb/3029504
• Access violation when you connect to an instance of SQL Server 2014
  • https://support.microsoft.com/en-us/kb/3067826
• FIX: SQL Server 2014 Object Explorer does not display the SQL Azure objects correctly
  • https://support.microsoft.com/en-us/kb/3020402
• FIX: Data loss occurs when you use Windows Azure Storage in SQL Server 2014 on high latency networks
  • https://support.microsoft.com/en-us/kb/3067659
• FIX: "Cannot read 8 bytes from file using caching" error when you execute an SSIS 2014 package
  • https://support.microsoft.com/en-us/kb/3061218
• Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014
  • https://support.microsoft.com/en-us/kb/3070147
• FIX: Severe error in SQL Server 2014 during compilation of a query on a table with clustered columnstore index
  • https://support.microsoft.com/en-us/kb/3068297
• FIX: XSLT transformation fails when you run an SSIS 2014 package that contains multiple concurrent XML tasks
  • https://support.microsoft.com/en-us/kb/3063438
• Events 18210, 3041, and 1 are logged when Hyper-V replica is configured
  • https://support.microsoft.com/en-us/kb/3050765
• FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014
  • https://support.microsoft.com/en-us/kb/3066682
• FIX: PowerPivot Gallery unexpectedly displays the Create Power View Report button when you use SSAS 2014 as a data source
  • https://support.microsoft.com/en-us/kb/3053752
• You cannot start Report Builder when the site database uses SQL Server 2012 SP2 on a server that is running System Center Configuration Manager 2007 SP2
  • https://support.microsoft.com/en-us/kb/3007081
• FIX: "Cannot access the specified path or file on the server" when you use CSV in SSMS to back up or restore database
  • https://support.microsoft.com/en-us/kb/3048627
• Not able to use PFX format certificate in SQL Server?
  • https://blogs.msdn.com/b/psssql/archive/2015/06/18/not-able-to-use-pfx-format-certificate-in-sql-server.aspx
• Operating System Error (665 – File System Limitation) Not just for DBCC Anymore
  • https://blogs.msdn.com/b/psssql/archive/2015/06/10/operating-system-error-665-file-system-limitation-not-just-for-dbcc-anymore.aspx
• Transparent Data Encryption (TDE) stuck in State 2 – Encryption in Progress
  • https://blogs.msdn.com/b/samlester/archive/2015/06/23/transparent-data-encryption-tde-stuck-in-state-2-encryption-in-progress.aspx
• SSAS error “The operation has been cancelled because there is not enough memory for the application” when there is still a lot of memory available
  • https://blogs.msdn.com/b/sqlblog/archive/2015/06/10/ssas-error-the-operation-has-been-cancelled-because-there-is-not-enough-memory-for-the-application-when-there-is-still-a-lot-of-memory-available.aspx
• SSAS DSV COM error that breaks SSDT SSAS design backward compatibility
  • https://blogs.msdn.com/b/sqlblog/archive/2015/06/10/ssas-dsv-com-error-that-breaks-ssdt-ssas-design-backward-compatibility.aspx
• “Backup and Restore Events” standard database report do not show all backup failure events
  • https://blogs.msdn.com/b/vikas_rana/archive/2015/06/26/backup-and-restore-events-standard-database-report-do-not-show-all-backup-failure-events.aspx
• Azure PowerShell : Forbidden Error: The server failed to authenticate the request
  • https://blogs.msdn.com/b/wriju/archive/2015/06/15/azure-powershell-forbidden-error-the-server-failed-to-authenticate-the-request.aspx
• Case Of the Disappearing GUI
  • https://blogs.technet.com/b/rmilne/archive/2015/06/24/case-of-the-disappearing-gui.aspx

 

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