Helping Students with a Data Professional Career

At a recent event, I had a student ask about how to get started as a data professional. What types of things should they do? What platform should they work on or learn? Where should they focus time? What tools are available?

Those are all good questions and many of you likely have your own advice. I’ll give a few things to think about today, which are good for anyone that might want to get into the data field. I think this is still one of the better technical careers. I’ve suggested this to my kids, though only one of them went into a technical area. One is a therapist for autistic children and one helps run the ranch while pursuing a graduate degree in literature.

If I were to give someone advice on how to get started in a tech field, I’d likely start with these items: first, download the free SQL Server developer or Express editions. Most of us run Windows and this is a good place to start. Get SSMS, and learn to connect to your server. If you have struggles, ask a question in our forums.

From there, I’d suggest working through a book on SQL. Or look at our Stairway series on T-SQL (basic, beyond basics, advanced). Learn to work with data and query it. Learn to download and get datasets into a database, as well as how to query, update, and analyze the data. Those are key skills. If you want to manage systems, try setting up an Availability Group, ensure you have backups and can restore systems, and maybe explore replication and CDC.

If you want to develop applications, then start building something. Ask a GenAI for help, but produce a working system that lets you analyze some data. Pick sports data, or music data, or something else, and produce an application or report that conducts an analysis of the data. Work with something that’s interesting to you.

While you’re doing this, blog. Write about what you learn. Build a growing resume that showcases your skills. Chat with others online, build a network of people, and always have an up-to-date resume that you can send out to find a job. Your resume/CV and your blog are invaluable.

That’s my advice. Anything else you suggest?

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 | 1 Comment

Copilot Outside of SSMS Seems to Work

I read Brent’s first look at SSMS and Copilot in there. He didn’t have a great opinion of the tool, especially comparing it to Gemini or Claude. I haven’t tested this yet, mostly because I’ve got other stuff going on, but I decided to take his prompt and the code and drop it into the dedicated Copilot App on my Windows 11 laptop.

This is part of a series of experiments with AI systems.

I have a button that starts Copilot, so I pressed it and put in this prompt:

2025-05_line0075

This was copied from Brent’s post, and then his code copied and dropped in.

I was curious to see if this worked.

My Results

I thought my results were better. The first part of the response is shown below. Copilot sees the scalar function as a problem and rewrites things. I don’t love that this is just the query and not the CREATE OR ALTER PROC part, but still.

2025-05_line0073

Below this, it notes that I should test indexes and gives me the ones it would recommend. Then it goes into the fact that order by desc can be problematic. It also has a TOP 1 recommendation for the first query.

2025-05_line0074

The rest of the response is OK, and gets into some general things that might help me go past the recommendations.

2025-05_line0076

The prompting matters, as if I click on the “what are more perf opt techniques” I get a lot of generic stuff.

2025-05_line0078

Is AI going to make you a better DBA or developer? Maybe. It will give you things to think about, but you need to test them. You might even ask a GenAI tool for help on that. I did and got this:

2025-05_line0079

And below, some more steps.

2025-05_line0080

Not bad, and likely what a lot of people do, though perhaps not with #5, in which HammerDB is suggested to run this proc.

Learn to use GenAI tools, learn where they help (And save time) and where they can’t be trusted. That’s likely an ongoing battle for most of us, but these tools can help us be more productive.

Posted in Blog | Tagged , , | Comments Off on Copilot Outside of SSMS Seems to Work

A New Word: Falesia

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to them may not necessarily match – that your best friend might only think of you as a buddy, that someone you barely know might consider you a mentor, that someone you love unconditionally might have one or two conditions.

Wow, falesia is a disconcerting idea in itself. Just reading that makes me a little uncomfortable. I’m sure many people have falesia early on in their relationships, whether dating or friendship, thinking that the person you think is very important doesn’t feel the same way about you.

I tend to look at most people are equals and try to treat them that way. However, I also get uncomfortable at times when people praise me or thank me for the work I’ve done with SQL Server Central or SQL Saturday. In those cases, I’m sure that the importance we feel towards each other isn’t the same.

I know I have some falesia and I am definitely uncomfortable in those cases.

From the Dictionary of Obscure Sorrows

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

Changing the Paradigm of Work

I saw an article on AI usage that is based on an upcoming book that suggests redesigning the world around new tech, not adding it to existing things. The first example is how electricity was introduced to existing factories, but it only provided some incremental gains until new factories were redesigned around electric motors. There’s also an example given about reworking hotels to remove the front desk since that feature isn’t needed. Instead, people could walk in, and an employee with a tablet could find them to check them in.

I’m all for rethinking and redesigning processes. I do think we have a huge glut of software in many organizations that exists because processes have evolved across time, but not everything and we keep our old software. When we have a new need or want a new capability, we add new software (or add features), but we don’t necessarily throw out all the old software, processes, or habits. That wouldn’t be practical, often because when we implement something new, it might not meet all our needs. Or at least we don’t know it meets our needs at first.

I don’t love the examples, especially as I see organizations where Teams/Slack are heavily in use (not just in tech companies), and these tools have changed how people work. Not everyone has moved, and there is a lot of document sharing and legacy systems, but that’s also because not everyone wants to or can change at the same pace. However, lots of people have changed how they create, share, collaborate, communicate, and more because of these tools.

I also think the hotel example is silly (read the article to see more). I don’t need a desk, and often I check in and get my key without ever visiting a desk. However, I do like the desk because when I need something, I want to be able to find someone, not wander around looking for an employee or waiting for them to respond to some page. When there’s a desk I can see someone is there. I certainly don’t want a kiosk with an AI there to queue at to request a person help me.

GenAI LLMs are going to change work for a lot of people, especially those in tech. I don’t know that we can redesign the way we work now, as the technology is still advancing, and I’m not sure how we will want to integrate agents with GenAI to do work. We have to experiment and find ways to use this tech before we build too much. We also have to see it mature.

When we do, I bet many more people will start to use AI to generate code, change settings, deploy things, and more. I’m also sure that they will make many mistakes, at scale, and we’ll be using a GenAI agent to undo things, or perhaps we’ll have humans scrambling to fix systems. I wouldn’t be surprised to see the humans commonly fixing things as we might not trust the AI Agent (or our prompting) to fix our mistake.

If you could redesign work, what would you want out of an AI? Assume that it is at least as competent as someone you work with. Is there a way that a GenAI system would make your work smoother?

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 Changing the Paradigm of Work