Monthly Archives: November 2023

A SQL Prompt AI Experiment with Window Clauses

Posted on November 22, 2023 by way0utwest

SQL Prompt has an EAP with some AI capabilities. I was asked to do some testing, and while I’ve done relatively little, I did find some time to play with this recently and decided to document what happened. I completed … Continue reading →

Posted in Blog | Tagged , , | 10 Comments

T-SQL Tuesday #168–Roundup

Posted on November 21, 2023 by way0utwest

Last week was the 168th T-SQL Tuesday, which I hosted. The invitation is here. I didn’t get much of a chance to check out the posts as I was at the PASS Data Community Summit, but I came home and … Continue reading →

Posted in Blog | Tagged , | 1 Comment

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

Ten Database Commandments

Posted on November 20, 2023 by way0utwest

I love the Notorious B.I.G. His music isn’t for everyone, but I enjoy it. This piece takes one of his songs (NSFW – Ten Crack Commandments) and applies the list to databases. Each item from the song is listed, along … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Ten Database Commandments