Monthly Archives: September 2024

Effective Engineering

Posted on September 30, 2024 by way0utwest

I’m not the smartest developer or DBA. I find myself mystified at times by Itzik’s posts on T-SQL queries and I’m amazed at times by the complex systems that I see the DCAC people put together. I can usually figure … Continue reading →

Posted in Editorial | Tagged | Comments Off on Effective Engineering

Monday Monitor Tip: Compliance Checking for Old Versions

Posted on September 30, 2024 by way0utwest

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 to show a report to management of when instances were out … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Comparing an Old Running Total to Window Functions

Posted on September 30, 2024 by way0utwest

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 introduced. After SQL Server 2012, we had better ways to write … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Simple Talks Episode 7

Posted on September 27, 2024 by way0utwest

The season 1, seventh episode of Simple Talks is out. Check it out, with Ryan as the main host. Simple Talks is the Redgate podcast from myself, Grant, Ryan, and Louis. The main page is here, and it has links … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Simple Talks Episode 7