2016 Database Hardware Servers 
SQL Server According to Bob
JUNE 3, 2016
SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. The following chart shows the same 1TB database testing. SQL Server. SQL Server 2014.
SQL Performance
NOVEMBER 1, 2019
As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Server According to Bob
JULY 13, 2016
20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 desktop machine (I won’t tell you the hardware details. There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use.
Alex Podelko
OCTOBER 20, 2016
I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. System’s configuration is not given anymore and often can’t be easily mapped to hardware. – Cloud. – Agile. – Continuous Integration.
Rigor
MARCH 20, 2018
I recently was asked the following question by an online retailer: “Why should I invest in monitoring the user experience when I already have monitoring for our database, infrastructure, app server, and network?”. This is a big deal when those resources often make up > 75% of the user experience. The Rise of Cloud Computing.
SQL Server According to Bob
DECEMBER 18, 2018
SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.
Smashing Magazine
JANUARY 15, 2019
The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. So, apart from powering servers with renewable energy, what else can web developers do about climate change? You Can’t Manage What You Can’t Measure”.
Expert insights. Personalized for you.
40 
Let's personalize your content