Category: News
Migration sql server from sql 2017 to sql 2022 with Minimal Down time
Below is our suggestion for the migration activity:
Always on High Availability
DB Mirroring
Logshipping
SQL Always on High Availability :
It is possible to configure a SQL Server Always On availability group with a primary replica running on SQL Server 2017 and a secondary replica running on SQL Server 2022, but there are important considerations and limitations to keep in mind:
Backward Compatibility: SQL Server supports having replicas on different versions, but the primary replica must be on an older version than or equal to the secondary replicas. Therefore, having SQL Server 2017 as the primary and SQL Server 2022 as the secondary is valid.
Database Upgrade Path: When you decide to upgrade the primary replica to a newer version, you need to follow a specific upgrade path to ensure minimal downtime and data integrity. Typically, this involves:
Adding the newer version as a secondary replica.
Failing over to the secondary replica running the newer version (making it the new primary).
Upgrading the former primary to the newer version.
Adding it back to the availability group.
Feature Compatibility: Some features available in SQL Server 2022 might not be fully supported or behave differently when the primary replica is running on SQL Server 2017. It’s essential to test the behavior of your applications and workloads thoroughly in this mixed-version environment.
Support and Documentation: Always refer to the official Microsoft documentation for the most accurate and up-to-date information about version compatibility and supported configurations. Microsoft’s official [documentation on Always On availability groups](https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-ver15) is a good place to start.
Licensing and Maintenance: Ensure that your licensing agreements and maintenance plans support such a configuration. Running different versions might have implications for your support agreements with Microsoft.
Here is a high-level example of setting up such a configuration:
Install SQL Server 2017 on the primary server and configure it as the primary replica.
Install SQL Server 2022 on the secondary server and configure it as the secondary replica.
Create the availability group on SQL Server 2017 and add the database(s) to the group.
Add the SQL Server 2022 instance as a secondary replica to the availability group.
Configure synchronization and verify that the secondary replica is properly synchronized with the primary replica.
Example Steps for Adding SQL Server 2022 as a Secondary Replica
On the Primary Server (SQL Server 2017):
ALTER AVAILABILITY GROUP [YourAGName]
ADD REPLICA ON ‘SQL2022ServerName’
WITH (ENDPOINT_URL = ‘TCP://SQL2022ServerName:5022’, AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL);
On the Secondary Server (SQL Server 2022):
ALTER DATABASE [YourDatabaseName] SET HADR AVAILABILITY GROUP = YourAGName;
Join the Secondary Replica to the Availability Group:
ALTER AVAILABILITY GROUP [YourAGName] JOIN;
Start Data Synchronization:
ALTER DATABASE [YourDatabaseName] SET HADR RESUME;
Always test such configurations in a non-production environment to ensure that everything works as expected and to understand any potential issues or performance implications.
DB Mirroring :
Using database mirroring to migrate a SQL Server database from SQL Server 2017 to SQL Server 2022 is a viable strategy. Database mirroring provides a way to maintain a synchronized copy of your database on the new server. Here are the detailed steps to perform the migration:
Step-by-Step Migration Process
Prepare the Environment
Install SQL Server 2022: Set up SQL Server 2022 on your new server where you want to migrate your database.
Network Configuration: Ensure that the network between the old (SQL Server 2017) and the new server (SQL Server 2022) is properly configured and both servers can communicate with each other.
Backup the Primary Database
Full Backup:
BACKUP DATABASE YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_Full.bak’;
Transaction Log Backup:
BACKUP LOG YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_Log.trn’;
Restore the Backup on the New Server
Copy the backup files to the new server.
Restore the Full Backup:
RESTORE DATABASE YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_Full.bak’
WITH NORECOVERY;
Restore the Transaction Log Backup:
RESTORE LOG YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_Log.trn’
WITH NORECOVERY;
Configure Database Mirroring
On the Principal (SQL Server 2017):
ALTER DATABASE YourDatabaseName
SET PARTNER = ‘TCP://SQL2022ServerName:5022’;
On the Mirror (SQL Server 2022):
ALTER DATABASE YourDatabaseName
SET PARTNER = ‘TCP://SQL2017ServerName:5022’;
Security Configuration: Ensure that the database mirroring endpoints are configured correctly and that the service accounts have the necessary permissions.
Monitor the Synchronization
Verify that the mirroring session is established and that the databases are synchronizing. You can use the following query to check the status:
SELECT
db_name(database_id) AS DatabaseName,
mirroring_state_desc,
mirroring_role_desc,
mirroring_partner_name,
mirroring_partner_instance
FROM
sys.database_mirroring;
Failover to the New Server (SQL Server 2022)
Once the database is fully synchronized, you can perform a manual failover to make the SQL Server 2022 instance the principal server.
ALTER DATABASE YourDatabaseName SET PARTNER FAILOVER;
Update Applications and Services
Point your applications and services to the new SQL Server 2022 instance.
Update connection strings to reflect the new server name or IP address.
Remove Mirroring (Optional)
If you no longer need mirroring after the migration, you can remove the mirroring configuration.
— On the Principal (now SQL Server 2022)
ALTER DATABASE YourDatabaseName SET PARTNER OFF;
— On the Mirror (SQL Server 2017)
ALTER DATABASE YourDatabaseName SET PARTNER OFF;
Considerations and Best Practices
Compatibility: Ensure that your database and applications are compatible with SQL Server 2022. Test in a non-production environment before migrating.
Downtime: Plan for a maintenance window, as there might be a brief downtime during the failover.
Backup and Restore: Always have a recent backup before starting the migration.
Using database mirroring can provide a smooth transition with minimal downtime, ensuring that your data remains consistent throughout the migration process.
Log Shippig :
Using log shipping to upgrade from SQL Server 2017 to SQL Server 2022 involves setting up log shipping between the two servers, synchronizing them, and then performing a cutover. Here are the steps to perform the migration using log shipping:
Step-by-Step Migration Process
Prepare the Environment
Install SQL Server 2022: Set up SQL Server 2022 on your new server.
Network Configuration: Ensure that the network between the old (SQL Server 2017) and the new server (SQL Server 2022) is properly configured and both servers can communicate with each other.
Configure Log Shipping
Full Backup of the Primary Database (SQL Server 2017):
BACKUP DATABASE YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_Full.bak’;
Copy the Full Backup to the new server (SQL Server 2022).
Restore the Full Backup on the New Server (SQL Server 2022):
RESTORE DATABASE YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_Full.bak’
WITH NORECOVERY;
Enable Log Shipping on the Primary Database (SQL Server 2017):
Right-click the database in SQL Server Management Studio (SSMS), go to “Properties,” and select “Transaction Log Shipping.”
Check “Enable this as a primary database in a log shipping configuration.”
Configure the backup settings (backup path, schedule).
Configure the Secondary Server (SQL Server 2022):
Specify the new server as the secondary.
Set the path to the backup folder where transaction log backups will be copied.
Configure the restore settings to restore the logs with the `STANDBY` option (so the database can be read-only for verification purposes) or `NORECOVERY` (if you want to keep it in a restoring state).
Start Log Shipping
Initial Transaction Log Backup:
BACKUP LOG YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_Log1.trn’;
Copy and Restore the Log Backup on SQL Server 2022:
RESTORE LOG YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_Log1.trn’
WITH NORECOVERY;
Schedule Regular Log Backups: Configure SQL Server Agent jobs to take regular transaction log backups on the primary and copy them to the secondary server.
Monitor Log Shipping
– Monitor the log shipping status using the Log Shipping Monitor or SQL Server Management Studio to ensure that the transaction logs are being backed up, copied, and restored correctly.
Perform the Cutover to SQL Server 2022
Stop All Transactions on the Primary Database (SQL Server 2017): Ensure no new transactions are occurring on the primary database.
ALTER DATABASE YourDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
Take a Final Log Backup on the Primary (SQL Server 2017):
BACKUP LOG YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_LogFinal.trn’;
Copy and Restore the Final Log Backup on the Secondary (SQL Server 2022):
RESTORE LOG YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_LogFinal.trn’
WITH RECOVERY;
Bring the New Database Online:
ALTER DATABASE YourDatabaseName SET MULTI_USER;
Update Applications and Services
Point your applications and services to the new SQL Server 2022 instance.
Update connection strings to reflect the new server name or IP address.
Considerations and Best Practices
Testing: Thoroughly test the log shipping configuration and the final cutover process in a non-production environment before doing it in production.
Downtime: Plan for a maintenance window during the cutover process as there will be some downtime.
Backup and Restore: Always have recent backups before starting the migration.
Log Shipping Monitor: Use the Log Shipping Monitor to ensure that all log shipping processes are running smoothly.
Log shipping for the upgrade provides a way to minimize downtime and ensure data consistency throughout the migration process.
Microsoft Tech Community – Latest Blogs –Read More
Cancel parfeval causes workers to throw errors
I’m writing a GUI in App Designer to run Simulink simulations in parallel, using parfeval because I need the ability to cancel in-progress tasks. The app has an Abort button that sets a global variable when it is pressed, which the fetchNext loop checks for. The function myFunc runs the Simulink models and does a lot of extra setup and processing as well. Here’s some abbreviated code:
% get or create pool
pool = gcp;
% schedule tasks
futures(1:numIterations) = parallel.FevalFuture;
for p = 1:numIterations
futures(p) = parfeval(@myFunc);
end
% collect results
numCompleted = 0;
timeout = 180; % 3 minute timeout
while numCompleted < numIterations
[completedIdx, results] = fetchNext(futures,timeout);
numCompleted = numCompleted + 1;
% collect results from tasks that didn’t time out
if ~isempty(completedIdx)
workerTasks{completedIdx} = results;
end
% check for abort
if app.abortRequested
break;
end
end
% check for abort
if app.abortRequested
cancel(pool.FevalQueue.QueuedFutures);
cancel(pool.FevalQueue.RunningFutures);
end
This runs fine, and the abort feature works the first time you use it.
Then if you immediately run the code again, several of the tasks come back Failed with the error message "Dot indexing is not supported for variables of this type." If you close down the pool and re-run the program with fresh workers, the problem disappears.
It seems like cancel doesn’t fully delete the job from the threads, and there’s something left over that interferes with new tasks. Has anyone run into this? Am I missing a step when canceling the futures?
Thanks in advance.I’m writing a GUI in App Designer to run Simulink simulations in parallel, using parfeval because I need the ability to cancel in-progress tasks. The app has an Abort button that sets a global variable when it is pressed, which the fetchNext loop checks for. The function myFunc runs the Simulink models and does a lot of extra setup and processing as well. Here’s some abbreviated code:
% get or create pool
pool = gcp;
% schedule tasks
futures(1:numIterations) = parallel.FevalFuture;
for p = 1:numIterations
futures(p) = parfeval(@myFunc);
end
% collect results
numCompleted = 0;
timeout = 180; % 3 minute timeout
while numCompleted < numIterations
[completedIdx, results] = fetchNext(futures,timeout);
numCompleted = numCompleted + 1;
% collect results from tasks that didn’t time out
if ~isempty(completedIdx)
workerTasks{completedIdx} = results;
end
% check for abort
if app.abortRequested
break;
end
end
% check for abort
if app.abortRequested
cancel(pool.FevalQueue.QueuedFutures);
cancel(pool.FevalQueue.RunningFutures);
end
This runs fine, and the abort feature works the first time you use it.
Then if you immediately run the code again, several of the tasks come back Failed with the error message "Dot indexing is not supported for variables of this type." If you close down the pool and re-run the program with fresh workers, the problem disappears.
It seems like cancel doesn’t fully delete the job from the threads, and there’s something left over that interferes with new tasks. Has anyone run into this? Am I missing a step when canceling the futures?
Thanks in advance. I’m writing a GUI in App Designer to run Simulink simulations in parallel, using parfeval because I need the ability to cancel in-progress tasks. The app has an Abort button that sets a global variable when it is pressed, which the fetchNext loop checks for. The function myFunc runs the Simulink models and does a lot of extra setup and processing as well. Here’s some abbreviated code:
% get or create pool
pool = gcp;
% schedule tasks
futures(1:numIterations) = parallel.FevalFuture;
for p = 1:numIterations
futures(p) = parfeval(@myFunc);
end
% collect results
numCompleted = 0;
timeout = 180; % 3 minute timeout
while numCompleted < numIterations
[completedIdx, results] = fetchNext(futures,timeout);
numCompleted = numCompleted + 1;
% collect results from tasks that didn’t time out
if ~isempty(completedIdx)
workerTasks{completedIdx} = results;
end
% check for abort
if app.abortRequested
break;
end
end
% check for abort
if app.abortRequested
cancel(pool.FevalQueue.QueuedFutures);
cancel(pool.FevalQueue.RunningFutures);
end
This runs fine, and the abort feature works the first time you use it.
Then if you immediately run the code again, several of the tasks come back Failed with the error message "Dot indexing is not supported for variables of this type." If you close down the pool and re-run the program with fresh workers, the problem disappears.
It seems like cancel doesn’t fully delete the job from the threads, and there’s something left over that interferes with new tasks. Has anyone run into this? Am I missing a step when canceling the futures?
Thanks in advance. parfeval, appdesigner, parallel.fevalfuture, parallel computing toolbox, cancel MATLAB Answers — New Questions
Display of errorbar function in plot legend
Hi
I am annoyed about a line going through the errorbar symbol in my legend. I have tried to make a dummy plot for handles, ploting it prior to all other plots with lines in them, but it does not change anything. I can not find any information about it in the documentation and I was not able to find any other treads where this was complained about and obviously not any solution either. I attached an image below since it is a bit hard to explain. Thanks a lot!
This is how I ploted the errorbar
errorbar(mean(x1),mean(y1),sdy1,sdy1,sdx1,sdx1,’k’)Hi
I am annoyed about a line going through the errorbar symbol in my legend. I have tried to make a dummy plot for handles, ploting it prior to all other plots with lines in them, but it does not change anything. I can not find any information about it in the documentation and I was not able to find any other treads where this was complained about and obviously not any solution either. I attached an image below since it is a bit hard to explain. Thanks a lot!
This is how I ploted the errorbar
errorbar(mean(x1),mean(y1),sdy1,sdy1,sdx1,sdx1,’k’) Hi
I am annoyed about a line going through the errorbar symbol in my legend. I have tried to make a dummy plot for handles, ploting it prior to all other plots with lines in them, but it does not change anything. I can not find any information about it in the documentation and I was not able to find any other treads where this was complained about and obviously not any solution either. I attached an image below since it is a bit hard to explain. Thanks a lot!
This is how I ploted the errorbar
errorbar(mean(x1),mean(y1),sdy1,sdy1,sdx1,sdx1,’k’) legend, errorbar, plot MATLAB Answers — New Questions
Model of a matrix
How can I model the matrix of full permutation [(1,1,0,…,0) (-1,-1,0,…,0)] for n variables.How can I model the matrix of full permutation [(1,1,0,…,0) (-1,-1,0,…,0)] for n variables. How can I model the matrix of full permutation [(1,1,0,…,0) (-1,-1,0,…,0)] for n variables. matrix, permutation MATLAB Answers — New Questions
Fluent UI Theme Designer – SharePoint theme assistance
Good day
I created a new theme for my site collection using Fluent UI Theme Designer and it looks ok. However, the icons on the landing page look odd with black as a title colour. How can I change this to colour white? Please help.
Good day I created a new theme for my site collection using Fluent UI Theme Designer and it looks ok. However, the icons on the landing page look odd with black as a title colour. How can I change this to colour white? Please help. Read More
VLOOKUP References to tables with new columns
Hello,
I have a question about shifting vlookup references when adding new columns to the referenced table.
Ex: I have a master data table with all my data
I have a few different tabs with vlookups to said data. If I add columns to the master table, my vlookup references shift the range properly (adds 1 more column) but not the column number.
Original formula:
After the new column add:
As you can see, it adds a new column to my range (AF to AG) but not the corresponding extra column (stays at 31).
How should I write it so it shifts and I can add/delete columns if ever needed?
Changing formulas manually is the absolute last resort as I have about 600 formulas that I would need to manually edit.
Thanks in advance!
Hello, I have a question about shifting vlookup references when adding new columns to the referenced table.Ex: I have a master data table with all my dataI have a few different tabs with vlookups to said data. If I add columns to the master table, my vlookup references shift the range properly (adds 1 more column) but not the column number. Original formula:After the new column add: As you can see, it adds a new column to my range (AF to AG) but not the corresponding extra column (stays at 31). How should I write it so it shifts and I can add/delete columns if ever needed? Changing formulas manually is the absolute last resort as I have about 600 formulas that I would need to manually edit. Thanks in advance! Read More
Access database query
I am trying to build a database for my law firm to log documents we are storing for clients. I have created the form that will form the record card for each client and I have a table that shows the basic client details (e.g. name, address, etc).
What I’d like to do, is to be able to hyperlink the Client ID number (primary key), so that when you click it on the table, the associated record card form pops up, so you can see/complete the details of the documents stored. I’m quite new to Access and there are lots of templates in Access that do this, but even with the use of Copilot, I just cannot seem to figure out how to do this.
Any guidance would be very much appreciated
I am trying to build a database for my law firm to log documents we are storing for clients. I have created the form that will form the record card for each client and I have a table that shows the basic client details (e.g. name, address, etc). What I’d like to do, is to be able to hyperlink the Client ID number (primary key), so that when you click it on the table, the associated record card form pops up, so you can see/complete the details of the documents stored. I’m quite new to Access and there are lots of templates in Access that do this, but even with the use of Copilot, I just cannot seem to figure out how to do this. Any guidance would be very much appreciated Read More
Highlighting any cell with ‘X'(text) based on a cells value in corresponding row
Hey guys,
I made a little manual schedule-planning sheet – but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the “Responsible’s” initials.
I just can’t figure this out – either with Conditional Formatting or VBA. Hope some of you can help!
Here is an example of what I mean, both in a sheet and a screenshot (I work in excel, not browser, it is just to share it):
https://docs.google.com/spreadsheets/d/1FADLbH4ZDIQZyLSMkv3j8m6UT-9ba0kaZpnpPndteys/edit?usp=sharin
So any cell marked with text under the date / schedule needs to marked the same color as the responsible for that task – e.g. any cells marked with text in a row where “NISOG” is responsible needs to be highlighted as light pink in this case.
I can’t figure out how to make it automatically so that any cells with text/values in the corresponding row as the “Responsible”‘s initials will get highlighted in a specific colour.
I can only figure out how to highlight a full row based on the initials under “Responsibility”, but this won’t suffice.
Hope some more skilled people out there can help! 🙂
Regards,
Nicky
Hey guys,I made a little manual schedule-planning sheet – but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the “Responsible’s” initials. I just can’t figure this out – either with Conditional Formatting or VBA. Hope some of you can help! Here is an example of what I mean, both in a sheet and a screenshot (I work in excel, not browser, it is just to share it):https://docs.google.com/spreadsheets/d/1FADLbH4ZDIQZyLSMkv3j8m6UT-9ba0kaZpnpPndteys/edit?usp=sharin So any cell marked with text under the date / schedule needs to marked the same color as the responsible for that task – e.g. any cells marked with text in a row where “NISOG” is responsible needs to be highlighted as light pink in this case. I can’t figure out how to make it automatically so that any cells with text/values in the corresponding row as the “Responsible”‘s initials will get highlighted in a specific colour.I can only figure out how to highlight a full row based on the initials under “Responsibility”, but this won’t suffice. Hope some more skilled people out there can help! :)Regards,Nicky Read More
I want to Develop Unit Conversion Website like UZZA
I wnat to develop Unit Conversion website like Uzza Soft , How can devlop this with bulk creation in .net ?
I wnat to develop Unit Conversion website like Uzza Soft , How can devlop this with bulk creation in .net ? Read More
Teams Room System Autopilot deployment does not work – Error Code: 6, 0x80180014
Problem:
We are attempting to deploy our Microsoft Teams Room (MTR) systems, some of which are already in use, using Windows Autopilot in self-deploying mode. Despite following the official guide, we keep encountering errors.
https://learn.microsoft.com/en-us/microsoftteams/rooms/autopilot-autologin
Procedure:
Device: Certified Intel NUC, previously in use.
Installation: Windows 11 Pro installed.
Autopilot Import: Device imported into Autopilot.
Group Assignment: GroupTag “MTR-ConsoleName” assigned.
Dynamic Group: Device appeared in the Dynamic MTR group.
Assignments: Deployment Profile and ESP (Enrollment Status Page) assigned.
Teams Room Update App: Deployed via Intune, assigned to the MTR group, and integrated into the ESP.
LAPS: Local Administrator Password Solution (LAPS) is active.
Teams Rooms Pro Console: Device appeared and was assigned to a resource account with a Teams Room Pro license.
Error Description:
After the setup process, we consistently encounter an error during device registration for mobile management:
Error Code: 6, 0x80180014
Attempts to resolve the issue:
Deleted the device completely from Intune and Autopilot and re-added it.
Created a custom Device Restriction Policy to allow all devices in the group.
Additionally, during one attempt where the error did not occur, Teams failed to set up automatically.
Questions:
Why does error 6, 0x80180014 occur during device registration for mobile management?
Are there specific requirements or settings beyond the official guide that need to be considered?
What steps can be taken to ensure that Teams sets up automatically when the registration error does not occur?
Objective:
We aim to ensure that the MTR systems are smoothly deployed via Autopilot in self-deploying mode and that Teams sets up automatically. Thank you for your support!Teams Room System Autopilot deployment does not work – Error Code: 6, 0x80180014
Problem:We are attempting to deploy our Microsoft Teams Room (MTR) systems, some of which are already in use, using Windows Autopilot in self-deploying mode. Despite following the official guide, we keep encountering errors.https://learn.microsoft.com/en-us/microsoftteams/rooms/autopilot-autologin Procedure:Device: Certified Intel NUC, previously in use.Installation: Windows 11 Pro installed.Autopilot Import: Device imported into Autopilot.Group Assignment: GroupTag “MTR-ConsoleName” assigned.Dynamic Group: Device appeared in the Dynamic MTR group.Assignments: Deployment Profile and ESP (Enrollment Status Page) assigned.Teams Room Update App: Deployed via Intune, assigned to the MTR group, and integrated into the ESP.LAPS: Local Administrator Password Solution (LAPS) is active.Teams Rooms Pro Console: Device appeared and was assigned to a resource account with a Teams Room Pro license.Error Description:After the setup process, we consistently encounter an error during device registration for mobile management: Error Code: 6, 0x80180014Attempts to resolve the issue: Deleted the device completely from Intune and Autopilot and re-added it.Created a custom Device Restriction Policy to allow all devices in the group.Additionally, during one attempt where the error did not occur, Teams failed to set up automatically. Questions:Why does error 6, 0x80180014 occur during device registration for mobile management?Are there specific requirements or settings beyond the official guide that need to be considered?What steps can be taken to ensure that Teams sets up automatically when the registration error does not occur?Objective:We aim to ensure that the MTR systems are smoothly deployed via Autopilot in self-deploying mode and that Teams sets up automatically. Thank you for your support!Teams Room System Autopilot deployment does not work – Error Code: 6, 0x80180014 Read More
Scheduling meetings with N facilitators who change for each meeting
Hello,
I have set up a Bookings system for my company to organize presentations with my clients. However, I am encountering an issue. I need to organize meetings involving multiple clients and facilitated by several members of my team.
My problem is that the facilitators vary for each meeting of the same service. Therefore, I cannot use the option “Assign all selected staff for an appointment” because it would send invitations to too many irrelevant collaborators, and this option does not allow me to select the specific facilitators I want for a particular meeting. So this option does not suit me because my meetings are scheduled over several weeks with multiple facilitators who vary from one meeting to another, which is not possible when selecting this staff assignment option
If I choose the option “Assign any of your selected staff,” it allows me to select the specific facilitators for each meeting (which is my goal), but it creates duplicate invitations. One of the selected facilitators ends up on the invitation with all the registered clients, while the other facilitators remain in the initial invitation.
Is there a solution to this problem so that I can precisely select facilitators each time I schedule a meeting, without ending up with a single facilitator having all the clients and without having to modify my service every time ?
Thank you in advance for your help.
Hello,I have set up a Bookings system for my company to organize presentations with my clients. However, I am encountering an issue. I need to organize meetings involving multiple clients and facilitated by several members of my team.My problem is that the facilitators vary for each meeting of the same service. Therefore, I cannot use the option “Assign all selected staff for an appointment” because it would send invitations to too many irrelevant collaborators, and this option does not allow me to select the specific facilitators I want for a particular meeting. So this option does not suit me because my meetings are scheduled over several weeks with multiple facilitators who vary from one meeting to another, which is not possible when selecting this staff assignment optionIf I choose the option “Assign any of your selected staff,” it allows me to select the specific facilitators for each meeting (which is my goal), but it creates duplicate invitations. One of the selected facilitators ends up on the invitation with all the registered clients, while the other facilitators remain in the initial invitation.Is there a solution to this problem so that I can precisely select facilitators each time I schedule a meeting, without ending up with a single facilitator having all the clients and without having to modify my service every time ?Thank you in advance for your help. Read More
Conditional Access and Teams MFA problem
Hello,
Problem : We have MFA trigger set to every 24hours for laptops with exclusion made “Microsoft Teams Services” because it will kick you out of a meeting if it triggers at that time, and we cant set the time of the MFA pop up, so we just excluded Teams.
That is applied to about 80% of the company correctly, but there is 4-5 people that still get asked for MFA every 24h hours by Teams.
I cannot find any factor that is the same on those users which could explain this.
On sign in logs i can see that the Conditional access policy was applied that has Teams excluded.
Anyone have any suggestions?
Best regards
Hello, Problem : We have MFA trigger set to every 24hours for laptops with exclusion made “Microsoft Teams Services” because it will kick you out of a meeting if it triggers at that time, and we cant set the time of the MFA pop up, so we just excluded Teams.That is applied to about 80% of the company correctly, but there is 4-5 people that still get asked for MFA every 24h hours by Teams.I cannot find any factor that is the same on those users which could explain this.On sign in logs i can see that the Conditional access policy was applied that has Teams excluded.Anyone have any suggestions? Best regards Read More
Handling AVD Disconnected session
Hi Team,
We are using Azure VD, and we don’t have domain services (GP option not available). Is there any Intune Policy or any other policy that could logoff the AVD user session from the session host VM instead just disconnecting the session.
I am looking for some way to log out/off the user session once its state is disconnected or any way to populate option for session host to have ‘log out/log off from the session instead ‘disconnect’
Regards,
Hi Team, We are using Azure VD, and we don’t have domain services (GP option not available). Is there any Intune Policy or any other policy that could logoff the AVD user session from the session host VM instead just disconnecting the session. I am looking for some way to log out/off the user session once its state is disconnected or any way to populate option for session host to have ‘log out/log off from the session instead ‘disconnect’ Regards, Read More
Saved places and location alerts – Microsoft Support
Details Family Safety location features, like how to save a place to your family map and set location alerts. Location alerts are a premium feature.
Set up drive safety – Microsoft Support
An explanation of drive safety, a premium Family Safety feature. This includes where it’s available and how to enable it.
Leave family group or remove members – Microsoft Support
How to remove members from your family group when you’re on your PC, including adult and child accounts.
sensitivity analysis from monte carlo
Hi, i’m trying to reach out for help from anyone expert here. I’m having trouble to run a sensitivity analysis. I have write a script to generate monte carlo uncertainty propogation for 2 paramaters. So, i want to run sensitity analysis from the script. But, i dont know how.
Here is the script. Can anyone help me to generate sensitivity analysis please?
PoissonRatio = 0.348;
diameter = 100;
pi = 3.142;
nsamples = 100000;
for i=1 : nsamples
modulus = 191.6e3+rand(1)*10.1e3;
thickness = 0.5+0.5*rand(1);
Po (i) = (2*pi*50*210.8);
pcr (i) = (2*pi*modulus*thickness^2)/(3*(1-PoissonRatio^2)*0.5);
pRankine (i) = (Po(i)/((Po(i)/pcr(i))+1))/1000;
end
min(pRankine);
max(pRankine);
mean(pRankine);
std(pRankine);
hist(pRankine,100);
% Calculate the mean and standard deviation of the output samples
sample_mean = mean(pRankine);
sample_std = std(pRankine);
% Plot a vertical line at the mean of the output samples
line([sample_mean sample_mean], ylim, ‘LineWidth’, 2, ‘Color’, ‘r’);
% Plot a shaded region around the mean representing one standard deviation
shaded_region = [sample_mean – sample_std, sample_mean + sample_std];
patch([shaded_region(1) shaded_region(1) shaded_region(2) shaded_region(2)], …
[0 max(ylim) max(ylim) 0], ‘r’, ‘FaceAlpha’, 0.2, ‘EdgeColor’, ‘none’);
% Label the plot
xlabel(‘pRankine (kN)’);
ylabel(‘Probability Density’);
title(‘Monte Carlo Uncertainty Propagation’);Hi, i’m trying to reach out for help from anyone expert here. I’m having trouble to run a sensitivity analysis. I have write a script to generate monte carlo uncertainty propogation for 2 paramaters. So, i want to run sensitity analysis from the script. But, i dont know how.
Here is the script. Can anyone help me to generate sensitivity analysis please?
PoissonRatio = 0.348;
diameter = 100;
pi = 3.142;
nsamples = 100000;
for i=1 : nsamples
modulus = 191.6e3+rand(1)*10.1e3;
thickness = 0.5+0.5*rand(1);
Po (i) = (2*pi*50*210.8);
pcr (i) = (2*pi*modulus*thickness^2)/(3*(1-PoissonRatio^2)*0.5);
pRankine (i) = (Po(i)/((Po(i)/pcr(i))+1))/1000;
end
min(pRankine);
max(pRankine);
mean(pRankine);
std(pRankine);
hist(pRankine,100);
% Calculate the mean and standard deviation of the output samples
sample_mean = mean(pRankine);
sample_std = std(pRankine);
% Plot a vertical line at the mean of the output samples
line([sample_mean sample_mean], ylim, ‘LineWidth’, 2, ‘Color’, ‘r’);
% Plot a shaded region around the mean representing one standard deviation
shaded_region = [sample_mean – sample_std, sample_mean + sample_std];
patch([shaded_region(1) shaded_region(1) shaded_region(2) shaded_region(2)], …
[0 max(ylim) max(ylim) 0], ‘r’, ‘FaceAlpha’, 0.2, ‘EdgeColor’, ‘none’);
% Label the plot
xlabel(‘pRankine (kN)’);
ylabel(‘Probability Density’);
title(‘Monte Carlo Uncertainty Propagation’); Hi, i’m trying to reach out for help from anyone expert here. I’m having trouble to run a sensitivity analysis. I have write a script to generate monte carlo uncertainty propogation for 2 paramaters. So, i want to run sensitity analysis from the script. But, i dont know how.
Here is the script. Can anyone help me to generate sensitivity analysis please?
PoissonRatio = 0.348;
diameter = 100;
pi = 3.142;
nsamples = 100000;
for i=1 : nsamples
modulus = 191.6e3+rand(1)*10.1e3;
thickness = 0.5+0.5*rand(1);
Po (i) = (2*pi*50*210.8);
pcr (i) = (2*pi*modulus*thickness^2)/(3*(1-PoissonRatio^2)*0.5);
pRankine (i) = (Po(i)/((Po(i)/pcr(i))+1))/1000;
end
min(pRankine);
max(pRankine);
mean(pRankine);
std(pRankine);
hist(pRankine,100);
% Calculate the mean and standard deviation of the output samples
sample_mean = mean(pRankine);
sample_std = std(pRankine);
% Plot a vertical line at the mean of the output samples
line([sample_mean sample_mean], ylim, ‘LineWidth’, 2, ‘Color’, ‘r’);
% Plot a shaded region around the mean representing one standard deviation
shaded_region = [sample_mean – sample_std, sample_mean + sample_std];
patch([shaded_region(1) shaded_region(1) shaded_region(2) shaded_region(2)], …
[0 max(ylim) max(ylim) 0], ‘r’, ‘FaceAlpha’, 0.2, ‘EdgeColor’, ‘none’);
% Label the plot
xlabel(‘pRankine (kN)’);
ylabel(‘Probability Density’);
title(‘Monte Carlo Uncertainty Propagation’); matlab, sensivity analysis, monte-carlo MATLAB Answers — New Questions
I can’t install add-ons
Hello,
I am using the student version of MATLAB (R2023a) and I want to install some Arduino add-ons and everytime it fails. This is the last erro I got and it seems there is nothing wrong with the installation. I tried on another computer too and I also get a failure error.Hello,
I am using the student version of MATLAB (R2023a) and I want to install some Arduino add-ons and everytime it fails. This is the last erro I got and it seems there is nothing wrong with the installation. I tried on another computer too and I also get a failure error. Hello,
I am using the student version of MATLAB (R2023a) and I want to install some Arduino add-ons and everytime it fails. This is the last erro I got and it seems there is nothing wrong with the installation. I tried on another computer too and I also get a failure error. matlab, add-ons MATLAB Answers — New Questions
3D data plotting in matlab as a cube?
I am using following code fvc = isocaps(trc,1e-4); the problem is arises with 1e-4, for example, if my data ranges 0 – 1, if I select 1e-4 as zero it will not display the part data having zero values, how to solve it?
Following is my code and data size is 139 48 176.
fvc = isocaps(trc,1e-4); % meshgrid(1:sizes) by default, not like you care about coordinates
patch(fvc,’FaceColor’,’interp’,’EdgeColor’,’none’) %interp
colormap(jet)
colorbar;I am using following code fvc = isocaps(trc,1e-4); the problem is arises with 1e-4, for example, if my data ranges 0 – 1, if I select 1e-4 as zero it will not display the part data having zero values, how to solve it?
Following is my code and data size is 139 48 176.
fvc = isocaps(trc,1e-4); % meshgrid(1:sizes) by default, not like you care about coordinates
patch(fvc,’FaceColor’,’interp’,’EdgeColor’,’none’) %interp
colormap(jet)
colorbar; I am using following code fvc = isocaps(trc,1e-4); the problem is arises with 1e-4, for example, if my data ranges 0 – 1, if I select 1e-4 as zero it will not display the part data having zero values, how to solve it?
Following is my code and data size is 139 48 176.
fvc = isocaps(trc,1e-4); % meshgrid(1:sizes) by default, not like you care about coordinates
patch(fvc,’FaceColor’,’interp’,’EdgeColor’,’none’) %interp
colormap(jet)
colorbar; 3d plots, 3d, plotting MATLAB Answers — New Questions
Data Rate calculation in 5G NR TDD scheduling
Hi all,
Could someone please help me out in finding the data rate calculated for each UE in the 5G NR TDD/FDD scheduling example using the 5G toolbox?
Thanks in advanceHi all,
Could someone please help me out in finding the data rate calculated for each UE in the 5G NR TDD/FDD scheduling example using the 5G toolbox?
Thanks in advance Hi all,
Could someone please help me out in finding the data rate calculated for each UE in the 5G NR TDD/FDD scheduling example using the 5G toolbox?
Thanks in advance 5g nr, scheduling MATLAB Answers — New Questions