Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Advocate in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

Twitter: @https://twitter.com/gfritchey
Website: https://scarydba.com
LinkedIn: https://www.linkedin.com/in/grant-fritchey/
Bluesky: https://bsky.app/profile/gfritchey.bsky.social

Execution Plans, Performance Tuning and Rum

by Grant Fritchey

The Scary DBA

This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...

2015-01-06

1,082 reads

Speaker of the Month: January 2015

by Grant Fritchey

The Scary DBA

I love it that my first post of the new year is going to be Speaker of the Month. I’m...

2015-01-02

422 reads

“Pretty Plans vs. Performance” or “Grant Gets Pwned”

by Grant Fritchey

The Scary DBA

If you get an execution plan that looks like this:

I wouldn’t blame you for immediately thinking about query tuning. Especially...

2014-12-29 (first published: 2014-12-19)

6,158 reads

Speaker of the Month: December 2014

by Grant Fritchey

The Scary DBA

For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new...

2014-12-08

551 reads

Speaker of the Month: November 2014

by Grant Fritchey

The Scary DBA

I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...

2014-12-05

504 reads

PASS Summit 2014 Speaker Idol

by Grant Fritchey

The Scary DBA

For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015...

2014-11-13

779 reads

I’m Still Not on the Board

by Grant Fritchey

The Scary DBA

I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....

2014-11-11

692 reads

PASS Summit 2014: WIT Luncheon

by Grant Fritchey

The Scary DBA

Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...

2014-11-06

621 reads

Database Lifecycle Management

by Grant Fritchey

The Scary DBA

There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every...

2014-10-31 (first published: 2014-10-20)

6,978 reads

Navel Gazing

by Grant Fritchey

The Scary DBA

I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...

2014-10-17 (first published: 2014-10-12)

6,595 reads

Blogs

What is ALM in Fabric?

As someone who’s worked with data for over 20 years and with many cloud...

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

2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...

Blog a Day – Day 1: History of AI

By Vinay Thakur

it has been a year since i have not written much on the blog...

Read the latest Blogs

Forums

A Quick Restore

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Quick Restore

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

Comments posted to this topic are about the item Guarding Against SQL Injection at...

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

I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...

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