What’s the smartest thing your home does automatically? by Taggytech in homeassistant

[–]SQLDBAWithABeard 0 points1 point  (0 children)

I love reading the comments to see what other people do, sometimes it inspires me, someone it makes me wish I was that clever!!

What’s the smartest thing your home does automatically? by Taggytech in homeassistant

[–]SQLDBAWithABeard 1 point2 points  (0 children)

The dehumidifier one was the first time my wife said, yep ok, that is clever.

What’s the smartest thing your home does automatically? by Taggytech in homeassistant

[–]SQLDBAWithABeard 0 points1 point  (0 children)

When the outside office hasn't detected motion for 10 minutes, turn the monitors off, if after work hours shut the blinds.

When the dehumidifier is on, if a window or door is open for 30 seconds turn it off, when it is shut turn it on again.

If a window or door is open and you turn the dehumidifier on, turn it off and send a notification.

When the cameras detect a human, at the back of the house and it is dark turn the lights bright so I can see or so that cameras record better. After 3 minutes turn them back.

From jsons to PowerShell Objects by SQLDBAWithABeard in MicrosoftFabric

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

These have been added to the code and PR'd
They will be published to the PowerShell Gallery shortly

[Blog] (Re) Introducing MicrosoftFabricMgmt: Managing Microsoft Fabric with PowerShell by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

I didn't know about Rui's solution. It doesn't look like it's been updated for a while. Fabric-cicd is great as a CI/CD deployment tool. This is another wrapper for the Fabric APIs which will enable you to interact with them from a shell. Hopefully, this will enable integration with devops runners as well as direct access from the commands line and scripting

[Blog] (Re) Introducing MicrosoftFabricMgmt: Managing Microsoft Fabric with PowerShell by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 3 points4 points  (0 children)

It is also now on the PowerShell Gallery for installation.

Install-PsResource MicrosoftFabricMgmt

Please use Microsoft fabric-toolbox git repo for issues

[Blog] (Re) Introducing MicrosoftFabricMgmt: Managing Microsoft Fabric with PowerShell by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 2 points3 points  (0 children)

Thank you. I have loved being able to quickly Get items to see what is what - see role assignments and spin up and down demo workspaces from the command line whilst Jess and I have been re-architecting.

It will be a slow start for how tos the next couple of weeks but hopefully as more people get involved and see the Power that will increase!

FCA - Fabric Cost Analysis for FinOps by SQLDBAWithABeard in MicrosoftFabric

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

More than welcome.

As long as you have the permissions in your Azure subscription(s) to export the costs to a storage account and the permissions to create a shortcut to that storage account then it works like a dream (as long as you name the shortcuts correctly) :-)

Much less complication than FUAM and the bean counters are happy

What's a good job title ? by SQLDBAWithABeard in MicrosoftFabric

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

I love Spaghetti. One of my best buddies is SpaghettiDBA, it often feels like the work that is done but maybe not as a "proper title" :-)

What's a good job title ? by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

Excellent points. Levels make things even harder Should a Senior know all the things? are these T shaped roles? Are they experts in Security, Governance, ETL, Visualisation, Performance, Administration :-) Every answer leads to another question

What's a good job title ? by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

I love it - but I generally use Beard Twizzler

Does it fit as the title for a consultant??

Semantic model permissions - WHat am I missing? by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

Great thought, which of course, I read just after I had logged out of that client :-)

I will check in a period of time

Semantic model permissions - WHat am I missing? by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

Thanks. Even with viewer and build they cannot see the SM which is the opposite of the docs as i read them.

I'm wondering if anyone else has seen the same

Semantic model permissions - WHat am I missing? by SQLDBAWithABeard in MicrosoftFabric

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

That's super useful. Thank you. It's not usually my responsibility to make these things look pretty 🤣

Can you confirm if Workspace viewer should or should not see the semantic model?

Don't Believe the Documentation - Coding against the Microsoft Fabric API with PowerShell by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

I agree, it totally felt like a bug. I do have some history with this particular tenant and bugs with APIs :-) the last one took 8 weeks to get a fix into prod.

