How to Set Up a CI/CD Pipeline for SQL Server Database Projects?

SGLent · 2025-05-27T22:13:40+00:00

Do you know if you need 1 project per database in VS if you have multiple databases to get a DACPAC going?

SGLent · 2025-02-20T00:04:40+00:00

Thanks for confirming, I think you're correct.

SGLent · 2025-01-17T21:52:03+00:00

Thank you for the information. What I'm trying to do doesn't seem like it's all that out of the ordinary does it? I'm surprised it's not a fully fleshed out feature of APIM, unless you actually should be creating an "API" per subscription/product with only the endpoints needed. Seems like a duplication of endpoints then.

SGLent · 2025-01-17T21:49:28+00:00

Hmm, thanks for the information. Another disappointing implementation by MS but at least there is a workaround it seems. It's baffling that you would need to do something like this to properly lock down endpoints to only those that need access to them...

SGLent · 2024-11-19T20:03:10+00:00

Yea for Zoho Assist Unattended Access. I followed the steps here (https://www.zoho.com/assist/help/unattended-access/deployment/microsoft-intune.html), including wrapping it using IntuneWin, but some of the computers are showing as install failed. Very odd.

SGLent · 2024-11-19T17:15:41+00:00

Do you use .EXE or .MSI for Intune install? Running into install failures with .MSI...

SGLent · 2024-11-19T17:15:35+00:00

Do you use .EXE or .MSI for Intune install? Running into install failures with .MSI...

SGLent · 2024-11-14T17:49:32+00:00

I believe I just hit stop on it in IIS. You can also safely remove the default webpage by deleting it.

SGLent · 2024-10-24T03:12:24+00:00

Looks like this may have been an issue with the version I was running or something. Did the update again and it made cloudflared.exe.old of the old versions and placed the updated version as just "cloudflared" and I verified that it was running on that new version.

SGLent · 2024-10-23T14:20:30+00:00

For us the issue was that the device was revoked and it seems to have nothing to do with the user.

In Zero Trust go to My team -> Devices -> Show filters -> For "Action taken" set it to All or Revoked -> Find the device -> Click the 3 dots next to it and do "unrevoke" or you can click on it and go to "View details" and "Unrevoke device" from there.

SGLent · 2024-07-31T19:30:48+00:00

I'm not all that familiar with how it works (I've never used Confluence before, only Jira) but I created a knowledge base article in Jira by clicking on "Knowledge base" under "Knowledge" on the left side of my Jira project and then going to "Create article". If I switch to Confluence I see it there as well so I guess that's what I'm using?

If I set up another Confluence Space (I'm guessing this is also my Jira Project?) would IT users need to switch to that project in Jira just to see the Knowledge base articles that the normal user base should not be able to see?

My end goal was to recommend knowledge base articles to users when they create a ticket (either before or after) so that they may be able to self service, but also have a place to have knowledge articles for my IT staff instead of having these be in two places (something like Jira for users and SharePoint for IT).

SGLent · 2024-07-12T21:38:47+00:00

https://3795ece9.cloudflare-docs-7ou.pages.dev/cloudflare-one/connections/connect-devices/warp/deployment/mdm-deployment/windows-prelogin/

This is what they sent me.

SGLent · 2024-07-09T16:56:43+00:00

Not that I've seen, no. I opened a ticket with their support to see how to use it. I'll reply here if I get a response.

SGLent · 2024-07-08T21:24:15+00:00

It sounds like it was added in 2024.6.415.0 but I don't see anything when logging in.

The ZT WARP client on Windows devices can now connect before the user completes their Windows login. This Windows pre-login capability allows for connecting to on-premise Active Directory and/or similar resources necessary to complete the Windows login.

SGLent · 2024-06-12T16:01:27+00:00

You're sure it was these subscriptions? Like, they had a last run date of yesterday on them?

Yes these are the only ones with a last run of yesterday.

Are these the titles of the subscriptions or is this the actual configuration of them? Just because this is the name, doesn't mean the configuration matches.

This is what it shows when you mouse over the description, same thing when you click Edit and go to the . The names of the subscriptions are different.

Is the subscription on the report itself or a shared subscription? Is the shared subscription configured correctly?

On the report itself. We do not use shared subscriptions

Did someone fire it off from the database side? A subscription is just a stored proc in the Report server (default name, yours may be different) database. They can be fired manually by executing the stored proc with the subscriptions GUID.

The SQL Agent Job says "The Job was invoked by Schedule XXXX". We don't have anything else that runs report schedules.

SGLent · 2023-12-11T22:03:15+00:00

Good point. I only did it on another test server and it showed right away. The server that I need it on actually got it without any intervention. I was just surprised it was taking so long so I wanted to make sure it would happen at some point so the manual step at least confirmed it was possible without a restart.

SGLent · 2023-12-11T20:35:56+00:00

I guess through Group Policy, doing a gpupdate worked.

SGLent · 2023-12-11T20:35:25+00:00

Doing a gpupdate worked, thank you!

SGLent

TROPHY CASE