Archive Every Day
There are challenges with the large scale archiving of data. Steve Jones talks about rethinking this as a daily process rather than a periodic one.
2015-06-09
449 reads
Editorials
When Should We Be Cleaning Data?
Part of our job as a data professional often deals with the movement and cleaning of data. However, should we be trying to reduce the work we do? Move the burden to the application? Steve Jones has a few comments.
2015-06-08
170 reads
Architecture for Auditing
The way in which auditing is build into our systems isn't the best way to implement the practice.
2015-06-04
140 reads
What Not To Say
Steve Jones has some advice for data professionals today. These are a few things that your boss doesn't want to hear, and you probably don't want to say.
2015-06-03 (first published: 2011-01-26)
698 reads
Finding Production Drift
The changes made to production can be problematic at times. Steve Jones notes we can't prevent them, but we can look for them.
2015-06-02
81 reads
Who Cares About Your Data?
The observation that people hear what they want to hear is not a new one, and yet the extent to which people will go out of their way to ignore or misinterpret evidence can still surprise.
2015-06-01
105 reads
2015-06-01
197 reads
Statistical Analysis
This week Steve Jones asks the questions about advanced data analysis and statistics you might be using in your applications.
2015-05-29
196 reads
The Hidden Patterns in Data
Looking at statistics and data to draw conclusions can be hard. Steve Jones comments on an interesting way of analyzing data from TED.
2015-05-28
172 reads
2015-05-27
366 reads
Blogs
SQL Server 2025 Generally Available
By Brian Kelley
This was announced last week at Microsoft Ignite and it's been covered by others...
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Forums
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Done is Better than Good
Comments posted to this topic are about the item Done is Better than Good,...
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers