Tag Archives: SQLNewBlogger

Create a Linked Server: #SQLNewBlogger

Posted on May 5, 2025 by way0utwest

I had a customer recently that was asking about Linked Servers and some development advice. I was going to show them a few things and realized I hadn’t created a linked server in my demo environment, so I did it … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Create a Linked Server: #SQLNewBlogger

Can I Change a Primary Key Value? #SQLNewBlogger

Posted on April 23, 2025 by way0utwest

I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of that. Another post for me that is simple and hopefully serves … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger

Posted on April 7, 2025 by way0utwest

There is a SET command in SQL Server that changes how much data is returned from some fields. This short post shows what I learned about the SET TEXTSIZE command. Another post for me that is simple and hopefully serves … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

CHOOSE’ing a Beer: #SQLNewBlogger

Posted on March 26, 2025 by way0utwest

We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use CHOOSE? Do you have to hard code choices? This post shows … Continue reading →

Posted in Blog | Tagged , , | Comments Off on CHOOSE’ing a Beer: #SQLNewBlogger