Category Archives: Blog

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

A New Word: the McFly effect

Posted on September 27, 2024 by way0utwest

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 of the dreamers and rascals they used to be, before you … Continue reading →

Posted in Blog | Tagged , | Comments Off on A New Word: the McFly effect

Connection String Confusion in SSMS

Posted on September 25, 2024 by way0utwest

Recently I was trying to use a connection string to connect in SSMS. There are some tools that have a connection string available as an output, including some Redgate tools. ADS lets me paste in a connection string. Can I … Continue reading →

Posted in Blog | Tagged , , | 2 Comments