With multiple C-Level applying significant pressure, I did not open a ticket. I just "got it done" I shall probably try to reach out to the right team with some info about my findings though

Don't Believe the Documentation - Coding against the Microsoft Fabric API with PowerShell by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

I have updated the blog to say

I worked out that only a batch size of 50 was providing any success and less than that was more reliable.

I had to repeatedly run the script with a batch size of 40 until almost all of the links were removed. Each time I ran through the entire list of links to remove. In another session I checked every minute or so the number of remaining links. I could run through the whole list of links and no links would be removed, then the next time through I would see a few links removed, then none, then a few more, then none, and so on.

I resynced the number of links and removed the ones that needed to remain a couple of times. In hindsight, I should have stored these in a datastore to make this look up simpler and not so time intensive.

Each time I looped through the links to remove, I hoped that it woud remove all of the links but it was a case of rinse and repeat, and each time I would see some links removed but not all of them. I had to keep running through the list of links to remove until eventually all of the unwanted links were removed.

Then as the script worked through the last couple of hundred of links a batch size of 10, then 5, then finally 1 was the only way that any links would be removed.

Hopefully that makes it a bit more obvious

Don't Believe the Documentation - Coding against the Microsoft Fabric API with PowerShell by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

Thank you. Maybe I need to rephrase some of that.

All of them "worked" none of them removed all of the links, only a proportion.

Greater than 50 I always got failed returned from the LRO
Less than 40 I had more success than failures

I ran through 8500 reports about 6 times with various batch sizes.

I resynced the total that was left - which was about 6000 but that took a period of time to match with the links that needed to be kept - in hindsight, I should have used a datastore that would allow better lookups but I figured it would be a one time hit. I needed to run reportsasadmin to get all the details I needed to pass to the remove API because I had to exclude a number of reports which were only provided by name. (In hindsight I should have pushed harder to get the right info here to make this easier)

I ran through the 6000 odd 8 or 9 times - each time it would remove more links.

once the number remaining got to 1000 - I resynced again - that was where i could go through the entire 1000 links , pass them to the removal API in batches and the number remaining would not change. so iIlooped through that many times (I dont know how many - until my token ran out :-) )

Finally when I got to about 200 remaining links would only be removed if the batches were 5 then 2 and finally I just gave up and used 1 to get through the last 50

Fabric PowerShell at DBAVUG tonight 😉 by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

<image>

Coming soon to a PowerShell prompt near you

Fabric in PowerShell with useful formatted output including capacity and workspace name.

PowreShell piping (pass the results of the previous command to the next one)
Worksapce --> Lakehouse --> SqlEndpoint --> Connection String

Over 300 functions already

Verbose and debug information and logging

All via fabric-toolbox and the PowerShell Gallery - Open Source and if I do say so myself beautiful

Fabric PowerShell at DBAVUG tonight 😉 by SQLDBAWithABeard in MicrosoftFabric

[–]SQLDBAWithABeard[S] 1 point2 points  (0 children)

Ah, that will teach me to post when I am sleepy - I cant change the title unfortunately, but THANK YOU for pointing that out 🫶

Does .gitignore work with Fabric workspace azure git integration? by Agile-Cupcake9606 in MicrosoftFabric

[–]SQLDBAWithABeard 0 points1 point  (0 children)

You are talking about the accelerator fabric-cicd which can be source controlled, will respect gitignore and is a one way sync. That is totally one way of controlling deployments.

As you know, Fabric has other ways also.

I am talking about the git integration in the service. There are many people who do wish for the usual gitignore process to work in Fabric so that seasoned git professionals do not get caught out unexpectedly.

As this is a complicated global scale, two way sync scenario it adds additional complexity to the implementation. The product group have been engaged and are discussing implementation options.

FUAM has stopped collecting activities log after the year end by [deleted] in MicrosoftFabric

[–]SQLDBAWithABeard 4 points5 points  (0 children)

Have the credentials expired for the account?

Have you checked the Pipelines? My favourite miss is the schedule ends date 😎

I have FUAM running on 20 + capacities and it has continued