CPU Upgrade to AMD Ryzen Threadripper 2950X

About a year ago, I built a high-end desktop (HEDT) workstation based on the then, top-of-the-line 14nm AMD Ryzen Threadripper 1950X processor. This is the machine that I use for most of my daily work, and I have been quite happy with it over the past year.  Here are the main components that I used […]

AMD EPYC 7371 Processor in Q1 2019

At the Supercomputing 2018 Conference, AMD announced a special high-frequency SKU in their first-generation 14nm AMD EPYC “Naples” line of server processors that will be the AMD EPYC 7371 processor. This upcoming processor will have 16 cores and 32 threads, with a base clock speed of 3.1 GHz, boosting up to 3.6 GHz on all […]

IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017

We’ve just announced the next round on live, online training classes for the first quarter of 2019. Paul has more details about all six classes that we are offering here. I will be teaching IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017 on January 29-31, 2019. I think this is […]

Building a Modern AMD Desktop Development Workstation

Over the past 12-18 months, it has become relatively easy to build an extremely powerful AMD desktop development workstation, with plenty of compute, memory and storage performance and capacity to support some pretty serious workloads. You can also build a system for a relatively affordable cost, compared to what you had to spend in years […]

SQL Server Diagnostic Information Queries for November 2018

This month, I have just made some more minor improvements to most of the query sets. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This works for SQL Server 2008 through SQL Server 2017, for on-premises […]