Presenting the Facts about Data Breaches
If you're faced by an investigation team, after a data breach, it is no use putting on your 'Mr. Sincerity' face and making vague statements. They want documented facts.
2020-11-14
161 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Responding to the Call of the Wild
Phil Factor's manual for taming machines, applications, and other wild beasts.
2020-10-17
133 reads
Of Hedgehogs and Database Design
One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]
2020-08-22
371 reads
Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3
This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.
2020-08-05 (first published: 2016-09-28)
5,056 reads
2020-06-27
220 reads
Falling Over our Assumptions
There's a saying about what it says about a person to assume something. However it's something we all do every day. Phil Factor brings us a guest editorial about assumptions in SQL code.
2020-06-25 (first published: 2009-04-08)
829 reads
2020-05-30
217 reads
Representing uncertainty in difficult times
The Covid-19 pandemic has provided examples of how uncertain data can eventually be presented to the public as certainty. How, as data people, should we represent uncertainty in our data?
2020-05-02
172 reads
Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script
Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.
2020-03-19
437 reads
SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7
In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.
2020-03-18 (first published: 2017-02-22)
3,953 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers