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/

PASS Summit and Redgate Software

by Grant Fritchey

The Scary DBA

Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is...

2017-10-25

315 reads

Database Fundamentals #13: Data Entry Through T-SQL

by Grant Fritchey

The Scary DBA

T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...

2017-10-23 (first published: 2017-10-11)

1,862 reads

Database Fundamentals #14: Modifying Data Through SSMS

by Grant Fritchey

The Scary DBA

I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...

2017-10-16

496 reads

Database Fundamentals #12: Adding Data with SSMS GUI

by Grant Fritchey

The Scary DBA

In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing...

2017-09-25

433 reads

Database Fundamentals #11: Why Learn T-SQL

by Grant Fritchey

The Scary DBA

If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and...

2017-09-21 (first published: 2017-09-18)

1,963 reads

Azure, PowerShell, Databases and the PASS Summit

by Grant Fritchey

The Scary DBA

I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...

2017-09-19

427 reads

Database Fundamentals #9: Schemas As Containers

by Grant Fritchey

The Scary DBA

Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas...

2017-09-14 (first published: 2017-09-06)

2,299 reads

Speaking at IT/DevConnections 2017

by Grant Fritchey

The Scary DBA

If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...

2017-09-13

339 reads

Database Fundamentals #10: Modifying Tables

by Grant Fritchey

The Scary DBA

Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change...

2017-09-12

390 reads

Runtime Metrics In Execution Plans

by Grant Fritchey

The Scary DBA

Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...

2017-09-06 (first published: 2017-08-22)

1,597 reads

Blogs

How to Run Databases on Kubernetes: An 8-Step Guide

By Ige Adetokunbo Temitayo

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Episode 11 of Simple Talks: Oracle

The 11th episode is now live, recorded a few weeks ago at the PASS...

A New Word: Mornden

mornden – n. the self-container pajama universe shared by two people on a long...

Read the latest Blogs

Forums

Giving Thanks

Comments posted to this topic are about the item Giving Thanks

What is the best index strategy for a table that gets truncated?

Hi everyone My SSIS package does a bulk insert of csv files into a...

Blob Storage automated downloads

By Brandie Tarvin

Dipping my toes into the waters of Azure and of course before I get...

Visit the forum

Question of the Day

Running Steve's Code

Can you run this code in any of your SQL Server 2019 databases without error?

CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
    
        SELECT Consumer_ID ,
               Trend_Category ,
               Bit_Trace
        FROM    NewWorldDB.dbo.MarketTrend;
    
GO

See possible answers