Flawed Data Integration
These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.
2022-06-13
141 reads
Editorials
Building a PC
Steve has a few thoughts on building your own PC to help you with work or your career.
2022-06-10
235 reads
One or Many Databases
When you have multiple clients in your application, do you want one or many databases?
2022-06-08
404 reads
Are Cubes Dead?
Is the idea of an Analysis Services cube something that is no longer relevant for modern data analysis? Steve thinks it might be.
2022-06-06
1,039 reads
The Nightmare Letter
The GDPR may bring nightmare letters like the one linked to from the editorial.
2022-06-03 (first published: 2018-03-28)
263 reads
Production Subsets
Working with data in development or test environments can be challenging. This week Steve Jones asks how you might deal with the volume of data and whether you like subsets.
2022-06-01 (first published: 2014-08-22)
260 reads
Audit systems: a good idea or a mess to maintain?
Audit systems can be a good idea, but they can also be a mess to maintain.
2022-05-30 (first published: 2018-02-27)
306 reads
2022-05-28
209 reads
2022-05-27 (first published: 2018-02-08)
243 reads
It's Not Yours
We may talk about our databases, but hopefully most of us know we don't own the data.
2022-05-25 (first published: 2018-01-17)
234 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers