SQL101: Phishing attacks
I thought it was bad previously, but in 2026 I’ve noticed a big rise in emails trying to scam me into clicking a link –
I thought it was bad previously, but in 2026 I’ve noticed a big rise in emails trying to scam me into clicking a link –
There are a huge number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially
Jonathan had a client issue recently where SQL Server’s buffer pool had been forced down to a ridiculously small size, only a few hundred MB,
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the
One of the easiest ways to increase query performance in SQL Server is to make sure that it can quickly access the requested data, and
Spring is already in the air here in Redmond so time for March Madness! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training
In the previous Curious Case I described an issue Jonathan had at a client with very long IAM chains, and the circumstances leading to it.
(The original version of this post first appeared on the now-deleted SentryOne blog at the start of 2022.) One of the most fundamental concepts in
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the
(This is from the Insider Newsletter that I sent out earlier today…) Back in early 2023 I wrote a long blog post about my struggles
This is a case that happened on a client system last year: occasionally a common query on a tiny table appeared to ‘hang’ and had
(TL;DR; Video trailer for the new course is here.) Joe’s next course, AIVSP: Vector Search in Practice, is now available! This online course builds on AIVSE:
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people enjoy it
(TL;DR: Video trailer for the course is here.) We’re tremendously excited to be developing a library of AI-focused courses, as well as new courses focused
From now until mid-December we have our lowest prices ever on our signature 158-hour Blackbelt training bundle: US$1,599 for Lifetime access (no expiration) US$899 for
It’s been a while since I wrote one of these, but I’m picking up the series again. This is a question that came in through
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been
(Yes, this is for last year!) Back in 2009 I started posting a summary at the end of the year of what I read during
It’s the time of year again where companies do crazy sales on the day after Thanksgiving in the US, and we’re doing the same! All
Happy Fourth of July to all who celebrate! I’m looking forward to a great view Thursday evening looking west along the Skagit Valley with some
(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
(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
(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
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget
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 –
(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
[Edit 12/16/2022:the deadline for submissions is now closed.] In 2015 I mentored 54 people for six months. In 2020 I mentored 37 people on-and-off for
(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
(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
(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
(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
(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
(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
Update: We extended the sale through Christmas Day at midnight UTC! Our end-of-year sale is here and the discounts are insane! For example: Our signature
(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
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
A prior student emailed me yesterday about some strange behavior of the sample_ms column in sys.dm_io_virtual_file_stats. It’s supposed to be the number of milliseconds since the SQL
(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
(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
(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
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
(This is also the Ponderings – editorial – in today’s SQLskills newsletter.) I want to start out this post by sincerely thanking everyone who emailed
(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
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
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,
(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
The last post of the year! It’s been a terrible year all round, as I’m sure you’ll all agree, and I’m very glad we’re rolling
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.