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.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

JUNE 6, 2016

As indicated, SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance. This post will outline SQL Server’s decisions around SSE/AVX or software algorithm use. SQL Server asks the CPU if it supports SSE or AVX in order to determine the level of hardware support present on the system.

Servers 40

Servers Hardware Software Engineering Software 40

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link]. Follow-up.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

The Morning Paper

FEBRUARY 18, 2020

Many of the software engineering discipline and controls need to be brought over into an ML context. Inference (scoring) engines will be deployed everywhere, and ML scoring will be deeply integrated into the DBMS "as a foundational extension of relational algebra, and an integral part of SQL query optimizers and runtimes."

Government 95

Government Software Engineering Storage Database 95

The Netflix TechBlog

FEBRUARY 9, 2021

Server-generated assets, since client-side generation would require the retrieval of many individual images, which would increase latency and time-to-render. However, it would be cost-inefficient to leverage this same hardware for lightweight and more consistent traffic patterns that an asset management service requires.

Engineering 165

Engineering Storage Latency Entertainment 165

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. Ryan Stonecipher – Principle SQL Server Software Engineer. SQL Server.

Hardware 40

Hardware Cache Servers Software Engineering 40

ACM Sigarch

FEBRUARY 23, 2018

In industry, engineers (me included) sometimes attack a problem with the tools they have readily available rather than taking a step back and examining the issue at large. Hardware engineers design and implement solutions in RTL, while software engineers attempt to solve the problem either at the OS or application level.

Architecture 47

Architecture Cache Hardware Virtualization 47