sql server – Read-Scale Availability Group between a Transactional subscriber and another machine

I am trying to configure Read-Scale replica between a transactional subscriber and a 3rd machine. I could create the group. But, when i attempted to add the DB (which is a transactional – subscriber) to be part of my read scale replica group, I am getting the following message and not able to complete my read scale replica. My replication is already configured and working fine. Configured the AG as well. All i am doing is, trying to add the DB to the AG.

Here is the message:
Special considerations exist when adding a replication Subscriber database to an availability group. For more information, see “Replication and Availability Groups” in SQL Server Books Online.

But the BOL is not saying anything about AG on a subscriber. Any help on this would be highly appreciated.

group theory – Copies of $mathbb{C}$ in Artin-Wedderburn decomposition

Let G be a finite group, and let R = $mathbb{C}$G be the group algebra. Show that the number of distinct group homomorphisms from G to $mathbb{C^*}$ equals the number of copies of C in the Wedderburn-Artin decomposition of $mathbb{C}$G.

I cannot solve it and my tutor gave me a hint — f: G to $mathbb{C^*}$ extends to a ring homomorphism f’: $mathbb{C}$G to $mathbb{C}$. The Ker (f’) is an ideal of $mathbb{C}$G. But I cannot justify the hint and still have no idea how to proceed. Any help would be greatly appreciated.

sharepoint online – SP REST – add an existing group to site with REST api?

You can assign permissions to SharePoint group using SharePoint REST API like:

function setPermissionForGroup(){
        url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/roleassignments/addroleassignment(principalid=<GroupId>, roledefid=1073741827)",
        type: "POST",
        contentType: "application/json;odata=verbose",
        headers: { "Accept": "application/json; odata=verbose","X-RequestDigest": $("#__REQUESTDIGEST").val(),"X-HTTP-Method": "POST" },
        success: function (data) {
            alert('Contribute permission set on group');
        error: function (data) {
            alert("Error: " + JSON.stringify(data));

Replace <GroupId> with the ID of SharePoint group. Open the SharePoint group & you will find the group ID in browser URL:

enter image description here

roledefid for Permission Levels are as follows:

  • Full Control: 1073741829
  • Design: 1073741828
  • Edit: 1073741830
  • Contribute: 1073741827
  • Read: 1073741826
  • Limited Access: 1073741825
  • View Only: 1073741924

You need to convert above REST call in Power Automate Send an HTTP request to SharePoint action.

permissions – Full control, Limited Access given through a group where the user does not exist?

I have a SharePoint site where, when searching for a user at site level (using check permissions) it comes back saying the user has “Full control, limited access – Given through the ‘Site Name’ Owners Group.

However, the user is not an Owner of the site and when I click into the Owners group, they are not listed in there either.

How is this user being provided with access at site level from the specified group when they don’t appear to be in that group and how would I go about visualising and removing these user permissions?

I should add that when I click the “There are limited access users on this site. Users may have limited access if an item or document under the site has been shared with them. Show users”. It doesn’t show any additional users, but instead replaces ‘Full Control’ with ‘Full Control, Limited Access’ against the Site Owners group.

leaflet – LeafletJs: how to refresh the tooltip text of a Cluster Group?

I am using LeafletJS and Cluster Groups, all very straightforward.

I added a date selection slider and, as the user adjusts it, I am updating the map.

It a tooltip is open, I would like to adjust it’s text. This code is working (but) :

            if (layer.isPopupOpen()) 
               const html = GenerateTooltipHtmlForCompanyMarker(layer.options.companyData);

BUT, it catches an open popup over a normal marker, but not over a Cluster Group marker.

How can I iterate all Cluster Group markers and find if one has a tooltip open, so that I can update its text?

Best way to group multiple libraries & lists, so that related data are close to each other

The way to group lists/libraries is using sites. If the seven lists are associated with each other, and not the other 43, then they should be in their own site. Sites also allow you to easily configure permissions, and then be default all lists/libraries in the site will have the same permissions.

If this really can’t be done, then perhaps create a page that lists the seven list and provide links to each list.

mysql – Group by unique pairs with no multiplicity

I have a table AreaLocation with AreaID as the PKey and Location whereby there are many locations for each AreaID. Correspondingly there is another table Books with:

BookingID | DriverID | BLocation | Miles | Fare

I’m trying to get the average efficiency of each driver by area, i.e. I’d looking for a view with

| DriverID | AreaID | AVERAGE(Fare/Miles) |

where I’d like to group by distinct DriverID/AreaID however I’m not sure whether the following will work:

 SELECT AreaID, Bookings.DriverID, AVERAGE(Bookings.Fare/Bookings.Miles) 
 FROM AreaLocations
 ( AreaLocations.Location = Bookings.Location )
 GROUP BY DISTINCT (AreaID, Bookings.DriverID)

as I don’t think distinct works on pairs.

gm.general mathematics – Control & Experimental Group Selection Methodology using STDEV and T-Test Methodology?

I would like to know if my methodology was ‘correct’:

I am trying to conduct an experiment on my stores.
I would like to find out the effect of a marketing campaign on the number of transactions.

Only about 20% of the stores are participating in the marketing campaign.

The original methodology was to use the entire 20% as the experimental group and the remaining 80% as the control group. Unfortunately, these two groups are incomparable in terms of number of transactions.
when plotted as box and whisker plots next to each other, their distributions are incomparable (mean, median, quartlies, min, max, etc).

So what I did was filter out the ‘outlier stores’ at each end until the box and whisker plots for each group were practically identical. I then ran a t-test on the filtered groups, we failed to rej the null (meaning that these groups are statistically the same prior to the promotion).

Now that we have 2 comparable groups for time -1, we run the promotion for a month.
after promotion month is over, we take the number of transactions from each group and run another t-test.
We Rejected the null in favor of the alternate Hypo, which is that these 2 groups are now statistically different with an alpha of 0.05.

My first question is: is this methodology okay ?

My second question is: alternatively from using box and whiskers and removing outliers until both groups’ descriptive stats are similar, can i use a normal distribution and STDEV to remove outliers and create comparable groups within my population ?
The box and whisker method worked to get a comparable groups as confirmed by the t-test, but is very manual. So i would like to create an automated method and was wondering if using a normal distribution and removing outliers by STDEV would be plausible ?

Sorry for the long read.
Thank you

How to join public group in Telegram group based on an invite code

Someone provide this: tg://join?invite=xxxxxxxx
(UIApplication sharedApplication) openURL:(NSURL URLWithString:@"tg://join?invite=xxxxxxxx") options:@{} completionHandler:^(BOOL success) {});

  1. if the xxxxxxx is private invite code, it worked.
  2. if the xxxxxxx is public invite code, the telegram show "This invite link has expired"
    What do I do?

Group membership moderators | NulledTeam UnderGround

This XenForo 2.0 / 2.1 addon will make it possible to assign ‘Group Moderators’ to your forum.
A group moderator is able to view / add / remove members from selected groups.
This permission can be assigned to existing moderators as well as regular members.


  • Give any member or membergroup the ‘Group Moderator’ role for selected groups
  • You can assign multiple Group Moderators to a group
  • The group moderator can view / edit / remove members from a group
  • Actions…