Category: Microsoft
Category Archives: Microsoft
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
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.
Microsoft Licenses Request
Are there any indirect providers who can assist me in providing Microsoft licenses to my customers? I am registered as a CSP Microsoft Partner and want to ensure a smooth process.
Thank you for your attention to this matter. I appreciate your prompt assistance.
Best regards,
Miftah Rizky
Are there any indirect providers who can assist me in providing Microsoft licenses to my customers? I am registered as a CSP Microsoft Partner and want to ensure a smooth process. Thank you for your attention to this matter. I appreciate your prompt assistance.Best regards,Miftah Rizky Read More
Categorization of a large, dynamic data set
I have a challenge which I can’t solve. Already tried multiple ways – makearray, byrow, etc. Nothing worked so far. Here is the challenge:
I have a large set of data (>20000 rows, dynamic). It holds a.o. segments and size of segment (a number). Let’s assume segment is in array A1# and size of segment is in array B1#. In a different table (~20 rows), all the unique segments are listed (named “Segments”). Next to this segment list, I have organized data for 3 categories (small/medium/large) for each segment. Each segment will have its own data for what is defined as small/medium/large. As such, I have 3 columns next to the segment name that holds number values for size thresholds.
In the large table, I now want to categorize each segment. Every segment (A1#) has a size (B1#) which corresponds to a category (small/medium/large) -> I.e. it needs a lookup in the category table.
I would want the formula to result in a spilled array – given the data is dynamic in nature.
Thanks for your ideas!
I have a challenge which I can’t solve. Already tried multiple ways – makearray, byrow, etc. Nothing worked so far. Here is the challenge:I have a large set of data (>20000 rows, dynamic). It holds a.o. segments and size of segment (a number). Let’s assume segment is in array A1# and size of segment is in array B1#. In a different table (~20 rows), all the unique segments are listed (named “Segments”). Next to this segment list, I have organized data for 3 categories (small/medium/large) for each segment. Each segment will have its own data for what is defined as small/medium/large. As such, I have 3 columns next to the segment name that holds number values for size thresholds.In the large table, I now want to categorize each segment. Every segment (A1#) has a size (B1#) which corresponds to a category (small/medium/large) -> I.e. it needs a lookup in the category table.I would want the formula to result in a spilled array – given the data is dynamic in nature.Thanks for your ideas! Read More
Clarification on Annual Cost and Maintenance for SQL Server with SA
Hi everyone,
I’m planning to purchase SQL Server with Software Assurance (SA). I noticed a mention of a cost of $15123, but it’s unclear whether this is a one-time payment or an annual fee. Could someone clarify the annual cost for this setup? Additionally, are there any maintenance costs that I should be aware of?
Thank you!
Hi everyone,I’m planning to purchase SQL Server with Software Assurance (SA). I noticed a mention of a cost of $15123, but it’s unclear whether this is a one-time payment or an annual fee. Could someone clarify the annual cost for this setup? Additionally, are there any maintenance costs that I should be aware of?Thank you! Read More
How can I fix Quick-Books Error UEXP
I’m encountering Quick-Books Error UEXP and need assistance in resolving it. What are the steps to troubleshoot and fix this error? Are there specific settings or updates I need to check?
I’m encountering Quick-Books Error UEXP and need assistance in resolving it. What are the steps to troubleshoot and fix this error? Are there specific settings or updates I need to check? Read More
How to build a social media assistant with Prompty and PromptFlow
How to build a social media assistant with Prompty and PromptFlow
Why Prompty.
Specification: Prompty is an asset class not tied to any language as it uses markdown format with yaml to specify your metadata. It unifies the prompt and its execution in a single package to quickly get started.
Tooling: using the Prompty extension, you can quickly get started in your coding environment and set up your configuration. It enables you to work with prompts at a high level with additional features such as metadata autocompletion, syntax highlighting, quick run and validation.
Runtime: Prompty additionally generates code for you in different frameworks e.g. LangChain, PromptFlow and Semantic Kernel. the asset class easily helps you convert to code simplifying your workflow as it is language agnostic.
Prerequisites and Authentication
To get started, you need to create a new Azure OpenAI resource on the Azure OpenAI Studio.
Once you create the resource, head over to Azure OpenAI Studio and create a gpt-35-turbo model deployment.
The first, and easiest way, to get started is by using environment variables. In your local environment, create a .env file, where you store your keys and endpoints. Your .env file, should be something like this:
AZURE_OPENAI_DEPLOYMENT_NAME = “”
AZURE_OPENAI_API_VERSION = “”
AZURE_OPENAI_API_VERSION = “”
AZURE_OPENAI_ENDPOINT =””
type: azure_openai
azure_deployment: ${env:AZURE_OPENAI_DEPLOYMENT_NAME}
api_version: ${env:AZURE_OPENAI_API_VERSION}
azure_endpoint: ${env:AZURE_OPENAI_ENDPOINT}
You can also, login to your Azure account using azd auth login –use-device-code, this will allow you to define your model configurations and update your settings.json files, allowing you to access your configurations without using environment variable.
Getting Started with Prompty
Install the Prompty extension
Right-click on the VSCode explorer and select “New Prompty.” This will create a new Prompty file in markdown format.
Configure your application metadata, in this case we will update as follows:
name: SociallyPrompt
description: An AI assistant designed to help you create engaging Twitter and LinkedIn posts
authors:
model:
azure_endpoint: azure_openai
azure_deployment: gpt-35-turbo
parameters:
max_tokens: 3000
temperature: 0.9
sample:
blog_title: LLM based development tools – PromptFlow vs LangChain vs Semantic Kernel
blog_link: https://techcommunity.microsoft.com/t5/educator-developer-blog/llm-based-development-tools-promptflow-vs-langchain-vs-semantic/ba-p/4149252
call_to_action: GitHub Sample Code at https://github.com/BethanyJep/Swahili-Tutor
post type: Twitter
Update your application instructions, use examples where necessary, for example, below is a sample instruction for our social media assistant:
You are an Social Media AI assistant who helps people create engaging content for Twitter. As the assistant,
you keep the tweets concise – remember that 280-character limit! Inject enthusiasm into your posts!
Use relevant hashtags to boost visibility for the posts. And have a call to action or even add some personal flair with appropriate emojis.
# Context
I am an AI assistant designed to help you create engaging Twitter and LinkedIn posts. I can help you create posts for a variety of topics, including technology, education, and more. I can also help you create posts for blog posts, articles, and other content you want to share on social media.
user:
{{post_type}} post for the blog post titled “{{blog_title}}” found at {{blog_link}} with the call to action “{{call_to_action}}”.
Once done click the run button to run your Prompty in the terminal
Extending functionality with Promptflow
Tracing your Flow
Resources
Our Social Media Assistant Prompty: BethanyJep/social-media-assistant-prompty (github.com)
Microsoft Build: Practical End-to-End AI Development using Prompty and AI Studio (microsoft.com)
Prompty samples: Collections | Microsoft Learn
Prompty documentations: prompty.ai
Microsoft Tech Community – Latest Blogs –Read More
Configuring ADF Pipeline to Fetch and Store Large Tables as Single JSON Files
I have 14 tables on a client server that need to be fetched using REST API calls. Each table contains between 71 and 800,000 rows, but the page size for fetching data is limited to 100 rows. The REST API does not provide a nextPage link; instead, it uses the parameter “startRow” to specify the starting row for each page. For example, setting startRow=101 fetches rows 101-200.
Our goal is to copy the tables from the REST API connector to ADLS storage as .json files and then transfer the data to a SQL Server. Each table should be stored as a single .json file in ADLS, despite being fetched in multiple pages. Thus, we need 14 .json files, one for each table, in the ADLS storage folder.
Could someone guide me on how to configure the copy data activity’s source and sink to achieve this? Any leads would be greatly appreciated.
#ADF #copyactivity #pagination
I have 14 tables on a client server that need to be fetched using REST API calls. Each table contains between 71 and 800,000 rows, but the page size for fetching data is limited to 100 rows. The REST API does not provide a nextPage link; instead, it uses the parameter “startRow” to specify the starting row for each page. For example, setting startRow=101 fetches rows 101-200.Our goal is to copy the tables from the REST API connector to ADLS storage as .json files and then transfer the data to a SQL Server. Each table should be stored as a single .json file in ADLS, despite being fetched in multiple pages. Thus, we need 14 .json files, one for each table, in the ADLS storage folder.Could someone guide me on how to configure the copy data activity’s source and sink to achieve this? Any leads would be greatly appreciated.#ADF #copyactivity #pagination Read More
Rounding a Date down if it doesn’t exist in Month
Hi,
I am trying to round any date in a series that doesn’t exist (e.g if 31st doesn’t exist in month, round down to 30, if it’s 31st in Feb, round down to 29, etc) in a month down.
Ex (Array 1):
2024-02-31
2024-04-31
2024-08-31
2024-09-31
Formula should output the following from Array 1 (e.g rounding down to closest date):
2024-02-29
2024-04-30
2024-08-31
2024-09-30
Any ideas on how this can be done? My thanks in advance.
Hi, I am trying to round any date in a series that doesn’t exist (e.g if 31st doesn’t exist in month, round down to 30, if it’s 31st in Feb, round down to 29, etc) in a month down. Ex (Array 1):2024-02-312024-04-312024-08-312024-09-31Formula should output the following from Array 1 (e.g rounding down to closest date):2024-02-292024-04-302024-08-312024-09-30Any ideas on how this can be done? My thanks in advance. Read More
