Category Archives: Blog

2024 PASS Data Community Summit Prep

Posted on November 1, 2024 by way0utwest

Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling Monday to the event to see a few thousand fellow data professionals, developers, managers, and more. I expect quite a few people to be traveling this … Continue reading →

Posted in Blog | Tagged , , | Comments Off on 2024 PASS Data Community Summit Prep

A New Word: Bye-over

Posted on November 1, 2024 by way0utwest

bye-over – n.  the sheepish casual vibe between two people who’ve shred an emotional farewell but then unexpectedly have a little extra time together, wordlessly agreeing to pretend that they’ve already moved on. I used to feel a bye-over was … Continue reading →

Posted in Blog | Tagged , | Comments Off on A New Word: Bye-over

Counting Groups with Window Functions: #SQLNewBlogger

Posted on October 30, 2024 by way0utwest

I looked at row_number() in a previous post. Now I want to build on that and do some counting of rows with COUNT() and the OVER clause. I’ll show how this differs a bit from a normal aggregate. Another post … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Monday Monitor Tips: Projecting Disk Space

Posted on October 28, 2024 by way0utwest

One of the things that many DBAs struggle with is managing space across an estate. There might be one or two servers that you watch closely, or that are a constant problem, but it’s easy to run out of space … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Monday Monitor Tips: Projecting Disk Space