Using Technology In New Ways
An interesting reuse of technology in a completely new way caught Steve Jones' eye. See if you agree that this is rather amazing.
2012-07-19
147 reads
Editorials
Geeky Books
Today Steve Jones talks about one of his pastimes: reading. He recommends you read more, and share the books you enjoy.
2012-07-18
242 reads
Time Zones
Today Steve Jones complains a bit about time zone support in SQL Server and why it seems so cumbersome. Shouldn't it be easier in 2012?
2012-07-17
306 reads
A Cool Job
Today's editorial was originally published on August 21, 2007. It is being re-run as Steve is traveling. What a cool job it must be to try and tune and get the most performance out of a system.
2012-07-16
163 reads
Write Better Code
Better security can be achieved by writing better code. Steve Jones agrees, but doesn't think it's as easy as it sounds.
2012-07-16
266 reads
Kill a SPID
This editorial was originally published on Sept 5, 2007. It is being re-run as Steve is traveling. Today Steve talks about the potential problems with killing SPIDs in SQL Server.
2012-07-13
316 reads
One Single View
This editorial was originally published on Oct 9, 2007. It is being re-run as Steve is traveling. When I worked at JD Edwards, one of the goals of our business intelligence system was to house a single view of the truth. I recently saw a blog post by Andrew Fryer that does a good job of explaining what this actually is.
2012-07-12 (first published: 2007-10-09)
541 reads
Why It's Good To Be Wrong
Today we have a guest editorial from Hakim Ali. Being wrong is not as bad as you may think.
2012-07-11
452 reads
It's the Journey...
The story of how Shawn McGehee's journey to becoming a DBA started is just one among many thousands, so let's hear yours too!
2012-07-09
144 reads
Starting to Program
This Friday Steve Jones asks what resources might help the new DBA learn to program better. Pick the language of your choice and let us know what resources have worked well for you.
2012-07-06
308 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
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...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
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