Still people using the same file over and over, sometimes with INIt, sometimes not, I would agree that it's not a good idea, but often it's because is not knowing...

AI gives a few suggestions. If you have the DDL and some sample data, could play around with a few options. I assume this is SQL 2022?

Haven't seen an update from Frank, so I edited the article to change each to easy.

Code edited

One thing you might consider if this is really needed is to create a new db of the right size and move data across. You'll need to do this in...

Agreed....

I've moved into the "doubtful" camp on AI becoming capable of "big successes" on its own.  It is a great junior developer and saves time on tasks, especially those...

Good luck in retirement and a side job.

I have to say, this weekend was my side job, coaching volleyball. Practice Sat am (and then some chores) and then all day...

Thanks for the followup. My guess is WinRM needed more than one port, and/or the firewall had failed in some way. Turning it off and on reset the system (it's...

Mostly agree on discipline and motivation, but discipline is forcing yourself to make choices and do something. It could be to keep going, it could be to stop because it's...

I think you're missing out. AI tech can help with coding and save time. It makes mistakes, as do other humans, but it also gets plenty right.

Have you tried a CLI call from an Execute Process task to http://ftp.exe or telnet.exe to verify from that machine things are working? Maybe wireshark the SSIS package to determine...

I've been wanting to learn more about Databricks myself. The challenge, as always, is time.

I don't know about a North Star for the year, but I need to dig a...

You are using DBCC SHRINKFILE?

Shrinking just data files?

Is this one ndf file that's grown or was sized too large?

Is there a reason you can't let this run from a machine...

Congrats all, send me a message here on the site with an email to use for an Amazon GC.