Tag Archives: SQLNewBlogger

Using DATETRUNC–#SQLNewBlogger

Posted on December 18, 2023 by way0utwest

I saw someone using DATETRUNC recently in some code and realized I hadn’t really looked at this function before. It’s one that was added in SQL Server 2022, though it’s been in other platforms for years. This post looks at … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using DATETRUNC–#SQLNewBlogger

Executing One Line in VSCode–#SQLNewBlogger

Posted on December 11, 2023 by way0utwest

I wrote about arrays in PowerShell last week, but I realized one of the things I did while experimenting was look up how to run code a line at a time. I’m sure you can Google for that, but I … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Executing One Line in VSCode–#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