Your Favorite Improvement

SQL Server 2025 is out in preview form. CTP 2.0 is available for you to test, and there are quite a few changes that have been added to the platform. Some of these are already in the cloud, but this is your chance to test them in your environment.

This is version 17.x, though I don’t know we’ve really had 17 versions to work with. In any case, there have been a lot of versions in my career. I’ve connected to and worked on all of these: 4.2, 6.0, 6.5, 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019, 2022. No 2025 yet (other than install and a few basic queries), but that’s coming.

In that time, I’ve seen this platform evolve significantly, incorporating new features, capabilities, language changes, and more. SQL Server has been a very capable database platform for millions of users around the world. Many of you reading this have probably based a good portion of your career, if not all of it, on Microsoft SQL Server. I know I have, and it’s been a good career.

With that in mind, and trying to be positive, what is your favorite feature/improvement/change in SQL Server over the years? What has made a big difference in your career or job? Maybe this made your customers happy, maybe something made your job easier, or maybe there’s a change that just reduced your stress.

If you’re looking for a list of changes, there are some at Wikipedia, though this isn’t an exhaustive list. Brent wrote about his top 6 things, all of which are good changes. I certainly think that the DMVs are amazing when I look at other platforms and the lack of information they surface.

If I think about the things that have made a huge difference for my positions, I’d say that 2005 with CTEs and DMVs were huge. However, for me, the addition of the OVER() clause and Window functions are incredible. That is one of the language changes I have used a lot over the years to simplify aggregate queries that were much harder with GROUP BY structures.

The other feature that I think is amazing is the automatic seeding in Availability Groups. That alone makes it easy to add nodes, consider upgrades, and more without requiring long, slow backup copies. While I’ve rarely used it, I can think of many times in the past when it would have made my life much easier.

What is your favorite improvement to the platform over the years? Let me know which thing has made your job much easier, more efficient, or maybe more enjoyable.

Steve Jones

Listen to the podcast at Libsyn, Spotify, or iTunes.

Note, podcasts are only available for a limited time online.

Posted in Editorial | Tagged | Comments Off on Your Favorite Improvement

A New Word: Rivener

rivener – n. a chilling hint of distance that creeps slowly into a relationship – beginning to notice them laugh a little less, look away a little more, explain away their mood like it’s no longer your business – as if you’re watching them fall out of love right in front of you, gradually and painfully, like a hole in the radiator that leaves your house a little colder with every passing day, whose only clue is a slow, unnerving drip-drip-drip.

This chapter of the book seems to be a bunch of feelings that people have earlier in relationships, or maybe during bad relationships.

I’m sure I’ve felt rivener in the past, from former girlfriends, but I’m blessed that this isn’t the case now. My wife loves me and I feel the same way. There’s no rivener on the ranch between us.

From the Dictionary of Obscure Sorrows

Posted in Blog | Tagged , | Comments Off on A New Word: Rivener

Can You Ask for a Raise?

I mean, you can ask for a raise. It’s always an option, but is now the time to ask for a raise in this economic climate, where businesses can be unsettled and there are a lot of tech workers looking for jobs. I even saw a piece that noted many computer science graduates are struggling to get hired at the top tech firms. While that’s not where most people work, it seems that often other CIOs/CTOs look to the big tech firms for guidance, and they may choose to hire fewer new staffers as well.

This is on my mind at work after reading an article on asking for a raise that I added to the newsletter. It’s a response in the advice column where a reader asks how to go about asking for a raise when they think they deserve one. It is unclear in which industry or level this person works, so I am not sure if I think the advice is good.

The gist of the response is that anyone wanting a raise needs to make a business case about why they deserve more money. I agree with that, but the piece goes on to talk about cost of replacement and loss of knowledge. To me, those start to delve into the area of a stick over a carrot approach to asking for a raise. I have used those techniques, but only when I am truly ready to look for another job if they don’t agree. While you might think you know your manager, you never know when they (or their boss/HR) might take offense to you bringing up the losses from you leaving.

I’d also say that if you are successful with this, it might be a one-time thing, and it might affect future bonus/raise amounts as the company thinks you’ve already gotten extra compensation.

That’s not to say that you can’t ask for a raise. I’ve been successful making a business case that’s based on my salary compared to peers doing similar work. Experience matters a bit, but the job I do and my responsibilities matter more. Of course, if I’m near the top of a range, then I’m really asking for a promotion and a raise. That might make sense, or it might not. Ask yourself as you build a case if you’d respond well if you owned the company and this was presented to you.

Maybe the most important thing to evaluate is the situation in which your business finds itself right now. Is it doing well? Sales/revenue/profits increasing? Are they lean on staff and need to hire more? Or is that not the case? Does your management seem to value experience and the work you do or are most of the staff pressed to do more work over time, with your coworkers in similar situations?

Maybe most importantly, do you trust your manager?

If you don’t feel confident in positive answers to these questions, proceed cautiously. Asking for a raise is something I’d be very careful of, at least in the US in mid-2025, as it seems to be the hope of executives to use more AI to replace people. Couple that with the large number of people looking for jobs and this environment might cause a reasonable request to be denied or could create lingering ill will. That might not be worth a short-term raise.

Steve Jones

Listen to the podcast at Libsyn, Spotify, or iTunes.

Note, podcasts are only available for a limited time online.

Posted in Editorial | Tagged | Comments Off on Can You Ask for a Raise?

Adding SQL Server 2025 to my Laptop

I wanted to do some testing of SQL Server 2025 on my laptop. I have written before how I avoided installing SQL Server on the laptop and use containers instead. This post looks at adding a new version on the default port.

This page on MSLearn shows how to run the SQL Server 2025 container. I started here, when searching for “SQL Server 2025 container” on Google.

2025-06_line0100

It was nice to see this updated for 2025, and if I scroll down, I can see the docker container to pull. This is the important thing for me to add a new version of SQL Server.

2025-06_line0101

I could go to this URL to see all the tags, since I don’t want just latest. I want to know what version to run: https://mcr.microsoft.com/en-us/artifact/mar/mssql/server/tags

In this case, I want this tag: 2025-CTP2.1-ubuntu-22.04

Installing the New Version

If you read my previous article, I put a folder for each version on my system. In my case, I use c:\data. I’ll make a new folder for SQL 2025.

Note: I tried to copy this folder and subfolder and then delete files, but got permission errors on stratup. I made new folders and things worked.2025-06_line0104

Once in here, I’ll create sub folders for my mappings.

2025-06_line0105 

I will then copy over the docker-compose.yml file. In my case, I have all the 2022 stuff. I need to edit things.

2025-06_line0106\

Most things are fine here, but I’ll update the name and image. These need to use the 2025 values. Here are my edits.

2025-06_line0107

I save this, and then I copy/paste the two stop/start batch files. I’ve opened these in code and changed 2022 to 2025. I’ll show one file below, but basically I change the CD command in both.

2025-06_line0108

That’s it. If my SQL 2022 container that runs on the default port is stopped, I can double click the start2025.cmd file. Once I do that, I see the image coming down.

2025-06_line0110

As soon as that completes, the container starts. I can connect with SSMS to the local host. Same as my 2022 instance, whose container is stopped.

2024-07-16 20_35_33-000012

Once I connect, I see the new, default, instance of SQL Server 2025.

2025-06_line0113

I do have to remember to start/stop containers, but I love having multiple default instances Winking smile

Posted in Blog | Tagged , , | 1 Comment