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.
Pokazywanie postów oznaczonych etykietą sql. Pokaż wszystkie posty
Pokazywanie postów oznaczonych etykietą sql. Pokaż wszystkie posty
2025-04-22
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.
- 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.
Subskrybuj:
Posty (Atom)