Daily Archives: October 30, 2024

Counting Groups with Window Functions: #SQLNewBlogger

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

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