Phil_Factor

Long-time software developer and Database programmer.

[Phil_Factor @Phil_Factor]

Just had a message from Microsoft 'Learn more about what it means to be frozen.' I think it may be about my personal cloud storage account but at my age, one has to be careful

[Phil_Factor @Phil_Factor]

I've just blogged about Diff-Objects: a PowerShell utility Cmdlet for Discovering Object differences. I wrote it mainly for testing, and for developing a narrative of changes in database developments. https://t.co/D4BYfFwZbw

[Phil_Factor @Phil_Factor]

Just Blogged 'Display-Object: a PowerShell utility Cmdlet' about viewing the objects and values within an object. - Simple Talk https://t.co/NjVfdnAX9f

[Phil_Factor @Phil_Factor]

Convert from XML - Simple Talk https://t.co/rjxwWltxDr Haven't done a blog for a while. This is the code for a PowerShell ConvertFrom-XML cmdlet that converts XML to a hashtable.

[Phil_Factor @Phil_Factor]

Rhode Island issued tax refund checks signed by Walt Disney and Mickey Mouse - CNN https://t.co/pJ9t99CMOv

[Phil_Factor @Phil_Factor]

I've just blogged about 'Diff'ing JSON documents in SQL Server- & reporting on the differences. I needed to do it for a project, but found it fascinating. https://t.co/MXxauEHYNg

[Phil_Factor @Phil_Factor]

Tackling Imperial and US Customary Measurements in Databases - Simple Talk https://t.co/CQbHWnsneI > I enjoyed myself writing this.

[Phil_Factor @Phil_Factor]

Good old Joe. It is always worth being reminded of Codd's true message https://t.co/c2JaFk8rQl

[Phil_Factor @Phil_Factor]

How to Document SQL Server Tables. Delighted to have had this published. It represented quite a bit of work. https://t.co/00j1rzsJuW > How to compile the comments in tables as well as the metadata.

[Phil_Factor @Phil_Factor]

@Kendra_Little I think Dave Poole's answer was spot on. It can be alarming if you're not expecting it, but working with an editor is all about team-work. I'm particularly fortunate in having had the same excellent editor for fifteen years, and so it is never an issue: Mutual trust.

[Phil_Factor @Phil_Factor]

'Monoliths are the future' - Changelog https://t.co/6u5Ov0a2q6 > Interesting discussion
'Microservices is a complex technique that solves a set of problems that most of the companies don’t have. '

[Phil_Factor @Phil_Factor]

Copying of all data between SQL Server databases and servers - Simple Talk https://t.co/FF0gz3y8ni > a PowerShell script that uses BCP native format to copy data between databases

[Phil_Factor @Phil_Factor]

Oops! Microsoft accidentally exposes 250 million customer support records online https://t.co/YEtD7fMUnM > includes locations, ip addresses and email addresses.

[Phil_Factor @Phil_Factor]

The Gloop: An Easier way of Managing SQL Server Documentation - Simple Talk https://t.co/qdaghXJPdz > just blogged about a technique I've been trying out - A 'Gloop' or 'Jelly-mass' is just a big SQL Query.

[Phil_Factor @Phil_Factor]

Associating Data Directly with SQL Server Database Objects. - Simple Talk https://t.co/1ubCoyaEwE >I haven't tweeted in a wee while. I haven't blogged in a while, come to think of it. Here is a new Blog post

[Phil_Factor @Phil_Factor]

Getting Data Masking and Anonymization Right https://t.co/TVASbKk20S > I am rather proud of this article. It is a warning about being complacent about data masking

[Phil_Factor @Phil_Factor]

@sql_williamd This is ridiculous. I wonder if they just do this at random ‘pour encourager les autres’. If it is any consolation, i enjoy not being an MVP enormously.

[Phil_Factor @Phil_Factor]

Aggregating strings in SQL Server, using Irish Saints Days - Simple Talk https://t.co/0sUx4Nf6f0 > Maybe that's not one of my best titles. However, I enjoyed writing it.

[Phil_Factor @Phil_Factor]

Insert Statement Without Column List https://t.co/h4EgISHcCe > I Describe another SQL code-smell!

[Phil_Factor @Phil_Factor]

SQL Clone for Unit Testing Databases - Redgate Software https://t.co/CCqNaaSEjS >Another article written for Tony's Product Learning Pages at Redgate.