Sockets, Cores, and Threads, oh my!

Sockets, Cores, and Threads, oh my!

What do you mean, exactly, by “CPU”? Once upon a time, computers sat on our desks; we knew exactly how many processors they had; and back then our biggest uncertainty was whether they could handle Y2K. Fast forward to today: our computers have 4, 8 or 16...
Removing and Adding a Node From an Availability Group

Removing and Adding a Node From an Availability Group

There may be a situation where you want to remove a node out of an Availability Group (AG) may be due to testing, something wrong with the server and need to build a new one, running out of space on that server so you can move files around, move the server to a...
Migrating Your AlwaysOn DR Node to a Different Location

Migrating Your AlwaysOn DR Node to a Different Location

There may be a situation when you need to move one of your servers that is part of an Availability Group to a different data center and the IP address for that server will change. In this example, we will be moving a DR node from one data center to another and change...
Reducing the Use of TempDB to Keep Costs Down

Reducing the Use of TempDB to Keep Costs Down

There comes a time in everyone’s life that they need to be concerned about tempdb. I know… we all have configured it correctly and it’s running great. The application and all of the developers are using it like crazy …Wait… that may not be a good thing....