Happy Fourth of July to all who celebrate! Im looking forward to a great view Thursday evening looking west along the Skagit Valley with some friends up at Camp Savage. Ive just made our 2024 SQLskills Summer School Savings SALE live! Im running some crazy prices on all courses and bundles through the end of [&]

The post Summer School Savings SALE is live! appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/summer-school-savings-sale-is-live/

(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.) This ones from [&]

The post The Curious Case of& missing log information appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-missing-log-information/

(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.) We had an [&]

The post The Curious Case of& missing 832 errors during memory corruption appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-missing-832-errors-during-memory-corruption/

(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.) Several times a [&]

The post The Curious Case of& recovering from a ransomware attack appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-recovering-from-a-ransomware-attack/

Weve added the ability to purchase a self-service health check using a credit card  no more waiting for a scoping call and then budget approval, just click and go! Once you purchase the health check, you get access to our health check package you can immediately run and then securely upload the data for [&]

The post 30%-off health checks and self-service via credit card  no waiting! appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/30-off-health-checks-and-self-service-via-credit-card-no-waiting/

Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve been an alcoholic. A maintenance drinker – with no nasty behavior, abuse, day-drinking, DUIs, or things like that – just drinking too much in the evening and falling asleep. Every single day. The first drink turned into [&]

The post The Curious Case of&. alcoholism appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-alcoholism/

(Meeps, one of our seven cats, helping with the selection process&) Since my first round of community mentoring back in 2015, when I mentored 54 people for six months, I’ve been asked periodically whether I’d do it again. My answer was always something like ‘maybe – it was a lot of work’ and I didn’t [&]

The post The Mentoring Class of 2023 appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-mentoring-class-of-2023/

In 2015 I mentored 54 people for six months. In 2020 I mentored 37 people on-and-off for over a year. In 2023 Ill be mentoring ?& Why do I do it? I get nothing from this; I just like doing it. I find it hugely rewarding to help people in a wide variety of non-technical [&]

The post Mentoring 2023 – want some help from me? appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/mentoring-2023-want-some-help-from-me/

(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.) (This ones from [&]

The post The Curious Case of& community appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-community/

(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.) From Jonathan this [&]

The post The Curious Case of& disconnected AG secondary replica and transaction log out of space issue appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-disconnected-ag-secondary-replica-and-transaction-log-out-of-space-issue/

(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 an [&]

The post The Curious Case of… eager writing and minimally-logged operations appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-eager-writing-and-minimally-logged-operations/

(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 quick one [&]

The post The Curious Case of… random failing log shipping restores appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-random-failing-log-shipping-restores/

(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.) In the previous [&]

The post The Curious Case of& data compression caching appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-data-compression-caching/

(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.) Yesterday I was [&]

The post The Curious Case of& tracking page compression success rates appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-tracking-page-compression-success-rates/

Our end-of-year sale is here and the discounts are insane! For example: Our signature BlackBelt Bundle is usually $6,995; on sale for $1,999! Performance Tuning Bundle (IEPTO1 and IEPTO2) is usually $3,395; on sale for $899! IEAzure is usually $3,295; on sale for $425! Our 3-day short courses are usually $795-$995; on sale for $99-$125! [&]

The post Crazy, crazy end-of-year sale! appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/crazy-crazy-end-of-year-sale/

(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 an [&]

The post The Curious Case of& the BULK_OPERATION lock during a heap NOLOCK scan appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-the-bulk_operation-lock-during-a-heap-nolock-scan/

(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 an [&]

The post The Curious Case of& the BULK_OPERATION lock during a heap NOLOCK scan appeared first on Paul S. Randal.

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

It’s getting towards the end of summer so it’s a perfect time to ensure your SQL Server instances are configured correctly and performing well. For all new clients, we’re dropping the price of our signature health check down to US$2,495 – saving US$500 off of the already-discounted price. This special offer will be in effect [&]

The post Back-to-school health check discount through September appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/back-to-school-health-check-discount-through-september/

It’s getting towards the end of summer so it’s a perfect time to ensure your SQL Server instances are configured correctly and performing well. For all new clients, we’re dropping the price of our signature health check down to US$2,495 – saving US$500 off of the already-discounted price. This special offer will be in effect [&]

The post Back-to-school health check discount through September appeared first on Paul S. Randal.

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

Weve just opened up registrations for our next set of live, online classes and bundles! All include lifetime access to class recordings and materials. Details are available through our shop page, and click on the class names below to see more about each class. Let us know if you have any questions and make sure [&]

The post Next set of live, online classes available for registration! appeared first on Paul S. Randal.

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

A prior student emailed me yesterday about some strange behavior of the sample_ms column in sys.dm_io_virtual_file_stats. Its supposed to be the number of milliseconds since the SQL Server instance has been started. He has a SQL Server 2016 instance thats been running since August 2019, and it shows the following: ms_ticks from sys.dm_os_sys_info: 51915112684 (which works out to [&]

The post Small bug with sample_ms in sys.dm_io_virtual_file_stats appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/small-bug-with-sample_ms-in-sys-dm_io_virtual_file_stats/

A prior student emailed me yesterday about some strange behavior of the sample_ms column in sys.dm_io_virtual_file_stats. Its supposed to be the number of milliseconds since the SQL Server instance has been started. He has a SQL Server 2016 instance thats been running since August 2019, and it shows the following: ms_ticks from sys.dm_os_sys_info: 51915112684 (which works out to [&]

The post Small bug with sample_ms in sys.dm_io_virtual_file_stats appeared first on Paul S. Randal.

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

(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.) While I was [&]

The post The Curious Case of… the un-killable thread appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-the-un-killable-thread/