Learn how to emulate Azure storage for files, blogs, and queues.

Trust is a Funny Thing

by Steve Jones

SQLServerCentral

Artificial Intelligence (AI)

Steve has a few thoughts on trust, both with co-workers and Gen AI systems.

What If You Need to Index a Lot of Duplicate Data?

by Additional Articles

Brent Ozar Blog

Indexing

Let’s get a little nerdy and look at database internals.

Triggers

by RyanBooz

SQLServerCentral

Editorial

Triggers. Who doesn’t like a good, lively debate about triggers? With the extreme cold that we’ve experienced this past week in the northeastern U.S., I feel like a little heated debate wouldn’t be a bad way to forget about the cold. But alas, I’m not here to talk about database triggers. Sorry, we’ll have to […]

Configuring Maintenance Plans in SQL Server

by Kenneth Igiri

SQLServerCentral

Uncategorized

See a walkthrough of setting up a maintenance plan in SQL Server.

Moving On After a Technology Fail

by Steve Jones

SQLServerCentral

Technology

After his watch broke, Steve had to get a new tool and isn't sure it was a good move.

Upgrade and Migrate SSIS Catalog and SSISDB to a New Server

by Additional Articles

SQLServerCentral

There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.