Ryan Adams

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

How to move Cluster Quorum Drive

by Ryan Adams

Ryan Adams

I recently had the need to move the quorum for a cluster to a new SAN drive. It’s a quite simple...

2011-07-25

2,478 reads

How to move the TempDB Database

by Ryan Adams

Ryan Adams

Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the...

2011-07-14

747 reads

How to move the MSDB database

by Ryan Adams

Ryan Adams

First we need to know the name and file location of the MSDB database files. When you change the location, make...

2011-07-13

955 reads

How to move the Model Database

by Ryan Adams

Ryan Adams

First we need to know the name and file location of the Model database files. When you change the location, make...

2011-07-12

6,565 reads

How to move the Master database

by Ryan Adams

Ryan Adams

The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the...

2011-07-11

1,368 reads

How to add your CMS server to a group

by Ryan Adams

Ryan Adams

You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until...

2011-07-06

1,315 reads

T-SQL Tuesday Mirroring and SSWUG

by Ryan Adams

Ryan Adams

This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is...

2011-06-14

699 reads

Blogs

The First Steps: Understanding the Basics of FinOps

As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...

Monday Monitor Tips: AI Query Analysis

AI is everywhere. It’s in the news, it’s being added to every product, management...

AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation

By Vinay Thakur

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

Read the latest Blogs

Forums

India's top water testing laboratory is FARE LABS Pvt. Ltd.

FARE Labs Pvt. Ltd., a water testing facility accredited by the NABL, tests drinking...

would it be so terrible to install ssms on a few user desktops?

Hi, ssms is free here. I can think of other reasons to do this...

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers