Comparing an Old Running Total to Window Functions

Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...

Comparing an Old Running Total to Window Functions

Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...

Converting Old Running Total Code to Window Functions

This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.

Effective Engineering

Platform engineering is a new area of focus for some, but it's already being seen as passé by some. Steve notes that there isn't a magic bullet for building better software. It comes about by us working together.

Migration Assistant Issues

Monday Monitor Tip: Compliance Checking for Old Versions

A customer recently wanted to know if any of their instances were too old and out of support. This was for a compliance purpose, and they had the need...

Monday Monitor Tip: Compliance Checking for Old Versions

A customer recently wanted to know if any of their instances were too old and out of support. This was for a compliance purpose, and they had the need...

Monday Monitor Tips–Finding CUs for My Instance

How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every...

A New Word: the McFly effect

the McFly Effect – n. the phenomenon of observing your parents interact with people they grew up with, which reboots their personalities into youth mode, offering you a glimpse...

Dead to Me

Today Steve looks at technology that's dead to him.