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.
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.
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.
(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/
(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.
(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.) Earlier today I [&]
The post The Curious Case of… object ID 99 appeared first on Paul S. Randal.
https://www.sqlskills.com/blogs/paul/the-curious-case-of-object-id-99/
(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.) Earlier today I [&]
The post The Curious Case of… object ID 99 appeared first on Paul S. Randal.
(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 last [&]
The post The Curious Case of& log generated during a DROP TABLE appeared first on Paul S. Randal.
https://www.sqlskills.com/blogs/paul/the-curious-case-of-log-generated-during-a-drop-table/
(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 last [&]
The post The Curious Case of& log generated during a DROP TABLE appeared first on Paul S. Randal.
Ten years ago today we announced that we were hiring our first employee: Jonathan Kehayias. It was a big risk for Kimberly and I, as rather than partnering with other consultants, we suddenly became responsible for another full-time salary, no matter how much income the company had. I must admit, I really didnt think wed [&]
The post Jonathans ten year anniversary! appeared first on Paul S. Randal.
https://www.sqlskills.com/blogs/paul/jonathans-ten-year-anniversary/
Ten years ago today we announced that we were hiring our first employee: Jonathan Kehayias. It was a big risk for Kimberly and I, as rather than partnering with other consultants, we suddenly became responsible for another full-time salary, no matter how much income the company had. I must admit, I really didnt think wed [&]
The post Jonathans ten year anniversary! appeared first on Paul S. Randal.
(This is also the Ponderings editorial in todays SQLskills newsletter.) I want to start out this post by sincerely thanking everyone who emailed me or commented about depression, after the last newsletter/post. It definitely seems that there’s a lot of it about, from situational depression (like I think I have – doctor video [&]
The post Some thoughts on courage appeared first on Paul S. Randal.
https://www.sqlskills.com/blogs/paul/some-thoughts-on-courage/
(This is also the Ponderings editorial in todays SQLskills newsletter.) I want to start out this post by sincerely thanking everyone who emailed me or commented about depression, after the last newsletter/post. It definitely seems that there’s a lot of it about, from situational depression (like I think I have – doctor video [&]
The post Some thoughts on courage appeared first on Paul S. Randal.
(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. Its always been technical up to now, but this time its a personal note.) I came to a realization yesterday (Thursday) evening: I’m depressed. Over the last [&]
The post The Curious Case of& lack of motivation appeared first on Paul S. Randal.
https://www.sqlskills.com/blogs/paul/the-curious-case-of-lack-of-motivation/
(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. Its always been technical up to now, but this time its a personal note.) I came to a realization yesterday (Thursday) evening: I’m depressed. Over the last [&]
The post The Curious Case of& lack of motivation appeared first on Paul S. Randal.
Over the last year, after we were forced to move our Immersion Events online, we’ve realized the power and flexibility of online training and we had great success with our classes last September and October. Our students loved the relaxed class format, and especially the spread over half days instead of grueling 9-hour classroom days, [&]
The post Stepping away from SQLintersection appeared first on Paul S. Randal.
https://www.sqlskills.com/blogs/paul/stepping-away-from-sqlintersection/
Over the last year, after we were forced to move our Immersion Events online, we’ve realized the power and flexibility of online training and we had great success with our classes last September and October. Our students loved the relaxed class format, and especially the spread over half days instead of grueling 9-hour classroom days, [&]
The post Stepping away from SQLintersection appeared first on Paul S. Randal.
Our classes are all open for registration and we have deep discounts running through the end of the month! Once again they will all be online, using our popular half-day format (9am-2pm Pacific Time) so you get some time to do other work and dont have to sit through 8-9 hours of learning every day. The [&]
The post Spring 2021 classes, recorded classes, blackbelts, and discounts! appeared first on Paul S. Randal.