T-SQL Tuesday Retrospective #004: I/O
Mike Walsh invited us on March 1st 2010 to write about I/O. This abbreviation stands for Input / Output, and is often used as shorthand for persisted storage. Given...
2020-11-11
13 reads
Born SQL with Randolph West
The rule of three, SQL Server on Linux edition
When it comes to Microsoft products, the rule of three — at least as far as I’m concerned — is where you can accomplish the same task in three...
2020-11-10
79 reads
T-SQL Tuesday Retrospective #003: Relationships
In my quest to respond to every T-SQL Tuesday since the dawn of the end of 2009, it was only a matter of time before Rob Farley’s name came...
2020-11-04
28 reads
T-SQL Tuesday Retrospective #002: A Puzzling Situation
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we were asked one of three options, and I elected to go with the first one:...
2020-11-02 (first published: 2020-10-28)
320 reads
The T-SQL Tuesday Corollary
T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics over the past 11 years, inviting bloggers to share their thoughts on a particular theme...
2020-10-21
21 reads
A more considered approach to email signatures
This — like last week’s post — is not about SQL Server or Azure SQL Database. In a way, it hearkens back to a post I wrote a few years...
2020-10-14
28 reads
Read the error message
This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a company which I had...
2020-10-07
439 reads
How SQL Server stores data types: sql_variant
This post looks at a curious data type that isn’t really a data type. Instead, sql_variant tries to be all things to all people. As with most things in...
2020-09-30
229 reads
A new malware attack on SQL Server
Tencent Security has released a report (written in Chinese) describing a new malware attack by the name of “MrbMiner” on SQL Server instances exposed to the Internet with passwords that can...
2020-09-23
388 reads
If not me, then who?
[Content Warning: this post contains references to subjects that may trigger a trauma response. Read with caution.] This is not a technical post. I was going to write about...
2020-09-16
53 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers