Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

Back to Boston for SQL Saturday

Posted on October 1, 2024 by way0utwest

I’m leaving again tomorrow for a trip. This time I head back to Boston for a Redgate DevOps in a Day on Thursday and SQL Saturday Boston 2024 on Saturday. This is a fun event and one I’ve attended the … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

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