Spoke at #sqlsat81
I presented two sessions this weekend in Birmingham AL at SQL Saturday 81. I was in the first slot of...
2011-07-31
1,450 reads
Blog Posts
Lookup functions in SSRS 2008 R2 - III
Introduction
This is the final post to discuss the last Lookup function Multilookup(). The other two – Lookup() and LookupSet() have already...
2011-07-30
11,350 reads
SQL Saturday #85 Orlando
SQL Saturday #85 is quickly approaching. It will be held in sunny Orlando, FL so if you live in the...
2011-07-30
2,053 reads
The Good, the Bad and the Ugly SQL Cursor types
T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking...
2011-07-30
1,936 reads
Big Numbers
What had me reflecting on numbers was an article in the Financial Times (Conduit of Contention if you can find...
2011-07-29
1,496 reads
Build a schedule for SQL Saturday
A new feature has been added to SQL Saturday. Now when you register for an event you can build your...
2011-07-29
1,433 reads
Calling SCOM in C#
Written by David Postlethwaite
I’m sure there are many out there using System Centre Operations Manager (or SCOM for short)...
2011-07-29
3,954 reads
Dual monitors, dual laptops, and the best way to manage them
Here is a tip that could make you much more productive: At home, I have a desktop computer with dual-monitors...
2011-07-29
2,289 reads
Marking FK Constraints NOT FOR REPLICATION
When administering Merge Replication, sometimes we need to mark foreign
key constraints NOT FOR REPLICATION. In some cases, we might...
2011-07-29
7,741 reads
Modified Insert Unknown Row to Dimension Table
A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. ...
2011-07-29
2,910 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