Long-time software developer and Database programmer.
Joined September 2008
- Tweets 7,098
- Following 355
- Followers 2,610
- Likes 5
Photos and videos
14 Jun 2024
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
285
3 Sep 2021
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
7 Jul 2021
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…
10 Jun 2021
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
1 Aug 2020
Rhode Island issued tax refund checks signed by Walt Disney and Mickey Mouse - CNN cnn.com/2020/08/01/us/rhode-…
2
6 Jul 2020
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…
2
6 May 2020
Tackling Imperial and US Customary Measurements in Databases - Simple Talk red-gate.com/simple-talk/blo… > I enjoyed myself writing this.
2
18 Apr 2020
Good old Joe. It is always worth being reminded of Codd's true message red-gate.com/simple-talk/hom…
1
4
18 Apr 2020
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.
3
4
3 Feb 2020
'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
1 Feb 2020
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
2
1
5
23 Jan 2020
Oops! Microsoft accidentally exposes 250 million customer support records online mspoweruser.com/microsoft-ac… > includes locations, ip addresses and email addresses.
3
1
4 Dec 2019
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.
1
29 Oct 2019
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
1
2
8
2 Sep 2019
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
2
5
17 Jun 2019
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.
1
2
7
24 Apr 2019
Insert Statement Without Column List red-gate.com/hub/product-lea… > I Describe another SQL code-smell!
2
3
12 Apr 2019
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
9 Apr 2019
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
5 Apr 2019
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