TempDB configuration for people in a hurry
If you’ve ever had to play administrator to a SQL Server instance, you’ve probably had to deal with TempDB data or log files that have grown unexpectedly. I know...
2021-06-03
3 reads
DesertDBA
- Website: https://desertdba.com
A Biography Template for New Presenters
Presenting is difficult, and you already know that. It is also incredibly rewarding and beneficial to your career, but that’s not important for this post. As difficult as it...
2021-03-05 (first published: 2021-02-28)
178 reads
A Biography Template for New Presenters
Presenting is difficult, and you already know that. It is also incredibly rewarding and beneficial to your career, but that’s not important for this post. As difficult as it...
2021-02-28
7 reads
T-SQL Tuesday #131 – Database Analogies
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2020-10-21 (first published: 2020-10-13)
257 reads
T-SQL Tuesday #131 – Database Analogies
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2020-10-13
10 reads
The Value of a Mentor
Something I’ve mentioned in previous career-related posts is the value of a mentor. In case it seemed more like a suggestion, let me be more direct about this: You...
2020-08-17
28 reads
Online certification exams are definitely different
As you can tell from previous posts, I’ve taken a few Microsoft Certification exams here in 2020. As you may have also heard, there’s been this Coronavirus pandemic happening...
2020-08-12 (first published: 2020-08-01)
360 reads
Online certification exams are definitely different
As you can tell from previous posts, I’ve taken a few Microsoft Certification exams here in 2020. As you may have also heard, there’s been this Coronavirus pandemic happening...
2020-08-01
7 reads
How I passed the 70-762 certification exam
According to the myriad of statistics used to track such things, the post “How I passed the 70-761 certification exam” has been one of the most popular on this...
2020-05-31
43 reads
Query Store capture note: All does not mean what you think it means
As many of you know, Query Store is a wonderful tool for identifying query regressions, which in turn makes it an equally wonderful tool for migrations involving an upgrade...
2020-04-30
19 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Tame Those Strings (Series)
Comments posted to this topic are about the item Tame Those Strings (Series)
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers