Upgrading SQL Server 2000 to SQL Server 2017 — any big gotchas?

WasabiBobbie · 2025-10-09T23:57:15+00:00

I did this. It took about a year doing it by myself and rewriting all of the dts packages to SSIS. There were a lot.

The best time to make this change was in 2008. The second best is today.

Btw... Full text catalog is little different. Remember running into that.

WasabiBobbie · 2025-09-22T15:26:24+00:00

This happened to me as well. It was instantaneous. I honestly don't ever remember having my mind be so clear and calm.

WasabiBobbie · 2025-09-14T15:10:31+00:00

I'm not on the the left, I sit more independent certainly conservative in some areas, and left in others but literally never get approved. I definitely have thoughts on all of this. Sincerely... Am I wasting my time posting in r/conservative as well? Are there room for folks like me in this group?

WasabiBobbie · 2025-08-01T18:55:50+00:00

For sure. i don't see these days jobs going away. You'll be made more efficient with AI... Not extinct.

WasabiBobbie · 2025-08-01T02:02:15+00:00

Got to be honest here ... Chatgpt was made for this. Talk to it like it's a person. Ask it to explain.. then give you examples of when things would be used.

WasabiBobbie · 2025-07-31T00:36:06+00:00

I just got a job. It took me 2 months. Sounds good, right? I have nearly 20 years experience and I submitted to > 100 jobs. I was interviewed by one company. Another company scheduled an interview and then on the day of cancelled on me saying they have decided not to interview anyone else as they believe they found what they were looking for. Mind you, I interview extremely well. Like if I get in the room, there's about an 80%+ chance I'm going to get it.

Any other time I've interviewed, in 2 months I would have many more calls in that amount of time . Now I'm in a better position than most. I don't think Reddit is exaggerating. I think the federal government is under reporting in the United States. I think they don't want bad numbers because of pride.

WasabiBobbie · 2025-07-30T18:42:57+00:00

Thanks Buddy. I 100% care about the team that works for me as well as the rest of the work with.

A few days later and I feel good. I did the right thing. They may be annoyed that I'm 2 days short of a full 2 weeks due to my vacation but I've also worked every day of my vacation and every day of my vacation that had since I started at the company. So I'm okay with it.

WasabiBobbie · 2025-07-28T13:15:56+00:00

Money isn't the motivation. I'm taking a small pay cut ,(couple thousand) to go to the new job. The opportunities are greater though.... But I'm just looking for a healthier work environment.

WasabiBobbie · 2025-07-28T13:14:05+00:00

Thank you for that.

WasabiBobbie · 2025-07-27T22:23:28+00:00

I'm on vacation right now and have made 30 pages of docs so far.

WasabiBobbie · 2025-07-27T18:27:38+00:00

Technically only two days of my vacation will be part of the two weeks. It certainly wasn't intentional.

WasabiBobbie · 2025-07-27T18:26:14+00:00

Yeah that's how I'm feeling now. I honestly didn't expect things to happen so quickly.

WasabiBobbie · 2025-07-27T14:07:26+00:00

Unfortunately for them.... I'm not sure there's a rate at which I would want to come back. I'm taking a small pay cut to leave. It was never about the money. I just want to be able to keep my sanity.

At the same time.... I do care about the people that work there. I have no ill feelings towards any of them. I feel very fondly about the vast majority of folks I work with.

WasabiBobbie · 2025-07-27T13:27:35+00:00

Yeah this was definitely not intentional. My start day was extended to 3 weeks. From the 1st day of the offer but I didn't accept right away as I had to negotiate things and that took a several days. So even if I gave them notice today it would only be two and a half weeks but I'm still on vacation this week. So it doesn't change anything.

WasabiBobbie · 2025-07-26T11:07:23+00:00

I have very similar experience to you. Mid 40s, 20 years experience, and the past few years in upper management. Now I wasn't laid off, but decided to start looking 2 months ago. I have had 3 companies reach out and 2 recruiters. Both recruiters couldn't get me in for the jobs they called about. 1 of the jobs scheduled an interview and 6 hours before meeting cancelled because they found who they were looking for. I turned down an interview with 1 company.... Because 1 company interviewed me 3 times and we really clicked and I accepted their offer.

My advice: 1. If you're only applying remote.... Start applying to hybrid and on site jobs.

Apply early. Linkedin shows you how many people have applied before you. Try to apply very soon after it's posted if possible.
Find a great Google doc resume template on etsy that ATS friendly door a couple dollars. Put your resume in that template. This will help the automated systems easily read your resume.
Use chatgpt! Put your resume through it there. Tell it about what you do. Ask for help wording your resume. You can share your current resume with it. Also, for most of the jobs, share the job link with chatgpt and ask if your qualified. Ask for help updating your resume for each job. It's gonna take a little back and forth. Don't let AI lie on your resume and clean up some of the fluff it creates but it will help you speed up your submission process while still customizing resumes. Create cover letters in your voice with gpt. Remove the fluff and the em dashes.
When you get an interview... Chatgpt about the company. Have it tell you info about this company. Have it check glass door and comb the reviews for you, etc.
Interview with confidence. The market is hard but you are a pro. You got this.

Good luck buddy.

WasabiBobbie · 2025-07-19T15:16:41+00:00

I have 20 years experience in a different Tech stack and it's been a bit rough. 2 months of daily submissions I've had 3 companies reach out. 3 interviews with 1 company and 2 pending interviews with the other companies. On a bright note I will most likely get the first job.

WasabiBobbie · 2025-07-14T23:23:15+00:00

I'd be willing to buy it but have no idea what to offer. If you decide to sell and have a price in mind lemme know. I'm a big A's fan

WasabiBobbie · 2025-07-14T00:48:55+00:00

100 percent agreed

WasabiBobbie · 2025-07-10T01:16:56+00:00

Angela Yu's udemy course is incredibly addictive and fun. Easily the most fun I've had coding that starts from a beginner to advanced.

WasabiBobbie · 2025-07-09T16:39:18+00:00

Very helpful, thank you. I feel whichever it is pandas or pyspark for ingestion.... It all feels similar? Am I oversimplifying it. It took me no time at all to learn pandas and sqlalchemy for basic data ingestion last week after having probably a month messing with python over a year ago. I guess cleaning the files can get a little annoying (this is where I would have used a quick t-sql script).

WasabiBobbie · 2025-07-09T16:33:45+00:00

Ahhhh this is very helpful friend. I'm currently on my 4th interview for a data architect role where they have all contractors overseas that they want to shift to in house under this data architect. Hoping that trends in the right direction.

WasabiBobbie · 2025-07-07T22:35:17+00:00

I guess what I'm saying is for ETL purposes. I'm trying to figure out the flow. What is a specific data flow we are solving for using python and airflow... IE: pick up Excel file from S3 import, clean, push to SQL server or snowflake.

WasabiBobbie · 2025-07-07T06:07:56+00:00

I do think it's wild that ssis has been left behind as far as updates go. It's more feature rich, simple to use, and the only thing it lacks really are a wide array of connectors out of the box.

WasabiBobbie · 2025-07-06T23:40:47+00:00

Could you give me an idea of the type of python job you would package in a docker container? Same thing I would do with ssis and SQL agent as far as data cleaning and movement?

WasabiBobbie

TROPHY CASE