Long-time software developer and Database programmer.
East Anglia
Joined September 2008
- Tweets7.1K
- Following352
- Followers2.6K
- Likes5
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
2
288
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. red-gate.com/simple-talk/blo…
2
Just Blogged 'Display-Object: a PowerShell utility Cmdlet' about viewing the objects and values within an object. - Simple Talk red-gate.com/simple-talk/blo…
Convert from XML - Simple Talk red-gate.com/simple-talk/blo… Haven't done a blog for a while. This is the code for a PowerShell ConvertFrom-XML cmdlet that converts XML to a hashtable.
1
Rhode Island issued tax refund checks signed by Walt Disney and Mickey Mouse - CNN cnn.com/2020/08/01/us/rhode-…
2
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. red-gate.com/simple-talk/blo…
Tackling Imperial and US Customary Measurements in Databases - Simple Talk red-gate.com/simple-talk/blo… > I enjoyed myself writing this.
Good old Joe. It is always worth being reminded of Codd's true message red-gate.com/simple-talk/hom…
1
4
How to Document SQL Server Tables. Delighted to have had this published. It represented quite a bit of work. red-gate.com/simple-talk/sys… > How to compile the comments in tables as well as the metadata.
'Monoliths are the future' - Changelog changelog.com/posts/monolith… > Interesting discussion
'Microservices is a complex technique that solves a set of problems that most of the companies don’t have. '
2
Copying of all data between SQL Server databases and servers - Simple Talk red-gate.com/simple-talk/blo… > a PowerShell script that uses BCP native format to copy data between databases
Oops! Microsoft accidentally exposes 250 million customer support records online mspoweruser.com/microsoft-ac… > includes locations, ip addresses and email addresses.
The Gloop: An Easier way of Managing SQL Server Documentation - Simple Talk red-gate.com/simple-talk/blo… > just blogged about a technique I've been trying out - A 'Gloop' or 'Jelly-mass' is just a big SQL Query.
Associating Data Directly with SQL Server Database Objects. - Simple Talk red-gate.com/simple-talk/blo… >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
Getting Data Masking and Anonymization Right studio3t.com/knowledge-base/… > I am rather proud of this article. It is a warning about being complacent about data masking
Aggregating strings in SQL Server, using Irish Saints Days - Simple Talk red-gate.com/simple-talk/blo… > Maybe that's not one of my best titles. However, I enjoyed writing it.
Insert Statement Without Column List red-gate.com/hub/product-lea… > I Describe another SQL code-smell!
SQL Clone for Unit Testing Databases - Redgate Software red-gate.com/hub/product-lea… >Another article written for Tony's Product Learning Pages at Redgate.
2
Using JSON for matrices in SQL Server. - Simple Talk red-gate.com/simple-talk/blo… >Yep, it isn't as fast as using strings, but it is a lot easier!
2
Checking on the Differences Between Two Versions of a Database Build - Simple Talk red-gate.com/simple-talk/blo… > Just written another blog with a chunk of SQL. I hope you like it.
1