Capture Execution Plans Only For Long Running Queries

• by Grant Fritchey

• The Scary DBA

I love questions. Most of all, I love questions I can answer. I spotted this question recently: How can I use Profiler to capture execution plans for queries over...

2020-09-28

4 reads

New Stuff Can Be Scary

• by Grant Fritchey

• SQLServerCentral

• Career
• Database Weekly

I'm learning how to be a net controller for a high frequency (HF) radio network. Nets are a fun way to make lots of contacts quickly. Taking part in a net is simple. You check in with the net control and then you can answer calls or make calls (different nets have different rules). It's […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2020-09-26

42 reads

• Discuss

Review: Stellar Repair for SQL Server

• by Grant Fritchey

• The Scary DBA

I was contacted by Stellar Info quite a while ago. They asked me to try out their software. I said yes, but I was really bad about getting it...

2020-09-23

48 reads

Solving Real Problems

• by Grant Fritchey

• SQLServerCentral

• problem solving

Today we have a guest editorial where Grant talks about being effective and practical in your world.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

Log in or register to rate

2020-09-17

137 reads

• Discuss

Emergency Preparedness

• by Grant Fritchey

• SQLServerCentral

• Disaster Recovery (DR)

Being prepared for things to go wrong is important, more so these days than in much of our past.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2020-09-04

75 reads

• Discuss

Extended Events: Filter on Stored Procedure Name

• by Grant Fritchey

• The Scary DBA

I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events. The answer is,...

2020-09-04 (first published: 2020-08-24)

421 reads

Learning Isn’t Easy, But It’s Vital

• by Grant Fritchey

• SQLServerCentral

• Career
• Database Weekly

This week Grant notes that we need to work on our learning skills, especially as the world continues to drive forward.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

2020-08-29

145 reads

• Discuss

Azure SQL Database Automatic Tuning

• by Grant Fritchey

• The Scary DBA

I really like the automatic tuning aspect of Azure SQL Database. This post is not a full explanation and demo. Instead, I want to point out a small point...

2020-08-27 (first published: 2020-08-17)

222 reads

My First Hand-built AWS CodePipeline

• by Grant Fritchey

• The Scary DBA

I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already...

2020-08-19 (first published: 2020-08-10)

287 reads

Capturing Queries Can Be a Pain

• by Grant Fritchey

• The Scary DBA

The moment you decide you want to monitor your SQL Server instance for query behavior, you’re going to be forced to make a bunch of choices. Further, all these...

2020-08-11 (first published: 2020-08-03)

410 reads