Archive
Issues with CU6 for SQL Server 2014 SP1
Microsoft released an update to CU6 (link) for SQL Server 2014 SP1; this update was to address an issue where even having NOLOCK hint in queries was leading to blocking and deadlocks in the default SQL Server lock-based isolation level or high levels. From the KB article:
Executing a parallelized SELECT (…) INTO Table FROM SourceTable statement, and specifically using the NOLOCK hint, under the default SQL Server lock-based isolation level or higher. In this scenario, other queries that try to access SourceTable will be blocked.
While one transaction is holding an exclusive lock on an object (for example, an ongoing table update), another transaction is executing parallelized SELECT (…) FROM SourceTable by using the NOLOCK hint. In this scenario, the SELECT query that is trying to access SourceTable will be blocked.
Reference: CU6 for SQL 2014 SP1 (Deprecated) [Link].
Therefore if you have the older build installed (12.0.4449) please update to newer build (12.0.4457).
This post is cross posted on my SQLCAN Blog, MSDN Blog, and SQL server Consultation blog.
SQL Server 2016 Launch Event in Edmonton SQLPASS
SQL Server 2016 release date is June 1st; to help get the moment started, Edmonton SQL Pass is holding a launch event on June 25, 2016. Keep your calendar clear and come on down. Not a lot of seats open. Register here!
I am going, see Edmonton SQL Geeks there :).
SQL Skills: SQL Server Wait Types & Latch Classes Library
Microsoft has documented wait types and latches in a minimum fashion on books online; often there are wait types that are just not documented.
Paul Randel (Blog|Twitter) has put together compressive list of these with recommendations and even SQL dump traces.
Check it out here..
SQL Server 2016 Release Date
SQL Server 2016 GDR has been set to release on June 1, 2016 (Ref).
SQL 2016 is going to be a major blast in how SQL Server is used for OLTP, OLAP and how it integrates with Microsoft Azure. If you are not already playing with it, take time to install it and explore the gems hidden in multitude of new functionality.
SQL Server 2014 & 2016 Developer Edition
Microsoft SQL Server has been in developer edition as far back as 2005 (if my memory serves me); however each license was $50.00. Now with SQL Server 2014 & 2016, Microsoft has made developer edition free.
There is no better time to get on board with SQL Server 2016, there are lots of new functionality and features available. That can help your organization reach new levels of performance, scalability, and data insight.
Download and start playing with SQL 2014 here.
SQL Server 2016 RC3 Released
SQL Server 2016 RC3 has been released, it is the final release before RTM. In this release no major functionality is introduced.
Download from here.
SQLPASS Edmonton (Apr. 9, 2016) – Key Note Presentation
Friday/Saturday was a great day, got to meet lots of wonderful people from US/Canada at the Alberta’s first SQL Saturday. I delivered they Key Note speech for SQL Server 2016. I would love to hear back from people, so please provide evaluation on SQL Saturday site and you can download the PowerPoint deck here.
Microsoft SQL Server 2016 RC2 Released
In SQL Server 2016 RC 2, enhancements include:
- R Services setup – the setup process for R Services is much more integrated into SQL Server setup. There is no longer a need to manually download and install Microsoft R open and R Server if the SQL Server is connected to the Internet; it becomes part of the SQL Server install sequence.
- SQL Server Management Studio (SSMS) – This release of SSMS features an update to the Visual Studio 2015 shell bringing enhancements such as the quick launch toolbar and improved theming support.
- Mobile reports – Brand Packages will now be downloaded to the mobile report publisher from a server running RC2 and available for use in report creation. Basic mobile report content migration between servers is now supported.
SQL Server PFE Position in Canada
ROLE DESCRIPTION
The Premier Field Engineer provides advanced on-site and remote technical troubleshooting support and problem resolution for Microsoft Premier Customers. Candidate must be able to resolve complex issues escalated to the highest levels of management while ensuring satisfaction with Microsoft software by setting customer expectations, devising and implementing action plans and professionally communicating to all parties involved.
https://careers.microsoft.com/jobdetails.aspx?ss=&pg=0&so=&rw=6&jid=146017&jlang=en&pp=ss
Check it out guys and gals; if your intersted, feel free to ping me here or linked in :).
