SQL Server According to Bob
Come here for knowledge about SQL Server uniquely provided by the two Bobs at Microsoft
SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction...
Date: 02/11/2019
This blog takes you through the debugging journey, refreshing us on old concepts and introducing...
Date: 02/10/2019
SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation,...
Date: 02/10/2019
I was doing backups and clean-ups and ran across a couple of sample projects for XEvent and...
Date: 12/31/2018
When Creating, Renaming or Deleting (remove/unlinking) a file, Linux requires the direct parent...
Date: 12/18/2018
I was asked to validate the SQL Server behavior in light of the error condition involving...
Date: 12/18/2018
Overview SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data...
Date: 12/18/2018
SQL Server Books Online documents Instant File Initialization and the associated security...
Date: 12/10/2018
Today I was tracking a large BCP.exe ‘IN’ operation and monitoring the sys.dm_exec_requests entries....
Date: 08/07/2018
Dylan (who kindly wrote up the contents of this blog for me) was modifying the tests for Active...
Date: 08/03/2018
Windows provides an option for CreateFile to delete a file when the file is closed...
Date: 07/31/2018
When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status...
Date: 07/18/2018
I have been asked several times about how to get a Performance Monitor like view on Linux. There are...
Date: 05/20/2018
When I graduated from college, one of the first computers I ever used was a MacIntosh. I loved the...
Date: 04/24/2018
What does improving resource usage on smaller machines really mean?...
Date: 03/18/2018
Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not...
Date: 02/22/2018
I have the blessed opportunity to speak at many customer events. SQLBits is always one of my...
Date: 02/15/2018
SQL Server on Linux uses the GSSAPI and SSSD service for Active Directory (AD) authentication...
Date: 02/05/2018
I have found the term DTC is used in many ways so for the purposes of the discussion here are a few...
Date: 01/28/2018
I've had such a long, great history with the PASS Summit, Community, and all the great people that...
Date: 01/12/2018
Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Quick XE Trace’...
Date: 12/26/2017
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!!!
SQL Server 2019 CTP2 SQL Server 2019 adds broad support for distributed transactions (both...
Date: 12/11/2017
Updated Content! Please check out these new resources for SQL Server 2017 and SQL Server on Linux...
Date: 10/26/2017
Please check out a new blog post I created detailing how SQL Server 2017 is Fast, Built-In. Faster...
Date: 09/27/2017
Scott Guthrie and Rohan Kumar officially made the announcement today at Ignite that SQL Server 2017...
Date: 09/25/2017
I ran into a scenario showing my session as suspended, awaiting command and blocked! My first...
Date: 06/09/2017
The trace flag 1222 can be very powerful and helpful in tracking down the cause of a deadlock when...
Date: 05/23/2017
I recently visited a customer onsite and presented to them topics on SQL Server 2016. After the...
Date: 04/25/2017
I recently visited a customer onsite and presented to them topics on SQL Server 2016. After the...
Date: 04/21/2017
As pointed out in my previous post, debugging on Linux brings a few new twists to those of us used...
Date: 03/27/2017
Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory...
Date: 01/31/2017
You are aware of our statements indicating “Microsoft Loves Linux.” Over the last couple of years...
Date: 01/29/2017
I’m a huge Sherlock Holmes fan (I’ve read all the books, watch Elementary on CBS every week, and...
Date: 01/26/2017
In my last post I highlighted the marriage of PE and ELF images within the same process space to...
Date: 01/24/2017
Last March I moved from 22 years in SQL Server support to the SQL Server development team, working...
Date: 01/05/2017
Back in June, Bob Dorr gave you the thinking behind why SQL Server 2016 It Just Runs Faster due to...
Date: 11/29/2016
Note: We received feedback that there was some confusion on us calling this functionality "tail of...
Date: 11/08/2016
Back in July, I told you about a new installation experience for SQL Server. One of our goals from...
Date: 10/03/2016
When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to...
Date: 09/26/2016
Yesterday I had a discussion with a customer and realized that the BCP, TDS pattern could use a bit...
Date: 09/16/2016
I was approached to revisit the details of how Error Message 833 is detected and reported. SQL...
Date: 09/01/2016
I had an interesting e-mail discussion related to the performance of create table. The test being...
Date: 08/23/2016
Have you encountered the following in your SQL Server error log? Long Sync IO: Scheduler 95 had 1...
Date: 08/17/2016
I was asked about these terms from a blog reader. As I thought about these terms and how to blog...
Date: 08/08/2016
I have written on this subject before but it seems to come up from time to time, as it did again...
Date: 08/04/2016
This post is not about a specific SQL Server object but instead outlines a technique used in various...
Date: 07/23/2016
20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here...
Date: 07/13/2016
Erin Stellato and Jonathan Kehayias from sqlskills reached out asking for clarification of trace...
Date: 07/12/2016
There are a variety of posts talking about the black box recorder (XEL Health Session) explaining...
Date: 07/04/2016
To some of you SQL Server On Linux is old news from various announcements made a couple of months...
Date: 06/27/2016