Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
4,240 reads
Administration
The Case for Patching
Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]
2022-08-20
153 reads
Getting More Information From the String or Binary Data Truncated Error
Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.
2022-08-17
8,315 reads
2022-08-03
472 reads
Linked Servers: a Peek Behind the Curtain
Learn how a linked server caused an issue with Gallium Data.
2022-07-15
5,196 reads
2022-07-13
550 reads
2022-07-01
439 reads
A New SQL Server Vulnerability
A new vulnerability for SQL Server is covered by a number of patches this week.
2022-06-18
745 reads
2022-06-10
492 reads
2022-06-03
461 reads
Blogs
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
SSMS 22 still inserting tabs instead of spaces
I’m not trying to start up a debate whether you should use tabs or...
Forums
Cumulative Update 23 - KB5074819 - Database Mail - No longer working.
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
Script Task execution error with HTTP request
I have a script task that tries to execute a HTTP request, which seems...
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers