I frequently use Common Table Expressions (CTEs) when I demo windowing functions and get questions about them. Windowing functions are limited to the SELECT and ORDER BY clause which means that you can’t filter or group on them directly. Using a CTE is one way to separate the logic of the query into multiple steps […]
2021-02-27
4,579 reads
Handling a budget can be an interesting experience for many technical professionals. Today Steve wonders if you treat this differently than your budget at home.
2021-02-26
120 reads
User interface is a part of software development that many technical people pay little attention to during the process of building something. However, it can be a problem for your customers.
2021-02-25
99 reads
Many organizations will change their teams around over time, but not all do this regularly. Steve talks about how Redgate does this every year.
2021-02-24
95 reads
2021-02-23
62 reads
2021-02-22
188 reads
2021-02-19
264 reads
2021-02-18
94 reads
Steve doesn't think he will ever work on server class machine again in terms of hardware. He wonders how many of you feel the same.
2021-02-17
136 reads
2021-02-16
106 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers