(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) I was working [&]

The post The Curious Case of… how to find which page an index row is on appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/wiKlHMcPFsE/

This morning I had the great honor to be presented with a Patriot Award for supporting the U.S. Army Reserve activities of Sergeant First Class Jonathan Kehayias. Its an award for me as Im Jonathans supervisor; and for SQLskills as a company, Kimberly signed the statement of continuing support for the Guard and Reserve. I [&]

The post Honored to receive a Patriot Award appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/VJ6RUaAfKeQ/

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) Erin worked with [&]

The post The Curious Case of& very long failover times with a large ad hoc workload appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/zK3F8JZGv8o/

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) I had a [&]

The post The Curious Case of& does SQL Server use a read/write thread per LUN? appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/PSWIc3Q3rVo/

We thought we were only going to present in-person classes in Spring this year, but as IEPTO1 and IEAzure both sold out and had long wait lists, weve added new deliveries of those classes in October! Our classes in October will be in Chicago, IL at our main event hotel as usual: IEPTO1: Immersion Event on Performance [&]

The post October IEPTO1 and IEAzure classes open for registration appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/HWzbCIAeEmU/

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) Continuing on from [&]

The post The Curious Case of& trying to find an MDF file in a RAW disk appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/UELvR1x-FO4/

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) A couple of [&]

The post The Curious Case of& how to find FILESTREAM info from an MDF appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/lhe80QtgJiQ/

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) Jonathan was working [&]

The post The Curious Case of& the CLR assembly failure after an AG failover appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/AMB-w3oox8s/

As we head towards our SQLintersection Spring 2019 in June (our 13th show), Im excited to say that its once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is that attendees love SQLintersection because its a smaller, laid-back show, where you get to [&]

The post SQLintersection Spring 2019 appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/Qrfy6eL8tyY/

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) Last week I [&]

The post The Curious Case of& unstoppable DBCC CHECKDB appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/rr6iEvTxt6g/

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) I was contacted [&]

The post The Curious Case of& faster disks causing more WRITELOG waits appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/F5rC6VSQHWc/

Last week I blogged about Using the Wait Statistics Report in Azure Data Studio, using a Linux VM in Azure as an example host. As that was my first time running wait stats analysis on a Linux host, I found that the PREEMPTIVE_OS_FLUSHFILEBUFFERS wait will show up as the top wait on Linux on SQL [&]

The post PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/qU6BEuU47Qw/

(The Curious Case of& used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.) I [&]

The post The Curious Case of& copying FILESTREAM files between tables appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/Hl7v_HieVxc/

Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report as part of Server Reports extension. In this quick post Ill show you how to install [&]

The post Using the Wait Statistics Report in Azure Data Studio appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/FTaVzbxJdaY/

Im working with Red Hat Enterprise Linux (RHEL) VMs on Azure and one of the best practices that Microsoft recommends is to change the default SSH port from 22 to something else. I was looking for a consolidated set of instructions to do this and I couldnt find one, so I thought Id do a [&]

The post Changing the SSH port for a RHEL Azure VM appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/kb3FVXwkySA/

& I emigrated to the United States. I boarded a plane in Glasgow with my (then) wife Sylvia, bounced in Amsterdam and then landed in Seattle, entering the US on an H1B visa after almost five years of working for DEC/Digital. We arrived in temp housing a block away from the Microsoft Campus late in [&]

The post Twenty years ago today& appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/J2BEdcDC8To/

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers that have been my life this year. 1,007,636: my lifetime total butt-in-seat miles on United, making me a Million-Mile Flyer 72,661: the number of miles I flew on United [&]

The post 2018 review: the year by the numbers appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/KN-nqtEbPT4/

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017) and people have been enjoying it, so here I present the 2018 end-of-year post. I set a moderate goal of 50 books this year but obliterated that and [&]

The post 2018: the year in books  a new record! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/_uZPAEZRowM/

No only has Tim been working heavily with Azure in 2018, hes also been diving into the various reporting solutions that SQL Server has, and hes ready to share his knowledge with the world in his new class on Power BI! It’s a two-day class called IEPowerBI: Immersion Event on Power BI, Power BI Report Server, and [&]

The post New class: Immersion Event on Power BI, Power BI Report Server, and SSRS appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/H7-FdWIrIqw/

Its Cyber Monday today, and now that youve finished picking up great deals for your personal life, how about a great deal for your professional life? From now through 12pm PST on Thursday, November 28th 2018, the first 25 people to register using a credit card can pick up our 6-course combo (covering all six [&]

The post Cyber Monday special on 2019 live, online classes 6-pack  save $199 per class! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/jADc6buorCM/