Removing a PowerShell Array Element–#SQLNewBlogger

I saw an article on this and realized I had no idea how to do this, so I decided to practice a bit. I don’t work with PoSh arrays...

Beginner's Introduction to PowerShell Remoting

Beginner's Introduction to PowerShell Remoting

...

Importing Flat Files into Azure SQL DB

Initially, I thought I would have to use sqlcmd because I’m on a Mac and don’t have SSMS. It turns out Azure Data Studio has a nifty way to...

PostgreSQL Backup Failure

In this blog post I wrote a tip about fixing the PostgreSQL backup failure issue. The error was directing about the permission issue.
The post PostgreSQL Backup Failure appeared first...

A New Word: Nighthawk

nighthawk – n. a recurring thought that only seems to strike you late at night – an overdue task, a nagging guilt, a looming future – which you sometimes...

Building Upon Your Productivity Momentum: Staying Productive For Life

Note: I found this sitting in my Medium draft. This was a cross-post from my old productivity blog that got lost in oblivion. Productivity is never an accident. It...

Changing the Data Type of a Primary Key–#SQLNewBlogger

A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple question: What do you think about PostgreSQL events? Prior to this year, I’d never attended...

Using ThinOptics to Read Data

As I’ve aged, I find myself struggling to read many things in my life. It started with difficulties seeing menus, but moved on to other areas. During the pandemic,...

Cosmos DB – Monitoring performance

Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query...