SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. As the following diagram shows the SQL Server Log Cache is in memory.

Cache 40

Cache Servers Media Storage 40

SQL Server According to Bob

JUNE 27, 2016

To some of you SQL Server On Linux is old news from various announcements made a couple of months ago. Yes, SQL Server runs on Linux! It was Jan 2015, in my previous supportability role, that I started looking at SQL Server on Linux. I proceeded to install an Ubuntu VM and the internal build of SQL Server on Linux.

Servers 40

Servers Games Azure Testing 40

SQL Server According to Bob

JUNE 9, 2016

SQL Server, as outlined in the following post ( [link] ) adjusts to various processor configurations. I have received questions related to how SQL Server accomplishes the alignment on both bare metal and VM installations. SQL Server uses Windows APIs to determine the processors and package interactions. GetSystemInfo [link].

Servers 40

Servers Virtualization Architecture Tuning 40

SQL Server According to Bob

JANUARY 5, 2017

Last March I moved from 22 years in SQL Server support to the SQL Server development team, working on SQL Server on Linux project and reporting to Slava Oks. As Slava highlights in his recent blog post , he also contacted me in early 2015 to assist with supportability of SQL Server on Linux. There are no burning secrets.

Servers 40

Servers Operating System C++ Software Engineering 40

O'Reilly

FEBRUARY 4, 2025

In the early days of the personal computer, every computer manufacturer needed software engineers who could write low-level drivers that performed the work of reading and writing to memory boards, hard disks, and peripherals such as modems and printers. Schillace asks, What if traditional software engineering isnt fully relevant here?

Programming 145

Programming Google Infrastructure Internet 145

SQL Server According to Bob

AUGUST 23, 2016

The creation of the XTP, common access DLL requires SQL Server to generate C code, invoke the C compiler and save the DLL into the XTP directory. Bob Dorr – Principal Software Engineer SQL Server. These are additional steps that a disk based table does not perform.

C++ 40

C++ Software Engineering Servers Code 40

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

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40

Servers Azure Engineering Java 40

Rigor

SEPTEMBER 11, 2019

Rick is a software engineer on the Google Chrome team, “leading an effort to make the web just work for developers.” Follow him on Twitter @ RickByers and be sure to watch the video of his conversation at Chrome Dev Summit 2016 , where he discussed the ways Chrome is “improving predictability for developers.”

Performance 89

Performance Education Google Website 89