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.

SQLServerCentral Editorial

Be Prepared

I've been reading about the fires in Maui and the horrible loss of life there. My heart goes out to all involved. I hope, if you can, you donate to a good charity to help those poor people. It also inspired me to do another check on our emergency supplies and equipment. No, we don't […]

5 (2)

You rated this post out of 5. Change rating

2023-08-26

93 reads

SQL Server Execution Plans eBook, Third Edition, by Grant Fritchey

SQL Server Execution Plans, Third Edition, by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance.

5 (3)

You rated this post out of 5. Change rating

2023-08-16 (first published: )

5,370 reads

SQLServerCentral Editorial

Keep Sharing

I was given a little reward the other day. My son came home telling me that the manufacturing company he works for wants to build some custom test equipment using Arduino-style controller chips. I've been experimenting, pretty darned lightly so far, with these over the last year. He starts asking me about which controllers I […]

5 (2)

You rated this post out of 5. Change rating

2023-07-01

65 reads

SQLServerCentral Editorial

Trust!

The difference between a low trust society (few individuals within a trust circle outside your family and/or tribe) and a high trust society (general trust of individuals beyond immediate family/tribe associations) generally speaking can be measured as the difference between a low tech (low trust) and high tech (high trust) society. Yes, exceptions abound, but […]

5 (1)

You rated this post out of 5. Change rating

2023-06-03

96 reads

Blog Post

Why Put PostgreSQL in Azure

I’ve had people come up to me and say “PostgreSQL is open source and therefore license free. Why on earth would I put PostgreSQL in Azure?” Honestly, I think...

2023-05-17 (first published: )

229 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

By VAI

If anyone used artificial intel like Gee-Pee-Tee for writing T-SQL (MS SQL server) code...

Syntax Problem

By charliedurnin@gmail.com

I think that I am almost there but I am getting one red squiggle...

Excel Source [24]] Error: System.Exception: SqlTruncateException:

By yrstruly

Please assist. I am using SSIS to read data from an Excel sheet into...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers