Blink – Year is gone
As the door begins to knock I start to wonder who it can be. As I begin to open it...
2014-12-22
503 reads
Blog Posts
Formatting Durations in SSAS: Caveat
I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...
2014-12-22
707 reads
Last Weeks Top “Reading” Links #114
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-12-22
669 reads
Outlier Detection with SQL Server, part 3.2: GESD
By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns,...
2014-12-22 (first published: 2014-12-17)
6,592 reads
ROW_NUMBER SQL Server
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number()...
2014-12-22 (first published: 2014-12-16)
8,850 reads
Use of RPC in Cluster
Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is...
2014-12-22
1,498 reads
Use of RPC in Cluster
Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of...
2014-12-22
3 reads
[OT] Blog is in maintenance mode
I’m spending part of this holiday break repaying some technical debt on my website. Among other things, I am importing...
2014-12-21
644 reads
Change Tracking–an easy way to track your changes TIP#78
I am pretty much sure by the title of this post you had idea of the post content. Although I...
2014-12-21
686 reads
Easy way to reseed identity column ? TIP #77
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...
2014-12-20
514 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers