T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
900 reads
Blog Posts
WIT Wednesday
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-09-26
1,121 reads
2013 North American PowerShell Summit
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday...
2012-09-25
1,168 reads
2013 North American PowerShell Summit
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday April 24th at the Microsoft campus in Redmond,...
2012-09-25
7 reads
Master Data Services: Resources
Here are some of my favorite Master Data Services (MDS) resources:
SQL Server Master Data Services Utilities: A set of useful...
2012-09-25
2,554 reads
SQL In The City: Austin
So, No SQL Saturday in Austin This Year.
I know a lot of folks were disappointed that we (POSSE) weren’t able to pull together in...
2012-09-25
1,042 reads
SQL Server || Change Batch separator
SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL statement. it is...
2012-09-25
2,049 reads
SQL Server Virtualization in Sweden
Another date has been added to my schedule for the delivery of 2109 SQL Server Virtualization and Consolidation. Come and...
2012-09-25
678 reads
Transferring Table Types
An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you move...
2012-09-25
1,682 reads
Using a TVP instead of Dynamic SQL to pass a list into a SP
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me...
2012-09-25
1,182 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