Monthly Archives: October 2024

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

The Cloud Security Problem

Posted on October 30, 2024 by way0utwest

Your management gets a great demo from a cloud vendor and decides that the organization needs to implement the new service/application/etc. quickly. Your team tries to comply, furiously learning and experimenting with integrations, software changes, infrastructure configuration, and more. Things … Continue reading →

Posted in Editorial | Tagged | 2 Comments

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

Databases for Executives

Posted on October 28, 2024 by way0utwest

There’s an article at Forbes about the Five Things Business Leaders Should Know about Databases. Disclosure, it’s by my boss, but I think it’s still a good read. These are points we’ve learned from research and work with customers and … Continue reading →

Posted in Editorial | Tagged | Comments Off on Databases for Executives