The Curious Engineer

All blogs / Databases

SQL Server According to Bob

learn.microsoft.com/en-us/archive/blogs/bobsql

Come here for knowledge about SQL Server uniquely provided by the two Bobs at Microsoft

DatabasesLinux / UnixPerformance / optimizationWindows internalsMicrosoft blogsMSDN archive

’16’17’18’19’20’21’22’23’24’25’26
Posts
80 from 3 Jun 2016 to 11 Feb 2019
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/bobsql/feed.xml

2019 3

  1. SQL Server Log Writer Workers
  2. SQL Mysteries: SQL Server Login Timeouts – A Debugging Story
  3. SQL Server Worker Thread Default Calculation

2018 17

  1. Viewing and Sorting XEvents Efficiently (Code Samples) - XEProfiler
  2. SQL Server Linux: Directory fsync Activities
  3. SQL Server Linux: fsync and Buffered I/O
  4. SQL Server On Linux: Forced Unit Access (Fua) Internals
  5. SQL Server Instant File Initialization: SetFileValidData (Windows) vs fallocate (Linux)
  6. SQL MYSTERIES: Tracing BCP Might Fool You
  7. SQL Server Mysteries: The Case of the Dropped AD Group Login
  8. SQL Server on Linux: How is Delete-On-Close Handled
  9. SQL Server on Linux: Why Do I Have Two SQL Server Processes
  10. SQL Server on Linux: Quick Performance Monitoring
  11. Take the SQL Server Mac challenge
  12. SQL Server 2017 Improved Resource Usage On Smaller Machines
  13. SQL Server on Linux: CU4 - NewSequentialId() – Uuid
  14. Microsoft Engineering loves SQLBits
  15. SQL Server on Linux: Kerberos Troubleshooting, Hints and Tips and Hard Code Debugging
  16. How It Works: SQL Server DTC (MSDTC and XA Transactions)
  17. Let's talk SQL Server to kick off the PASS Facebook Live series

2017 15

  1. SQL Server Management Studio Provides–“XE Profiler”
  2. SQL Server Linux: Distributed transactions requiring the Microsoft Distributed Transaction Coordinator service are not supported on SQL Server running on Linux. SQL Server to SQL Server distributed transactions are supported. – CLARIFIED!!!
  3. Experience SQL Server 2017: Start your journey here
  4. Experience SQL Server 2017: The Fast and the Furious
  5. SQL Server 2017 generally available on October 2nd...
  6. SQL Server Mysteries: The Case of the Suspended, Awaiting Command, and Blocked Session
  7. How It Works: SQL Server Deadlock Trace Flag 1222 Output
  8. SQL Server Mysteries: The Case of the Not 100% RESTORE…
  9. SQL Server Mysteries: The Case of the Not 100% RESTORE…
  10. SQL Server On Linux: Core-minidumps and Breakpad
  11. SQL Server on Linux: Scatter/Gather == Vectored I/O
  12. SQL Server on Linux: An LLDB Debugging Tale
  13. SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption
  14. SQL Server on Linux: Debugging ELF and PE Images (dbgbridge)
  15. SQL Server on Linux: ELF and PE Images Just Work

2016 45

  1. How It Works (It Just Runs Faster): Auto Soft NUMA…
  2. How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM
  3. The SQL Server Installer Version 2: Just Install It!
  4. SQL Server 2016 - It Just Runs Faster: Always On Availability Groups Turbocharged
  5. How It Works: BULK INSERT (BCP) TDS Traffic
  6. How It Works: How is SQL Server Error 833, 15 Sec I/O Detected
  7. Create Table – Disk vs In-Memory Optimized
  8. How It Works: Sync IOs in nonpreemptive mode longer than 1000 ms
  9. COLD, WARM, HOT … CLEAN, DIRTY, FREE … What Does All This Mean?
  10. How It Works: Session/SPID (–2) for DTC Transactions
  11. How It Works: Reader / Writer Synchronization
  12. The SQL Server Basic Installer: Just Install It!
  13. DBCC Trace Flags 2562 and 2549
  14. How it Works: XEL Health Session and Shutdown
  15. What Am I Working On (RDORR): SQL Server On Linux
  16. Does SQL Server 2016 Require Trace Flag -T8048?
  17. Unresolved Deadlock vs Scheduler Deadlock
  18. SQL 2016–Install MSVC Patch Required
  19. How It Works: How SQL Server Determines Logical and Physical Processors
  20. How It Works: SQL Server 2016 SSE/AVX Support
  21. SQL 2016 - It Just Runs Faster Announcement
  22. SQL 2016 - It Just Runs Faster: DBCC Scales 7x Better
  23. SQL 2016 - It Just Runs Faster: DBCC Extended Checks
  24. SQL 2016 - It Just Runs Faster: Native Spatial Implementation(s)
  25. SQL 2016 - It Just Runs Faster: TVPs with Spatial Column(s)
  26. SQL 2016 - It Just Runs Faster: Spatial Index Builds Faster
  27. SQL 2016 - It Just Runs Faster: -T1117 and -T1118 changes for TEMPDB and user databases
  28. SQL 2016 - It Just Runs Faster: Automatic TEMPDB Configuration
  29. SQL 2016 - It Just Runs Faster: LDF Stamped
  30. SQL 2016 - It Just Runs Faster: Instant File Initialization
  31. SQL 2016 - It Just Runs Faster: Automatic Soft NUMA
  32. SQL 2016 - It Just Runs Faster: Updated Scheduling Algorithms
  33. SQL 2016 - It Just Runs Faster: Dynamic Memory Object (CMemThread) Partitioning
  34. SQL 2016 - It Just Runs Faster: SOS_RWLock Redesign
  35. SQL 2016 - It Just Runs Faster: Indirect Checkpoint Default
  36. SQL 2016 - It Just Runs Faster: Larger Data File Writes
  37. SQL 2016 - It Just Runs Faster: Multiple Log Writer Workers
  38. SQL 2016 - It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)
  39. SQL 2016 - It Just Runs Faster - BULK INSERT Uses Vector Instructions (SSE/AVX)
  40. SQL 2016 - It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches
  41. SQL 2016 - It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms
  42. SQL 2016 - It Just Runs Faster - AlwaysOn AES-NI Encryption
  43. SQL 2016 - It Just Runs Faster: In-Memory Optimized Database Worker Pool
  44. SQL 2016 - Leverages On Demand MSDTC Startup
  45. SQL 2016 - It Just Runs Faster: XEvent Linq Reader