Chris Yates

Chris Yates is a Database Administration Manager with over thirteen years of experience in the SQL industry. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions accompanied by a strong development background. He enjoys helping others in the SQL Server community and does this by contributing on several SQL forums, creating “The SQL Professor”, and speaking at several SQL functions. His passion and focus is not only with technology but also helping others along their way and career path.

All authors

PASS Summit – What Does It Mean To Me?

by Chris Yates

The SQL Professor

PASS Summit – what does it mean to me? So listen, I’m not perfect. I will never claim to be and...

2014-06-26

390 reads

Worst Day As A DBA

by Chris Yates

The SQL Professor

I remember the day pretty vividly, it was in the summer months and I was as green as green can...

2014-06-26

427 reads

All authors

Read the latest Blogs

Visit the forum

Question of the Day

A Quick Restore

While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:

USE DNRTest

BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO
/*
Bunch of stuff tested here
*/RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

What happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance.

See possible answers

Chris Yates

PASS Summit – What Does It Mean To Me?

Worst Day As A DBA

Blogs

Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!

What is ALM in Fabric?

The Most Successful Startups in 2025 — And What They Have in Common

Forums

A Quick Restore

Guarding Against SQL Injection at the Database Layer (SQL Server)

Ola Hallengren Index Optimize Maintenance can we have data compression = page

Question of the Day

A Quick Restore