The Scary DBA

Blog Post

Extended Events in AWS RDS

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: )

132 reads

Blog Post

Execution Plan Properties

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

Blog Post

Azure Data Studio Intellisense

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

Blogs

Daily Coping 20 May 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 19 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

Read the latest Blogs

Forums

Running Trace - Error: Login timeout expired

By ramana3327

Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...

query perf issue

By siri_28

Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...

Looking for some guidance on avoiding Scalar UDFs for DB lookups

By SteveOC

Hello. I am not a SQL Developer - just an IT generalist (if that)...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers