Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

2024 PASS Data Community Summit Prep

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

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

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