SQL Server Kerberos and SPN Quick Reference

  This post contains the references and methodology I use when troubleshooting SQL Kerberos issues. While there are already many SQL Kerberos articles in existence, the goal here is to provide a central and up-to-date resource(including new tools + updated tool syntax) which covers not just the configuration steps, but an understanding of why this…

5

SQL Updates Newsletter – July 2017

Recent Releases and Announcements First release candidate of SQL Server 2017 now available Linux support for tier-1, mission-critical workloads; Note that with RC1, SQL Server on Linux supports Active Directory Authentication SQL Server on Linux can use TLS to encrypt data that is transmitted across a network between a client application and an instance of…

3

SQL Updates Newsletter – May 2017

Recent Releases and Announcements SQL Server 2017 CTP 2.1 now available The primary enhancement to SQL Server 2017 in this release is the ability to configure SQL Server configuration settings through environment variables passed in as parameters to Docker run. This enables many of the SQL Server configuration scenarios in Docker containers such as setting…

2

SQL Updates Newsletter – December 2016

Recent Releases and Announcements GDR update package for SQL Server 2016 SP1 https://support.microsoft.com/en-us/kb/3210089 GDR update package for SQL Server 2016 RTM https://support.microsoft.com/en-us/kb/3210111 On-demand hotfix update package for SQL Server 2016 CU3 https://support.microsoft.com/en-us/kb/3210110 Cumulative Update #10 for SQL Server 2014 SP1 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-10-for-sql-server-2014-sp1/ Cumulative Update #3 for SQL Server 2014 SP2 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-3-for-sql-server-2014-sp2/ SQL Server v.Next CTP 1.1…

1

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

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

SQL Updates Newsletter – February 2017

Recent Releases and Announcements Cumulative Update #4 for SQL Server 2014 SP2 https://support.microsoft.com/en-us/help/4010394/cumulative-update-4-for-sql-server-2014-sp2 Cumulative Update #11 for SQL Server 2014 SP1 https://support.microsoft.com/en-us/help/4010392/cumulative-update-11-for-sql-server-2014-sp1 SQL Server vNext CTP 1.3 now available Always On Availability Groups on Linux Resumable online index rebuilds enables users to recover more easily from interruption of index builds, or split an index build…

1

SQL Updates Newsletter – September 2016

Recent Releases and Announcements SQL Server 2016 – CU2 https://support.microsoft.com/en-us/kb/3182270 SQL Server 2012 SP3 – CU5 https://support.microsoft.com/en-us/kb/3180915 SQL Server 2012 SP2 – CU14 https://support.microsoft.com/en-us/kb/3180914 Azure SQL Database v12 has landed in Azure Government https://blogs.msdn.microsoft.com/azuregov/2016/09/27/azure-sql-database-v12-generally-available-in-azure-government/ Announcing the launch of Windows Server 2016 At our Ignite conference in Atlanta we launched the newest release of our server…

1

SQL Updates Newsletter – April 2015

Recent Releases and Announcements Microsoft Disaster Response – Nepal Earthquake http://blogs.technet.com/b/microsoft_corporate_disaster_response_blog/archive/2015/04/27/microsoft-disaster-response-nepal-earthquake.aspx?pi47623=3 An updated announcement regarding the SQL Server 2014 Service Pack 1 release http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/04/16/sql-server-2014-service-pack-1-has-released.aspx Although the package was only briefly available on the Microsoft Download Center, we apologize for this mistake and the inconvenience you may have encountered as a result. The original release was…

1

SQL Updates Newsletter – January 2016

Recent Releases and Announcements Changes to SQL cumulative update download process: SQL cumulative updates are now available in the download center. No longer requires hotfix server registration, can now download via self-service download link SQL Server 2012 SP2 CU10 https://support.microsoft.com/en-us/kb/3120313 SQL Server 2012 SP3 CU1 https://support.microsoft.com/en-us/kb/3123299 Windows Enforcement of Authenticode Code Signing and Timestamping impact…

1