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

Next>