I like Azure Data Studio, but I think that's because I don't use it like you would, Steve. Five minutes ago, I had to re-run a SQL Job. I haven't...

• This reply was modified 1 year, 11 months ago by Rod at work.

I've been wondering what chances DevOps has in an organization which doesn't want to adopt DevOps. I work at a place where resistance to DevOps is predominant. Because...

I've been wondering what chances DevOps has in an organization which doesn't want to adopt DevOps. I work at a place where resistance to DevOps is predominant. Because this is...

I'm looking forward to this Stairway series. I've used Git with source code for several years but have never used it for database development. I'm really looking forward to what...

Here is a possible approach.

1. Get the code for your DB into a VS database project and check that into a DevOps Git repo.
2. Set the database project to...

By SaaS I was referring to Azure SQL DB/MI, not the whole application given that both of them provide SQL complete as a service to you with backups, availability...

@createindexnonclustered, I was thinking more along the lines of a PaaS approach, rather than a SaaS approach. I'd like to re-write the old ASP.NET project, simplifying it. A SaaS approach...

Does this give you what you need? It sounds like General Purpose tier serverless autoscaling databases will turn off automatically after a certain period of inactivity and they can...

Grant, the original posted is using Azure DevOps, not GitHub. So, GH Actions is out. The OP would have to use Azure Pipelines instead. (Essentially the same thing as GH...

That is amazing, @audionova!

The topic of how work may change in the future has interested me recently. I work in state government. Your admonition to work on our technical and soft skills is...

Insightful, David, thank you for that input. I have never used SSIS, so can't respond to that. I've written some SSRS reports. I think that they would work in a...

Dead right about Power BI and source control. It feels like MS never anticipated that Power BI reports would need to be subject to source control.

There are third-party apps...

• This reply was modified 2 years ago by Rod at work.

Huh. I didn't know about MS Access's database compare functionality. That's good to know and I'll tuck it away in my mind.

Yeah, I understand user's not wanting to upgrade due...

• This reply was modified 2 years ago by Rod at work. Reason: corrected

I completely agree that having the ability to keep source code for anything in source control is very important! I have a similar problem with an obsolete version of Microsoft...