Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.
2017-05-29
85 reads
Pseudonymisation is a form of data masking, a technique that becomes more important to data professionals all the time.
2017-05-19
1,755 reads
There may be new changes to our jobs as data professionals because of GDPR in the European Union.
2017-05-18
131 reads
Iterations and loops are fundamental parts of computer science, but with SQL and PowerShell, we may want different programming paradigms.
2017-05-17
102 reads
2017-05-16
94 reads
Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.
2017-05-15
187 reads
The ideal Agile database needs to be secure, recoverable, transactional, resilient, and versatile enough to allow easy migration paths when you need to delegate tasks elsewhere, for scalability. Sounds like a relational database to Phil Factor.
2017-04-03
74 reads
Phil Factor argues that The serious problems with working from home come not from poor productivity, but when office-based team members seem to prefer to ignore the fact that the remote workers exist.
2017-03-27
160 reads
Phil Factor on the rewards of learning the zen-like skill of writing, reading and understanding IT documentation.
2017-03-13
47 reads
If a successful IT career is just as much about tenacity, interest and retention as it is about brainpower, then how does one go about continuous learning?
2017-03-06
83 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers