SQLSaturday #50 Report
I attended my first SQLSaturday yesterday in Iowa City, Iowa. I spoke on two topics: “What’s New with Reporting Services”...
2010-09-19
1,617 reads
Blog Posts
SSIS: Assign a value to Variable using Dataflow Script task
I am not quite sure how many of you have tried to set or change the value of a variable...
2010-09-19
4,751 reads
Are Your Backups Really Safe?
This editorial was originally published in the Simple-Talk newsletter.
Imagine for a moment if you will. As a DBA, and as...
2010-09-18
549 reads
SQL Server 2008 and 2008 R2 Diagnostic Information Queries
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These...
2010-09-18
3,913 reads
ACID
What’s ACID in databases? I was asked this in an interview a long time ago and I couldn’t remember the...
2010-09-17
2,195 reads
CakeWrecks
Recently I had a student point me to CakeWrecks, a blog about good cakes gone bad.The post from today has...
2010-09-17
551 reads
Do You Have Influence? Part 2
I started writing on influence last week and promised some comments on how to build influence and credibility. There are...
2010-09-17
1,356 reads
I Don't Want to Share!
I know we were taught to share in kindergarten, but there are some things that should not be shared. In...
2010-09-17
570 reads
MDX Aggregate Named Set Than Others
In this quick post I wanted to provide some code that's been useful to me recently. This MDX statement creates...
2010-09-17
2,470 reads
SELECT: If ON preceeds JOIN, then how….
I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night. ...
2010-09-17
488 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