Voice of the DBA

Category: Blog

Simple Talks Episode 7

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 to the audio versions as well as a the video one.

Another one recorded in Austin, during the Redgate 25th Birthday week. We tried doing one on the roof, but it was too windy.

We ended up in the conference room.

A bit has changed in my AI view since then, with a second trip to San Francisco and people talking AI more and more. I’ll have a few thoughts later in another post on the Small Data SF conference.

September 27, 2024
A New Word: the McFly effect

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 came into the picture.

I think this is interesting, and my kids likely experience this a bit since they’ve seen me with some people I grew up with. However, I don’t think I’ve ever experienced the McFly Effect because I have rarely seen my parents with anyone they grew up with.

I visited my Mother’s parents and family as a kid, but I barely remember that. Since then, no contact as she is estranged from them.

My Dad was born in another country and I’ve only seen him with family, of which he is the oldest, so I don’t get any view into him as a younger person. He always seemed too responsible.

I wonder how many others find this to be an interesting feeling.

From the Dictionary of Obscure Sorrows

September 27, 2024
Connection String Confusion in SSMS
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 do this in Management Studio (SSMS).

Yes, but be careful.

Getting a Connection String

There are lots of ways to get a connection string. You can build one, or use a site like https://www.connectionstrings.com/sql-server/ I tend to get them for applications, as I work more with app developers.

In any case, I’ll use this as my string:
```
Server=Aristotle;Database=Sandbox;Trusted_Connection=True;
```
If I open SSMs, I get a connection dialog like this one. I see the server, but if I wanted a specific database, I’d have to go to the second tab.

I could also go to the last tab, the Additional Connection Properties, and paste my string in there.

I press Connect and that works great.

If I open a new Query Window, I’m connected to the Sandbox database.

The Problem

Let’s change the connection. I’ll press the icon to the left of the database name in the image above. Then I’ll go to the second tab and pick a database. In this case, I’ve selected the Westwind database.

If I click Connect, I see this:

The connection string in the individual parameters overrides the selection here. If this were a day later, I might remember I’d put a string in the Additional Connection Parameters. I rarely use this and when this happened, I couldn’t figure out why this wasn’t working.

I thought this also happened with changing the main dialog and the server name, but this appears fixed. At least on SSMS 20.1, the additional connection parameters are linked with any saved systems I have on the first tab, so if I change servers in the drop down, the additional connection parameters link to the last entry for that server.

On my laptop, which has 20.2, I’ll enter this as a connection string in the last tab:

In this case, I have multiple container instances running on different ports. This instance is on port 41433. On the main tab of the connection dialog, I see this:

What happens when I press Connect? I get to this server:

The default port is SQL Server 2022, but the additional connection properties overrode the front screen in this case.

Summary

I’ve never had this problem in 30+ years of SQL Server work until this summer. However, it’s the first time I’ve really been focused on using connection strings more often than just entering values in the dialog. I only noticed this as I had a deployment going to one instance, but SSMS kept connecting to the other one and I didn’t realize this.

I think it’s OK to have conflicting values in locations, but it wasn’t clear to me that these values override others. This is documented on the MSLearn site, but it’s easy to miss this.

Hence this blog.
September 25, 2024
Small Data SF 2024

I have often made an effort to attend conferences in the past to grow my career. Even today, when I speak at a conference, I’ll try to go to a few sessions and learn something, but I can be distracted. It’s rare I focus on just learning stuff without other responsibilities.

I’m at Small Data today and tomorrow doing precisely that. I’m just an attendee, and today is a couple of workshops for me with a variety of talks tomorrow. It’s a real career growth opportunity for me and I’m excited. I’m doing the Data Warehousing and Design workshops today and sitting in sessions all day tomorrow.

I can’t remember where I heard of this conference, but when I saw the manifesto and sessions, I was intrigued. There were tentative plans this week for me to do a customer visit, but when that got delayed, I jumped on the opportunity to visit San Fran and learn something.

As I’ve worked with a lot of customers, I see the value of small data sets providing lots of agility for teams, while also allowing them to get work done, as long as the data sets are relevant and representative. That’s a big part of me pushing the Subsetter at Redgate.

In this case, the conference focuses more on analytics and AI, and likely more developers than DBAs, but I think it’s a chance to get different perspectives, maybe learn a few things, and perhaps get others to see my data viewpoint in the hallways discussions.

September 23, 2024