Opinions, tips, and news orbiting Microsoft
Moved from: bobsql.com
Windows provides an option for CreateFile to delete a file when the file is closed (FILE_FLAG_DELETE_ON_CLOSE.)
Host Extension Handling
Linux does not expose such an option as part of the … Continue reading SQL Server on Linux: How is Delete-On-Close Handled
Moved from: bobsql.com
Dylan (who kindly wrote up the contents of this blog for me) was modifying the tests for Active Directory Login activities. As Dylan and I reviewed the changes a specific behavior involving Active Directory Group Log… Continue reading SQL Server Mysteries: The Case of the Dropped AD Group Login
Moved from bobsql.com
Today I was tracking a large BCP.exe ‘IN’ operation and monitoring the sys.dm_exec_requests entries. The ‘BULK INSERT’ command entry appeared, showing the CPU, reads, writes, … but these values where getting… Continue reading SQL MYSTERIES: Tracing BCP Might Fool You
Moved from: bobsql.com
SQL Server Books Online documents Instant File Initialization and the associated security considerations. This blog highlights the underlying file system implementations and differences in behavior be… Continue reading SQL Server Instant File Initialization: SetFileValidData (Windows) vs fallocate (Linux
In February, the MVP blog is looking at those helping diverse communities around the world.
Microsoft MVPs have a reputation for being high-flyers – and arguably no more so than Mario Trentim.
In addition to Mario’s impressive tech backgr… Continue reading Helping Brazilians In STEM
Moved from: bobsql.com
Overview
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
&nbs… Continue reading SQL Server On Linux: Forced Unit Access (Fua) Internals
Moved from: bobsql.com
I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article.
An example of the error: The application does … Continue reading SQL Server Linux: fsync and Buffered I/O
Moved from: bobsql.com
When Creating, Renaming or Deleting (remove/unlinking) a file, Linux requires the direct parent directory to be synchronized. As documented in the manpage for fsync core changes to the directory require the… Continue reading SQL Server Linux: Directory fsync Activities