2016-11-08 (first published: 2013-02-14)
200 reads
Editorials
I can ODBC clearly now
ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?
2016-11-07
116 reads
What's Your Backup Speed?
This week Steve Jones has a bit of a competition. Share with him how fast you can back up a 1TB database.
2016-11-04
209 reads
Generating Our Own Bad Data
We depend on data quality to run our businesses efficiently. However, it's a problem when we mess that data up on purpose.
2016-11-02
82 reads
2016-10-31
56 reads
Analysis Services Lives On
The release of Analysis Services in Azure means the platform has a future.
2016-10-31
69 reads
Emotions and Decision Making
Today we have a guest editorial from Grant Fritchey that looks at emotions and how they can affect our decision making.
2016-10-28
106 reads
Wasting Time
Things at work that waste your time are impediments to actually getting work done. Management ought to be in the business of removing as many of these things as possible.
2016-10-27 (first published: 2012-10-11)
417 reads
Who is that masked man anyway?
If you are holding, in your organisation, personal data about real people or commerce, it is wrong, and in many cases illegal to do database development work or testing using your production data. This, of course, probably applies to a minority of database systems, but data breaches caused by attacking backups or copies of production […]
2016-10-24
87 reads
Where Do You Run Your R Scripts?
Executing R scripts can be a heavy load. Today Steve Jones wonders if SQL Server is the best place to execute these.
2016-10-20
436 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