Pokazywanie postów oznaczonych etykietą sql. Pokaż wszystkie posty
Pokazywanie postów oznaczonych etykietą sql. Pokaż wszystkie posty

2025-04-22

ADFS how to remove claim from output?

Should I focus on the question "how to remove claim"? But this is false question - I'm the administrator so it strictly depends on me what will be issued... So why I want to remove claim if I can just not issue this claim? Sorry, stupid question... But why I'm just looking for this statement/command with adfs? I'm trying to log adfs activity and I have an idea to store some activity data in sql database - querying for some claim, but this claim can be just included in input stream without issueing it.

Can it be a bottleneck? yes, of course, but I'm looking for how to better monitor activity on many apps - we have above 200 (two hundred) apps - some of them are in dev or test flavor so they are not heavily used, for production apps workload is huge. So this is only thinking.

2025-03-03

SQL MA schema refresh error

SQL MA failed to retrieve schema with error 0x80231100. For me sollution was simple - add port to SQL server (replacement of old server and tests with a new server). So from someSQL.some.domain to someSQL.some.domain,4773 - is enough to refresh schema.

2018-11-05

prepopulated view - indexed view

Just like prepopulated reports - especially time consuming - prepared at off-hours for views we can prepopulate data using indexed view. This type of view has additional requirements:
- view must be created WITH SCHEMABINDING
- tables must be specified with database name
- view can't be created from GUI

If view is used frequently and contains aggregation functions so it is equal to great gain of speed - because data is prepopulated and calculated.