Point-in-time data
Phil Factor explains why data detached from its temporal context often loses all meaning.
2016-08-15
88 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
2016-08-01
66 reads
Delivering Rapid Improvements to SSMS
SSMS has spent years being neglected, merely being kept compatible with SQL Server and its features: But now we have, instead, the promise of monthly delivery of new functionality
2016-07-18
53 reads
2016-06-06
125 reads
Mentors and Professional Groups
When wrestling with technical problems or ideas, it is good to discuss with, argue against, present ideas to, and listen to your colleagues. This is true of anyone working in IT, but really important for the likes of database professionals who are engaged in a very rapidly-developing engineering specialism that demands that you keep up […]
2016-05-30
50 reads
The Information Schema and Cross-RDBMS Working
A look at the ODBC standard and how valuable it has been, unlike the Information Schema implementations.
2016-05-09
69 reads
A nice whistle and flute
Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.
2016-04-25
121 reads
Hunting in Packs
Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.
2016-04-11
124 reads
Code smells versus transgressions
The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?
2016-04-04
159 reads
2016-03-28
179 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