The Scary DBA

PostgreSQL and Azure Data Studio

• by administrator

• The Scary DBA

As I’ve been working more with PostgreSQL, I’ve found that I’m basically pretty happy just issuing SQL commands to get work done. However, it’s handy to have an actual...

2022-06-06

Extended Events in AWS RDS

• by Grant Fritchey

• The Scary DBA

For the longest time, we didn’t have one of the most useful tools for monitoring SQL Server behavior, but I just found out that, indeed, you can use Extended...

2022-05-11 (first published: 2022-05-02)

136 reads

Query Tuning and Easy Solutions

• by Grant Fritchey

• The Scary DBA

TLDR: There ain’t one. I was privileged last week to be able to present a couple of sessions at the SQL Server and Azure SQL Conference (great event, I...

2022-04-18 (first published: 2022-04-11)

568 reads

Two Years of “Good Morning!”

• by Grant Fritchey

• The Scary DBA

Two years ago at the start of the pandemic, I wasn’t feeling great about things. I saw that quite a few others weren’t all that thrilled about how things...

2022-04-04

23 reads

Execution Plan Properties

• by Grant Fritchey

• The Scary DBA

I’ve watched several people recently go straight to XML when reading execution plans because they didn’t know about the execution plan properties in the first operator. Now, don’t get...

2022-03-14

26 reads

Query Plans in Azure Data Studio

• by Grant Fritchey

• The Scary DBA

I have long been a fan of Azure Data Studio, but one shortcoming has kept me from truly adopting it: Query Plans in Azure Data Studio. Sure, there was...

2022-03-21 (first published: 2022-03-07)

320 reads

Database Fundamentals #31: Unique Constraints from the GUI

• by Grant Fritchey

• The Scary DBA

In the last few Fundamentals posts you were introduced to a couple of ways to limit and control the data stored in the tables in your database. A primary...

2022-02-28

10 reads

Azure Data Studio Intellisense

• by Grant Fritchey

• The Scary DBA

I recently saw a question about the Azure Data Studio Intellisense: “Why won’t intellisense in Azure Data Studio work with different schemas?” Immediately I thought, “Wait, it does.” But,...

2022-02-22

26 reads

Extended Events Session Properties

• by Grant Fritchey

• The Scary DBA

I like Extended Events and I regularly use the Session Properties window to create and explore sessions. I’m in the window all the time, noting it’s quirks & odd...

2022-03-02 (first published: 2022-02-15)

207 reads

SQL Server, PostgreSQL and the Future

• by Grant Fritchey

• The Scary DBA

This is just a quick note to talk about the future, mine, yours and this blog. First, I’m not abandoning SQL Server. I’m actively working on a revision of...

2022-02-09

26 reads