SQL Updates Newsletter – December 2015

  Recent Releases and Announcements SQL Server 2014 RTM CU11 https://support.microsoft.com/en-us/kb/3106659 SQL Server 2014 SP1 CU4 https://support.microsoft.com/en-us/kb/3106660 SQL Server 2012 SP3 https://support.microsoft.com/en-us/kb/3072779 SQL Server 2012 SP2 CU9 https://support.microsoft.com/en-us/kb/3098512 Windows Server 2016 Technical Preview 4 https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-technical-preview System Center 2016 Technical Preview 4Evaluations https://www.microsoft.com/en-us/evalcenter/evaluate-system-center-technical-preview Announcing SQL Server Management Studio – December 2015 Release http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/12/17/announcing-sql-server-management-studio-december-2015-release.aspx SQL Server Data…

0

SQL Updates Newsletter – October/November 2015

Recent Releases and Announcements SQL Server 2016 CTP 3 Preview https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 http://blogs.technet.com/b/dataplatforminsider/archive/2015/10/28/sql-server-2016-community-technology-preview-3-0-is-available.aspx Revolution R integration included in SQL Server 2016 CTP 3.0: http://blogs.technet.com/b/stbnewsbytes/archive/2015/10/28/cloud-platform-release-announcements-for-october-28-2015.aspx SQL Server 2014 SP1 CU3 released http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/10/22/cumulative-update-3-for-sql-server-2014-sp1.aspx https://support.microsoft.com/en-us/kb/3094221 Gartner positions Microsoft as a leader in the Magic Quadrant for Operational Database Management Systems http://blogs.technet.com/b/dataplatforminsider/archive/2015/10/15/gartner-positions-microsoft-as-a-leader-in-the-magic-quadrant-for-operational-database-management-systems.aspx Azure Data Platform Announcements Azure Data Lake: Analytic…

0

SQL Updates Newsletter – September 2015

Recent Releases and Announcements SQL Server 2016 Community Technology Preview 2.4 is here! http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 http://blogs.technet.com/b/dataplatforminsider/archive/2015/09/30/sql-server-2016-community-technology-preview-2-4-is-available.aspx Cumulative Update 8 for SQL Server 2012 SP2 https://support.microsoft.com/en-us/kb/3082561 Announcing SQL Server Management Studio – September 2015 Release http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/09/30/announcing-sql-server-management-studio-september-2015-release.aspx SQL Server Data Tools Preview update for September 2015 http://blogs.msdn.com/b/ssdt/archive/2015/09/30/sql-server-data-tools-preview-update-for-september-2015.aspx The SQL Server product team is looking for feedback and your…

0

SQL Updates Newsletter – July/August 2015

Recent Releases and Announcements SQL 2016 CTP 2.3 has been released http://www.microsoft.com/en-us/download/details.aspx?id=48726 Cumulative Update package 7 for SQL Server 2012 Service Pack 2 https://support.microsoft.com/en-us/kb/3072100 If you are using keyset cursors, please review http://blogs.msdn.com/b/psssql/archive/2015/07/16/how-it-works-sql-server-sqlncli11-odbc-driver-keyset-cursor.aspx which discusses improvements in the updated release of SQLNCLI11 and MSSQLODBC drivers Cumulative update 2 for SQL Server 2014 SP1 https://support.microsoft.com/en-ca/kb/3075950 MS15-058:…

0

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 http://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 http://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…

0

Duplicate SPN: What is it really?

If you look at many of the references regarding Kerberos troubleshooting, one of the common recommendations is to verify duplicate service principal names (SPNs) do not exist. I mention this myself in the SQL Server Kerberos and SPN Field Guide here. But what do we really mean by that?   SPN is a String Attribute of an…

1

SQL Updates Newsletter – May 2015

Recent Releases and Announcements  SQL Server 2014 Service Pack 1 is now available http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/05/15/sql-server-2014-service-pack-1-is-now-available.aspx Cumulative Update #16 for SQL Server 2012 SP1 http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/05/18/cumulative-update-16-for-sql-server-2012-sp1.aspx NOTE: This is the final Cumulative Update for SQL Server 2012 Service Pack 1.  SQL Server 2012 SP1 exits service pack support on July 14, 2015. Upcoming end of support for SQL…

0

Understanding User Account Control (UAC), A Brief Summary

Below are some notes I took while troubleshooting a UAC issue. I found it useful to understand the difference between Rights and Permissions, as well as how to identify when UAC was coming into play. What is the Difference Between Permissions and Rights (Privileges)? Permissions apply to Objects A permission is an authorization to perform…

0

Troubleshoot Runaway Queries in SQL 2014 Using sys.dm_exec_query_profiles

Scenario You are tasked to identify the bottleneck of a slow or problematic T-SQL query which either never finishes, takes many hours to complete, or fails after many hours (for example with a tempdb space error). You would like to view execution plan details and runtime statistics while the query is still executing. The Challenge…

1

How to Start or Stop SQL Services without OS Admin Rights

Scenario You wish to grant users who do NOT have OS administrative rights the ability to start/stop SQL Server & SQL Agent services. Please review the following related blog post: http://blogs.msdn.com/b/sqlupdates/archive/2015/05/14/how-to-start-or-stop-sql-services-without-uac-prompts.aspx (Note: to see the pictures below at a better resolution, please click on the picture and this will open a link to the source…

0