SQL Server – How to Calculate Length and Size of any field in a SQL Table
Recently I came across a situation where queries are loading extremely slow from a table. After careful analysis we found...
2015-06-04
702 reads
Blog Posts
SQLSaturday #408 Houston
I have been selected again to speak in Houston (Saturday, June 13th) for a SQLSaturday event and look forward to...
2015-06-04
531 reads
Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7
Hi friends, in last previous blogs we created database mail profile and database mail account. In this blog we will...
2015-06-04
490 reads
Blacklist a Set of IPs - WaterOx Consulting
Reading Time: 3 minutesWe talked about whitelisting IPs before, but what about the opposite, blacklisting...
The post Blacklist a Set of...
2015-06-03
439 reads
Clean up all (most) of the orphans on an instance
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone...
2015-06-03
1,671 reads
Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP
Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored...
2015-06-03 (first published: 2015-05-26)
1,357 reads
Notes From The May 2015 oPASS Meeting
Really late posting these, forgot to put on my task list!
About 20 attendeesLots of good questions, and I saw quite...
2015-06-03
385 reads
SQL Server 2016 features to look for -1
At this year’s inaugural Ignite Conference in held in Chicago Microsoft announced that the next release of SQL Server, previously...
2015-06-03
1,149 reads
VM Memory Counters Lie for SQL Server VMs
A few weeks ago, while at the incredible SQL Saturday Madison, I had a great discussion with a few of the...
2015-06-03 (first published: 2015-05-22)
2,407 reads
What is Microsoft Azure Stream Analytics?
Microsoft Azure Stream Analytics (ASA) is a fully managed cloud service for real-time processing of streaming data. ASA makes it easy...
2015-06-03
1,082 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