SQL Server 2014 Service Pack 3 is now Available!!!

The SQL Server team is excited to bring you SQL Server 2014 Service Pack 3 (SP3). SQL Server 2014 SP3 contains 25+ improvements centered around performance, scalability and diagnostics based on the feedback from customers and SQL community. These improvements enable SQL Server 2014 to perform faster and scale out of the box on modern…


String or Binary data would be truncated: replacing the infamous error 8152

In the recent announcement at Ignite 2018 on the release of SQL Server 2019 CTP 2.0, the new Big Data Clusters, data virtualization, support for UTF-8, and Intelligent Query Processing were highlights. But we have also previewed work being done to address the infamous error message “String or binary data would be truncated”. This error…


Cumulative Update #12 for SQL Server 2017 RTM

The 12th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model, please visit: CU12 KB Article: https://support.microsoft.com/en-us/help/4464082 Starting with SQL Server 2017, we are adopting…


SQL Server 2019 CTP 2.0 New Features – Columnstore support for sp_estimate_data_compression_savings

Next up for new Storage Engine area features in SQL Server 2019 is an update to the sp_estimate_data_compression_savings stored procedure to add support for both columnstore and columnstore archive compression. This stored procedure has been around since SQL Server 2008 and is handy when you are evaluating whether to compress tables and indexes. The procedure…


SQL Server 2019 CTP 2.0 New Features – Introducing the Page Cracker (AKA sys.dm_db_page_info)!

Microsoft Ignite 2018 is fading away in the rearview mirror, but the excitement over all the new features and the vision shared there is just beginning. You’re probably seeing lots of buzz around the new Big Data Clusters, data virtualization and Intelligent Query Processing among others, but I wanted to take some time on the…


Cumulative Update #14 for SQL Server 2014 SP2

The 14th cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model, please visit: CU14 KB Article: https://support.microsoft.com/en-us/help/4459860 Microsoft® SQL Server® 2014 SP2 Latest Cumulative Update:…


You Should Never See This Callstack in Production

A customer who just experienced some server outage asked us for help as they thought it was due to some very long GC pauses. I thought this diagnostics exercise might be useful for other folks as well so I am sharing it with you. We had them collect a GCCollectOnly trace which showed there were…


FileStream Backup and Restore

I have been asked to provide some information on best practice for SQL Server Backup and Restore with Filestream Databases. For Backup. The method is exactly the same like you do for your regular non-Filestream databases. This means you can include your Filestream database in your current backup strategy with no additional work. For Restore….


Middle Ground between Server and Workstation GC

A long time ago I wrote about using Workstation GC on server applications when you have many instances of your server app running on the same machine. By default Server GC will treat the process as owning the machine so it uses all CPUs to do the GC work. More and more folks find themselves…