Tag Archives: SQLNewBlogger

Removing a PowerShell Array Element–#SQLNewBlogger

Posted on December 4, 2023 by way0utwest

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 a lot, but with more and more DevOps work needing complex … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Removing a PowerShell Array Element–#SQLNewBlogger

Changing the Data Type of a Primary Key–#SQLNewBlogger

Posted on November 20, 2023 by way0utwest

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. This is the happy path, and not intended to cover all … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Creating a Self Referencing FK in a CREATE Statement–#SQLNewBlogger

Posted on November 6, 2023 by way0utwest

I had written about a FK in a CREATE TABLE statement recently, but the second half of this was that after the original question, the person asked if this would also work for a self-referencing FK. It does, and I … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Adding a Foreign Key in the CREATE TABLE statement–#SQLNewBlogger

Posted on October 30, 2023 by way0utwest

I had someone ask this question recently and had to double check the syntax myself, so I thought this would make a nice SQL New Blogger post. Another post for me that is simple and hopefully serves as an example … Continue reading →

Posted in Blog | Tagged , , | 2 Comments