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. “.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. Description.

IoT 61

IoT Servers Development Cache 61

SQL Server According to Bob

DECEMBER 18, 2018

I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. This means data can be stored in file system cache, non-stable media. ) The issue, as described in the link, is that the sync returns the error but may clear the state of the cached pages.

Servers 40

Servers Media Cache Software Engineering 40

ACM Sigarch

FEBRUARY 23, 2018

Richard Thaler won the 2017 Nobel prize in Economics for his work on Behavioral Economics. 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.

Architecture 47

Architecture Cache Hardware Virtualization 47

SQL Server According to Bob

DECEMBER 31, 2018

How It Works: XEvent Output and Visualization SQL Server Management Studio Provides–“XE Profiler” Use the SSMS XEvent Profiler. Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. TSQL Sample Session.

Efficiency 40

Efficiency Code Servers Cache 40