Buy vs. Build
It’s the classic question faced by everyone in Information Services. I know how to do this and I could build...
2010-05-28
1,597 reads
Blog Posts
Flipping a Table Sideways
Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table....
2010-05-28
1,585 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into...
2010-05-28
2,489 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I
import binary files into SSIS as well as how to improve throughput by...
2010-05-28
16 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into SSIS as well as how to improve throughput by...
2010-05-28
6 reads
New Unlocked CPUs From Intel
AnandTech has an interesting review up about some new models of Core i5 and Core i7 processors that are designed...
2010-05-28
1,450 reads
Permission Issue
I found a post of setting up database access in the following site and I responded there and I wanted...
2010-05-28
1,735 reads
The Truth about SQLPS and PowerShell V2
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...
2010-05-28
5,529 reads
Two Blog Series You Don’t Want to Miss
Blogs are a great way to learn new things about SQL Server, and just in case you have missed them,...
2010-05-28
1,580 reads
Adding Space to a Home Server
I got new drives for my Windows Home Server the other day and decided to add some space to the...
2010-05-27
1,042 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