The Scary DBA

Execution Plans: First Operator

The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first...

2020-01-14 (first published: )

461 reads

Tracking CPU Use Over Time

A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...

2019-12-16 (first published: )

615 reads

Blogs

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

I’m Speaking at #SQLSatSpokane

By

I am super excited to announce that I have been selected to speak at...

Common commands and tasks to make dealing with Windows Core easier.

By

I don’t know how many of you are working with Windows Core these days...

Read the latest Blogs

Forums

SSAS processing Cubes using DTExec vs. SSDT 2017 tools?

By datsun

Hello We have Analysis Server cubes on SQL 2016/Windows 2019 environment. Using dtexec to...

Dynamic Connection String for Dataflow Task

By oogibah

Hey Guys, I've been tasked with doing a task where I connect to a...

SPN troubles - once more...

By KrisVerheyen

HEllo, I've been looking trough the forums on topics about setting and removing SPN's...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers