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

Database in Source Control

by Grant Fritchey

The Scary DBA

Many years ago, I was working with a great DBA. Seriously, a very smart and capable guy. He told me,...

2014-01-15

1,193 reads

Sausage Making

by Grant Fritchey

The Scary DBA

For those who don’t know, I work for Red Gate Software. I’m not a developer, but I work directly for...

2014-01-15 (first published: 2014-01-08)

2,042 reads

Speaker of the Month, January 2014

by Grant Fritchey

The Scary DBA

A whole new year. Cool.
I was at SQL Saturday DC, #233, at the beginning of December. I sat through several...

2014-01-03

744 reads

Set Up And Schedule a Server Side Trace

by Grant Fritchey

SQLServerCentral.com

Performance Tuning

How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(39)

Log in or register to rate

You rated this post out of 5. Change rating

2013-12-31 (first published: 2010-12-02)

13,570 reads

Discuss

Tribal Awards: Vote Now!

by Grant Fritchey

The Scary DBA

The #tribalawards voting is now online. Get over there and get it done.
I honestly don’t care who you vote for...

2013-12-23 (first published: 2013-12-20)

920 reads

How to Set Up Managed Backups in SQL Server 2014

by Grant Fritchey

The Scary DBA

Earlier this week I introduced the concept of Managed Backups (and caused less of a turmoil than I thought I...

2013-12-19

2,842 reads

Speaking in 2014

by Grant Fritchey

The Scary DBA

I love that I get to travel around and learn from my #sqlfamily. We’re still filling in the majority of...

2013-12-18

671 reads

Introducing Managed Backups in SQL Server 2014

by Grant Fritchey

The Scary DBA

Some of the new functionality of 2014 is straight forward, non-controversial and easily welcomed by the community. Think, updateable column...

2013-12-17

2,347 reads

SQL Server 2014 Backup to URL

by Grant Fritchey

The Scary DBA

I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location....

2013-12-11

1,719 reads

Speaker of the Month, December 2013

by Grant Fritchey

The Scary DBA

This will be my fifth speaker of the month post. Do a search to see the others.
I try to find...

2013-12-06

619 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers