Tag Archives: administration

T-SQL Tuesday #186–Agent Jobs

Posted on May 13, 2025 by way0utwest

It’s that time of the month again, when the T-SQL Tuesday blog party takes place. I manage this site, and am looking for hosts all the time. This month I managed to convince Andy Levy to host, and I’m grateful … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

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

Index Maintenance Can Change NORECOMPUTE Settings

Posted on April 30, 2025 by way0utwest

I had a customer recently ask about a change in one of their constraints on production, where a new option appeared when they went to deploy some changes from QA. They asked how this could happen, and I’ll show how … Continue reading →

Posted in Blog | Tagged , | Comments Off on Index Maintenance Can Change NORECOMPUTE Settings

Part-Time DBAs

Posted on April 9, 2025 by way0utwest

Some of you reading this are database administrators (DBAs) who manage systems as their full-time job. Others of you might be developers, analytics people, or someone else who has another job, but you get stuck with managing the database somehow. … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Part-Time DBAs