SP Online: Search and offline availability not visible under Site Settings [I am Site Admin]

This is very strange issue, I used to have option of ‘Search and offline availability’ under Site Settings, but suddenly it got disappeared.

enter image description here

Details:

Site: SharePoint Online

Permission: Site Collection Administrator & Site Owner

Any reason for this behavior ?

Production availability impact of adding column to existing Cassandra table?

It appears that adding a column to an existing table in a production Cassandra cluster is pretty common. Under what conditions is it considered acceptable/safe to do so, in terms of availability and performance?

If it’s difficult or impossible to provide a definitive or clear-cut answer, then how would the expected impact be characterized? Impact might be expressed in terms of e.g. simply “no expected availability impact;” Big-O notation; or empirical measurements like duration of add operation, change in request latencies for impacted Cassandra cluster or (end to end for) client service, change in CPU or memory utilization of impacted cluster. Citations of a good resource(s) on the topic would be helpful.

Adding a database with Service Broker to an existing Availability Group on a new replica

  • Server 1 – SQL Server 2016 (Primary in existing AG)
  • Server 2 – SQL Server 2016 (Secondary in existing AG)
  • Server 3 – SQL Server 2016 (Offsite Secondary in existing AG)
  • Server 4 – SQL Server 2017 (New server, destined to become new primary)

An ~800GB database is happily running on the 2016 AG. It has Service Broker enabled and is running fine.

The plan is to restore the database onto Server 4, add it to the AG, then manually failover so Server 4 is the primary in order to upgrade Servers 1, 2 & 3 to SQL 2017.

Server 4 has a different drive configuration to the other Servers so in order to add the database to the AG, I am using dba-tools Restore-DbaDatabase command. The database must be left in NORECOVERY mode in order to finally add it to the AG.

The problem here is that Service Broker must be enabled via ENABLE_BROKER on the DB before it is added to the AG whereas this is not possible because of the NORECOVERY state of the DB. Also SET TRUSTWORTHY ON must be set.

Is there a way to achieve this without tearing down the whole AG?

I’m really trying to avoid this because it takes a long time to copy and restore backups onto the offsite server (Server 3) when initially joining the AG.

This guide has proved useful for the rest of the process.

HSR (high availability seamless redundancy)

I am going through the HSR (high availability seamless redundancy) code in Linux kernel. We need confirmation/help on below questions. Is Hardware support required for HSR as mentioned in wiki ? Or Will HSR work Without any hardware support, Just with HSR module that’s available in Linux kernel? From Wiki: https://en.wikipedia.org/wiki/High-availability_Seamless_Redundancy The cost of HSR is that nodes require hardware support (FPGA or ASIC) to forward or discard frames within microseconds Using below command I am able to create HSR device in my Linux PC where I have two NICs.

ifconfig eth2 0.0.0.0 down ifconfig eth1 0.0.0.0 down ifconfig eth2 hw ether 02:80:ad:20:57:23 ifconfig eth1 hw ether 02:80:ad:20:57:23 ifconfig eth2 up ifconfig eth1 up ip link add name hsr0 type hsr slave1 eth2 slave2 eth1 supervision 45 ifconfig hsr0 192.168.2.20

Google calendar: Show availability without revealing personal calendar details to admin

  • I have a “work” Google Calendar and several “personal” Google Calendars
    • The work calendar is administered by my company
  • I’d like to show coworkers my combined availability (work and personal), but hide the personal event details
    • I can’t share my personal calendar with the setting “Make changes and manage sharing” because I don’t want the admin to have full read/write access to it)

Is there a way to do this within Google Calendars?

Zapier allows me to automatically mirror new personal calendar events onto my work calendar, but this is expensive and inelegant. I’m hoping someone here knows a better way.

SQL 2016 Availability group

I am building and domain-less multi-subnet AG in SQL 2016. We have no AD or DNS, so for the Listener name resolution, I used the Windows HOST file. Now the clients can connect to the Listener, however, I am not sure about all the caveat of this approach. What are your thoughts.?.

The cluster validation returns a warning message saying HostRecordTTL value must be set to 360 for multi-subnet. Since no DNS involved in this configuration do I need to set it to 360?

Thanks

High availability web server for images [on hold]

There’s a task to organize a constantly updated cache servers of small jpgs (remote cameras will send to our service huge amount of images). This service should provide high availability, horizontal scaling and deep file storage (over years). Load balancer should be an important criterion, since we assume that the service will be highly loaded. What technologies to use for such servers?

HA-proxy is load balancer over nodes. Hadoop is not a choice due to minimum block size. May be I need to setup Ceph for a single storage over cache nodes? So, every node could handle file request over that cluster?

I never did such high load solutions with huge storage facilities. What can you advise to read? What strategy you see? Maybe it good point to allow your own application to write that files over nodes with route end user requests? But how to be with HA in that case if node fails?