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. SQL Server 2016 is designed to detect non-volatile storage devices.

Cache 40

Cache Servers Media Storage 40

Rigor

SEPTEMBER 11, 2019

Rachel is also one of the people behind Perch , a PHP content management system (CMS). Rick is a software engineer on the Google Chrome team, “leading an effort to make the web just work for developers.” She works directly with organizations to build clear and coherent products and design systems. Rick Byers.

Performance 89

Performance Education Google Website 89

SQL Server According to Bob

JANUARY 5, 2017

By March of 2016 Slava had convinced me to join the team. Without going into details, you boot your laptop or server and don’t give a thought about the binary format(s) of the operation system. The computer works the same way if made by IBM, HP, Dell or other vendor no matter what the operating system.

Servers 40

Servers Operating System C++ Software Engineering 40

SQL Server According to Bob

AUGUST 23, 2016

Update System Table Info. Bob Dorr – Principal Software Engineer SQL Server. Let’s take a high level look at the create table activities. Disk Based. In-Memory Optimized. Parse T-SQL. Build Create Plan. Execute Plan. Create Access DLL Code. Compile Access DLL.

C++ 40

C++ Software Engineering Servers Code 40

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. The APP begins an XA or MSDTC transaction and enlists all the other end-points it requires in the transaction (File System, Oracle, PostreSQL, DB2, …) These end-points all become part of the distributed transaction and are controlled under the 2-phase protocol.

Servers 40

Servers Azure Engineering Java 40

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

JUNE 9, 2016

SQL Server 2016, automatic soft NUMA avoids assignment of logical processors from the same package to the same soft NUMA node. What Is Your System Showing? We can use the output to map the system capabilities and SQL Server behavior. This is the output from my 8 processor system. For example. RML Install: [link].

Servers 40

Servers Virtualization Tuning Architecture 40