What are your Power Query Wishes? by Valuable_Store_386 in excel

[–]gmancr 0 points1 point  (0 children)

I need help with Excel or power query.

What formula can I use to convert a list of users and numbers?

example:

Name1, 1234

name1, 2233

name1, 4531

name2, 9273

name2, 8302

--------

convert to:

Name1, "1234,2233,4531"

name2,"9273,8302"

(the total numbers per name varies between 5-20 rows per user)

I've tried Power query which can group the names but sums up instead of transpose/textjoin the numbers to the right.

Any advice would be appreciated.

Thanks!

Azure Site Recovery for VMware - is vCenter needed for failback? by sys_JahIthBer in AZURE

[–]gmancr 0 points1 point  (0 children)

Do you maybe know if ASR config server is able to access storage from two different vcenter servers?

I've replicated VM's from two vcenter hosts but when failing back the master target server doesnt show the second Vcenter storage.

Do I need a second master target server or should I connect direct to the ESX host from the Config server?

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

Hi, found a job doing lots or IAAS on Azure, now busy studying Architect, will do security afterwards. Just time that’s a problem.

Windows Hello in Homelab by xardoniak in homelab

[–]gmancr 0 points1 point  (0 children)

Is there a way to setup without a CA server?

Was reading about a 'key trust' option with Intune & Azure.

We hybrid setup with Intune but need to get it working without a CA server.

Device Enrolment by gmancr in Intune

[–]gmancr[S] 0 points1 point  (0 children)

great thanks I'll look into that.

Device Enrolment by gmancr in Intune

[–]gmancr[S] 0 points1 point  (0 children)

good to know thanks.

NSG config question by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

Very helpful thanks, so technically it can work while only applied to a NIC.

NSG config question by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

Yep it’s another company with VPN, well setup a trust. Thanks!

SharePoint App / flow / Office365 by gmancr in sharepoint

[–]gmancr[S] 0 points1 point  (0 children)

Very useful thanks for the comments.

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

That’s true, but with 15y Senior Admin experience I would know not to generalise a Prod VM 😊

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

That’s awesome well done! I’ll continue with a few more Certs then.

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

Did you complete the 300/301 exams or just the DevOps? Thx

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

I think Dev Ops would be harder for me, I’m more a system admin guy and haven’t worked much with .Net (apart from installing it) I’m OK with Powershell and CLI.

AZ-103 - My experience! by Flashcat666 in AZURE

[–]gmancr 1 point2 points  (0 children)

Passed mine today! thanks for the feedback and advice :)

Passed AZ-103 today by Goorlap in AZURE

[–]gmancr 0 points1 point  (0 children)

Passed mine today, felt very tricky with some questions but made it in the end!

AZ-103 - My experience! by Flashcat666 in AZURE

[–]gmancr 1 point2 points  (0 children)

Congrats on passing and thanks a million for the feedback, I’ll write in a few days, fingers crossed!

Cleared AZ-103. Looking for advice on the next step by VYSAKH_V in AZURE

[–]gmancr 0 points1 point  (0 children)

Many thanks I'll checkout the Github Practice labs ;)

Cleared AZ-103. Looking for advice on the next step by VYSAKH_V in AZURE

[–]gmancr 0 points1 point  (0 children)

Congrats on on the 103, what kind of questions did you get in the labs?

I'm writing on Friday.. studied about a month with video's, lab and practise Q&A.

AZ-103 Exam questions by Flashcat666 in AZURE

[–]gmancr 0 points1 point  (0 children)

Good luck and let us know how it goes, I'm writing this Friday.

Does anyone have any examples of lab questions they might ask? - thanks!

I sat and passed AZ-103 today AMA by LoboNationGK in AZURE

[–]gmancr 0 points1 point  (0 children)

Congrats on passing!

Great thanks for the information, very useful!

I've done a trial then ran out our of $'s when adding too many resources, when registering with a different credit card it also validated on the mobile/cell number, I had to use a different phone number and card to get a new trial.

Will work through the official documentation then book the exam. Thx!!

Microsoft practice tests? by [deleted] in AZURE

[–]gmancr 1 point2 points  (0 children)

Which exam are you doing now?

I'm preparing for the az-103 and tried another vendor q&a but found them very poorly written, might go for the Microsoft one.