Hi there,

I’m in the progress of making a coupling between our  SIS (school information system) and Teams us MS Graph. In the past we used SDS for that, but that is going into a direction we don’t like. Not the discussion for now. This is:

Currently at the point where I have to make a decision on how to add owners/members to the teams I create. Teams being specialized groups I seem to have 2 options:

– with the groups add member/owner option (Add members – Microsoft Graph v1.0 | Microsoft Learn)

– with the teams add member/owner option (Add member to team – Microsoft Graph v1.0 | Microsoft Learn)

It seems that by adding them through the groups option there can be a 24 hour delay before the user is actually added to the team, and one of the team users will have to have been online in the Teams desktop app. A bit of a hazzle it seems.

Reading that I’m inclined to add them using the teams method.

But are there other consideration that I’m missing?

Peter

​Hi there, I’m in the progress of making a coupling between our  SIS (school information system) and Teams us MS Graph. In the past we used SDS for that, but that is going into a direction we don’t like. Not the discussion for now. This is: Currently at the point where I have to make a decision on how to add owners/members to the teams I create. Teams being specialized groups I seem to have 2 options:- with the groups add member/owner option (Add members – Microsoft Graph v1.0 | Microsoft Learn)- with the teams add member/owner option (Add member to team – Microsoft Graph v1.0 | Microsoft Learn) It seems that by adding them through the groups option there can be a 24 hour delay before the user is actually added to the team, and one of the team users will have to have been online in the Teams desktop app. A bit of a hazzle it seems.Reading that I’m inclined to add them using the teams method.But are there other consideration that I’m missing? Peter  Read More

​

Hi.

I hope there is a simple solution to my use case. I have an excel sheet where column G, H, J contains numbers, and row 2 cell J2:AB2 contains “priority” e.g 1,2,3,4,5 etc.

If G2 is >0 i need a fomula that sets either “some text” or a color on the cell and the subseqvent cells that corrosponds to the number in cell G7,H7,J7.

Example: G7=3 i need cells J7,J8,J9 to format either “text” or color and the rest of the cells nothing in the order from left to right/from lowest priority # to higher.

Thanks

Leif

Does this make sense?

​Hi.I hope there is a simple solution to my use case. I have an excel sheet where column G, H, J contains numbers, and row 2 cell J2:AB2 contains “priority” e.g 1,2,3,4,5 etc. If G2 is >0 i need a fomula that sets either “some text” or a color on the cell and the subseqvent cells that corrosponds to the number in cell G7,H7,J7. Example: G7=3 i need cells J7,J8,J9 to format either “text” or color and the rest of the cells nothing in the order from left to right/from lowest priority # to higher. Thanks Leif Does this make sense?  Read More

​

Today, I worked on a service request that our customer reported a performance issue and they reported that this query: SELECT StatMan([SC0], [LC0], [SB0000]) FROM (SELECT TOP 100 PERCENT [SC0], [LC0], step_direction([SC0]) over (order by NULL) AS [SB0000] FROM .. TABLESAMPLE SYSTEM (@samplePercent PERCENT) WITH (READUNCOMMITTED) ) AS _MS_UPDSTATS_TBL_HELPER ORDER BY [SC0], [SB0000] ) AS _MS_UPDSTATS_TBL OPTION (MAXDOP 16, RECOMPILE). I would like to share my lessons learned here.

It is important to mention that STATMAN is not a function that you can directly call in our queries. Instead, it refers to an internal process within SQL Server that is responsible for updating statistics on data distribution. 

When we execute UPDATE STATISTICS TableExample WITH FULLSCAN or the statistics are automatically updated by SQL Server engine we could see this type of query:

DECLARE @samplePercent FLOAT;
SELECT StatMan([SC0], [LC0], [SB0000])
FROM (
SELECT TOP 100 PERCENT [SC0], [LC0], step_direction([SC0]) OVER (ORDER BY NULL) AS [SB0000]
FROM [YourTable]
TABLESAMPLE SYSTEM (@samplePercent PERCENT)
WITH (READUNCOMMITTED)
) AS _MS_UPDSTATS_TBL_HELPER
ORDER BY [SC0], [SB0000]
) AS _MS_UPDSTATS_TBL
OPTION (MAXDOP 16, RECOMPILE);

Data Scanning: The TABLESAMPLE SYSTEM (@samplePercent PERCENT) clause indicates that a sample of the data is being scanned. Depending on the value of @samplePercent, this could involve a significant portion of the table’s data.

Sorting and Window Functions: The use of step_direction and the ORDER BY clause introduces sorting and window functions that can be resource-intensive, especially on large datasets.

Parallel Execution: The OPTION (MAXDOP 16) part of the query allows the operation to use up to 16 processors in parallel. While parallelism can speed up the operation, it also increases CPU usage and can lead to contention for resources.

Recompilation: The RECOMPILE option forces the query to be recompiled each time.

​Microsoft Tech Community – Latest Blogs –Read More 

So we’re currently testing out the Public preview of Windows 2025 and have noticed some new behaviour when testing out joining the OS to our domain. Initially all works well, the system joins the domain and our LAPS GPOs take over managing the local administrator password, allowing some of our automation to retrieve the password and start running tasks against the system.

However one thing we’ve noticed is that as soon as a gpupdate is triggered on Server 2025 it causes LAPS to immediately reset the password again, something that doesn’t occur on Server 2019 or 2022. This in turn causes our ansible automation to immediately begin failing because the credentials are now incorrect.

Does anyone know if this is intended behaviour? Or just a quirk of the Preview version? If it is intended behaviour is this something we can change? Given that it only seems to be happening for Server 2025 I’m hoping there might be some OS config we can change to stop it happening, but I’m not sure if we might need to make changes to our GPO instead.

​So we’re currently testing out the Public preview of Windows 2025 and have noticed some new behaviour when testing out joining the OS to our domain. Initially all works well, the system joins the domain and our LAPS GPOs take over managing the local administrator password, allowing some of our automation to retrieve the password and start running tasks against the system. However one thing we’ve noticed is that as soon as a gpupdate is triggered on Server 2025 it causes LAPS to immediately reset the password again, something that doesn’t occur on Server 2019 or 2022. This in turn causes our ansible automation to immediately begin failing because the credentials are now incorrect. Does anyone know if this is intended behaviour? Or just a quirk of the Preview version? If it is intended behaviour is this something we can change? Given that it only seems to be happening for Server 2025 I’m hoping there might be some OS config we can change to stop it happening, but I’m not sure if we might need to make changes to our GPO instead.  Read More

​

I was trying to record a video on my PC running Windows 10, but the built-in screen recorder, Xbox Game Bar, doesn’t allow me to capture my desktop or select a part of my screen. Is there any good solution for Windows screen recording in high quality?

​I was trying to record a video on my PC running Windows 10, but the built-in screen recorder, Xbox Game Bar, doesn’t allow me to capture my desktop or select a part of my screen. Is there any good solution for Windows screen recording in high quality?  Read More

​

I’m using an Asus laptop running Windows 11 and planning to download a YouTube playlist to my laptop. I wanted to do it online but it seams that there is no onlineYouTube playlist downloader that really works. Is there any suggestions on how to download all videos from a YouTube playlist at once in a safe and fast way?

​I’m using an Asus laptop running Windows 11 and planning to download a YouTube playlist to my laptop. I wanted to do it online but it seams that there is no onlineYouTube playlist downloader that really works. Is there any suggestions on how to download all videos from a YouTube playlist at once in a safe and fast way?  Read More

​