Category: Microsoft
Category Archives: Microsoft
Online disaster recovery between SQL Server 2022 and Azure SQL Managed Instance is now GA
Today, we are announcing the general availability of the following two major capabilities of the Managed Instance link feature with SQL Server 2022:
Two-way failover between SQL Server 2022 and SQL Managed Instance through the link to unlock true disaster recovery (DR) with Azure
Creating a link from SQL Managed Instance to SQL Server 2022 to unlock off-PaaS data mobility for regulatory and dev/test scenarios
These two link feature capabilities have been previously in public preview.
We’re also really pleased to share the details of these notable updates within the link feature space.
Simplified T-SQL link failover
Starting with SSMS 20.2, you can now fail over a link by using Transact-SQL (T-SQL), which also simplifies the steps executed by the Failover wizard in SSMS.
You can now initiate a planned failover from the primary instance by using a single T-SQL command:
SQL
–Execute on the instance (SQL Server or SQL MI) hosting the primary database replica
ALTER AVAILABILITY GROUP [<DAGname>] FAILOVER
Similarly, you can now initiate a forced failover from the secondary instance using a single T-SQL command:
SQL
–Execute on the instance (SQL Server or SQL MI) hosting the secondary database replica
ALTER AVAILABILITY GROUP [<DAGname>] FORCE_FAILOVER_ALLOW_DATA_LOSS
These improvements help:
Link users manage multiple links simultaneously, so they can create a script to fail over multiple link failovers in parallel.
Simplify failover by removing external orchestration of planned failovers to eliminate possible user error.
For more details, please visit Fail over link – Azure SQL Managed Instance | Microsoft Learn.
Easily drop a link in SSMS
A dedicated wizard has been added to SSMS to easily drop a link, without waiting for data synchronization. Although in some scenarios (migration, or one-way failover to Azure SQL Managed Instance), the link is dropped automatically, there may be other situations where a user wants to drop a link manually. This new wizard makes it easy to do so, cleaning up artifacts and metadata on both SQL Server and Azure SQL Managed Instance.
For more details, please visit Configure link with SSMS – Azure SQL Managed Instance | Microsoft Learn.
New link feature how to guides and doc improvements
We’ve improved the quality and depth of our link feature documentation with the addition of several how to guides, and an expansion of the best practices article. To explore this new content, please visit Configure & manage content reference – Azure SQL Managed Instance | Microsoft Learn.
Update policy for Azure SQL Managed Instance and the link feature
Recently, the update policy setting was added to Azure SQL Managed Instance, giving customers the powers to choose between a database format that aligns with SQL Server 2022, or a database format that allows early adoption of SQL engine features available to SQL Managed Instance customers.
Please note that using the link with SQL Server 2022 requires your SQL Managed Instance to be configured with the SQL Server 2022 update policy. The SQL Server 2022 update policy supports data replication through the link, and database mobility between SQL Server 2022 and Azure SQL Managed Instance. After switching your instance to the Always-up-to-date update policy, you will no longer be able to restore your SQL Managed Instance database to SQL Server 2022, or replicate data from SQL Managed Instance to SQL Server 2022 through the link. Updating to the Always-up-to-date update policy is irreversible.
Improved Azure CLI and PowerShell support for the link
Azure CLI and Azure PowerShell support for the link is currently partial and limited to replication from SQL Server to Azure SQL Managed Instance. Full native Azure CLI and Azure PowerShell commands are scheduled to be released by the end of 2024, including two-way failover between SQL Server 2022 and SQL Managed Instance, and creating a link with Azure SQL Managed Instance as the initial primary to replicate from Azure to SQL Server 2022.
Links to Azure CLI and Azure PowerShell reference content will be added to this blog post once they’re available, so stay tuned!
Microsoft Tech Community – Latest Blogs –Read More
एयरटेल पेमेंट बैंक से कैसे बात करें?
एयरटेल पेमेंट बैंक से कैसे बात करें? ग्राहक सेवा 0886//-1111//-624 +पर कॉल करें और रद्दीकरण का अनुरोध करें, वे आपसे कारण पूछेंगे और फिर आपका पेटीएम 24 horse दिनों के बाद आपको अपना रिफंड मिल जाएगा
एयरटेल पेमेंट बैंक से कैसे बात करें? ग्राहक सेवा 0886//-1111//-624 +पर कॉल करें और रद्दीकरण का अनुरोध करें, वे आपसे कारण पूछेंगे और फिर आपका पेटीएम 24 horse दिनों के बाद आपको अपना रिफंड मिल जाएगा Read More
Lbank Invitation Code ”20OFF” | Get 20% Discount on Trading Fees for Lifetime
Lbank Invitation Code ”20OFF” | Get 20% Discount on Trading Fees for Lifetime
The Lbank Invitation Code for 2024 is ”20OFF”. Use this code to get a 20% discount on trading fees for a lifetime. This guaranteed discount will apply to all your trades, whether you’re just starting or already an expert.
Additionally, if you have any questions or need further discounts, feel free to contact me directly on Telegram at @shaileshkumarverma for exclusive offers!
Here are the details of the offer:
Exchange Lbank
Lbank Invitation Code20OFFTrading Fee Discount20%Discount DurationLifetimeSupportTelegram: @shaileshkumarvermaDate2024-25
Make sure to use the Lbank Invitation Code ”20OFF” during your account registration for guaranteed savings. If you face any issues, don’t hesitate to reach out to me on Telegram!
Lbank Invitation Code ”20OFF” | Get 20% Discount on Trading Fees for LifetimeThe Lbank Invitation Code for 2024 is ”20OFF”. Use this code to get a 20% discount on trading fees for a lifetime. This guaranteed discount will apply to all your trades, whether you’re just starting or already an expert.Additionally, if you have any questions or need further discounts, feel free to contact me directly on Telegram at @shaileshkumarverma for exclusive offers!Here are the details of the offer:Exchange LbankLbank Invitation Code20OFFTrading Fee Discount20%Discount DurationLifetimeSupportTelegram: @shaileshkumarvermaDate2024-25Make sure to use the Lbank Invitation Code ”20OFF” during your account registration for guaranteed savings. If you face any issues, don’t hesitate to reach out to me on Telegram! Read More
Canary 27723 and dark lcd screen
Unfortunately, you released the Canary 27723 build, which is causing me a lot of problems. After completing its installation, I can hear the startup screen sound (login screen sound) in the background, but I have a dark screen (as if the screen matrix was unplugged). To find a solution, I entered safe mode and ran the computer through scanhealth, restorehealth and scannow. Additionally, I used the NVIDIA cleanup application. After such actions, I managed to start the computer with the screen in normal mode and log into the system. Unfortunately, a few minutes later, my laptop started as if selecting some components, because it flickered with the image quality resolution, after which my screen turns off and the keyboard backlight turns off. The backlight turns on again after about 30 seconds, but the screen remains dark.
I will add that this situation does not occur on the previous version 27718.
The problem occurred to me a few times (several attempts) and only each time I restored the version to 27718 it solves it. In turn, trying to run the new, installed build 27723 unfortunately ends with the system loading each time, a black laptop screen and only the sound of the system login window playing in the speakers.
The problem concerns MSI GT72 6QE Dominator pro with NVIDIA 980M card
Unfortunately, you released the Canary 27723 build, which is causing me a lot of problems. After completing its installation, I can hear the startup screen sound (login screen sound) in the background, but I have a dark screen (as if the screen matrix was unplugged). To find a solution, I entered safe mode and ran the computer through scanhealth, restorehealth and scannow. Additionally, I used the NVIDIA cleanup application. After such actions, I managed to start the computer with the screen in normal mode and log into the system. Unfortunately, a few minutes later, my laptop started as if selecting some components, because it flickered with the image quality resolution, after which my screen turns off and the keyboard backlight turns off. The backlight turns on again after about 30 seconds, but the screen remains dark.I will add that this situation does not occur on the previous version 27718.The problem occurred to me a few times (several attempts) and only each time I restored the version to 27718 it solves it. In turn, trying to run the new, installed build 27723 unfortunately ends with the system loading each time, a black laptop screen and only the sound of the system login window playing in the speakers.The problem concerns MSI GT72 6QE Dominator pro with NVIDIA 980M card Read More
WAF custom rule for bock others cookie and permit only a specific cookie name and value
Hello all,
I need to create a custom WAF rule that only allows traffic for a specific request URI (/example-path) if it contains a particular cookie, Cookie=abc123, and blocks all other requests.
Additionally, could someone clarify the difference between configuring the policy this way:
RequestHeaders[‘Cookie’], Operator=DoesNotEqual, Values=”Cookie=abc123″RequestCookie, Values=”CookieName”, Operator=Equal, valueOfTheCookie=”abc123″
I hope I explained myself clearly. Thanks in advance for your responses!
Hello all, I need to create a custom WAF rule that only allows traffic for a specific request URI (/example-path) if it contains a particular cookie, Cookie=abc123, and blocks all other requests.Additionally, could someone clarify the difference between configuring the policy this way:RequestHeaders[‘Cookie’], Operator=DoesNotEqual, Values=”Cookie=abc123″RequestCookie, Values=”CookieName”, Operator=Equal, valueOfTheCookie=”abc123″I hope I explained myself clearly. Thanks in advance for your responses! Read More
Where to get the correct Message ID for the Graph API Parameter?
Hello, I need help.
I am using this API:
https://graph.microsoft.com/v1.0/me/messages/{id}/attachments
Where I get the message ID is from here:
But the response always fails, and I’m sure it has something to do with the validity or format of the message ID. Is there any way I can find the correct format of the message ID? Or is there any way I can find other ways to find the message ID in the UI of Outlook web?
Hello, I need help.I am using this API:https://graph.microsoft.com/v1.0/me/messages/{id}/attachments Where I get the message ID is from here:But the response always fails, and I’m sure it has something to do with the validity or format of the message ID. Is there any way I can find the correct format of the message ID? Or is there any way I can find other ways to find the message ID in the UI of Outlook web? Read More
Bitmex Invite Code ”Iy5YJ3” Get 20% Rebate On Trading Fees for Lifetime
Bitmex Invite Code (Iy5YJ3) | Get 20% Rebate On Trading Fees for Lifetime
Unlock exclusive savings on Bitmex with the Bitmex Invite Code “Iy5YJ3”! Use this invite code to get a 20% rebate on trading fees for a lifetime, making your crypto trading journey more cost-effective and profitable. Whether you’re a beginner or a seasoned trader, this code provides significant savings on every trade you make on the Bitmex platform.
Bitmex is one of the most reliable and well-established cryptocurrency exchanges, offering a wide range of futures and derivatives trading for major cryptocurrencies like Bitcoin, Ethereum, and more. By using the invite code “Iy5YJ3” when signing up, you’ll instantly start benefiting from the 20% rebate on trading fees for life, giving you a financial edge in the fast-moving crypto market.
Here are the key details for the offer:
Exchange Bitmex
Bitmex Invite CodeIy5YJ3Trading Fee Rebate20%Rebate DurationLifetimeDate2024-25
To activate this rebate, all you need to do is enter the Bitmex Invite Code “Iy5YJ3” during the sign-up process. Once applied, your account will be eligible for reduced trading fees on every transaction, allowing you to maximize your gains with minimal costs. This offer is valid for lifetime rebates, ensuring long-term savings and better returns on all your trades.
Don’t miss out on this great opportunity to reduce your trading expenses. Sign up today using the invite code “Iy5YJ3” and enjoy lifetime rebates on Bitmex, one of the top crypto trading platforms.
Bitmex Invite Code (Iy5YJ3) | Get 20% Rebate On Trading Fees for LifetimeUnlock exclusive savings on Bitmex with the Bitmex Invite Code “Iy5YJ3”! Use this invite code to get a 20% rebate on trading fees for a lifetime, making your crypto trading journey more cost-effective and profitable. Whether you’re a beginner or a seasoned trader, this code provides significant savings on every trade you make on the Bitmex platform.Bitmex is one of the most reliable and well-established cryptocurrency exchanges, offering a wide range of futures and derivatives trading for major cryptocurrencies like Bitcoin, Ethereum, and more. By using the invite code “Iy5YJ3” when signing up, you’ll instantly start benefiting from the 20% rebate on trading fees for life, giving you a financial edge in the fast-moving crypto market.Here are the key details for the offer:Exchange BitmexBitmex Invite CodeIy5YJ3Trading Fee Rebate20%Rebate DurationLifetimeDate2024-25To activate this rebate, all you need to do is enter the Bitmex Invite Code “Iy5YJ3” during the sign-up process. Once applied, your account will be eligible for reduced trading fees on every transaction, allowing you to maximize your gains with minimal costs. This offer is valid for lifetime rebates, ensuring long-term savings and better returns on all your trades.Don’t miss out on this great opportunity to reduce your trading expenses. Sign up today using the invite code “Iy5YJ3” and enjoy lifetime rebates on Bitmex, one of the top crypto trading platforms. Read More
Toobit Exchange Referral ID “l8xQZs” | Get 30% Off On Trading Fees for Lifetime + Up to $5,000 Bonus
Toobit Exchange Referral ID “l8xQZs” | Get 30% Off On Trading Fees for Lifetime + Up to $5,000 Bonus
Unlock remarkable savings with Toobit Exchange by using the Referral ID “l8xQZs.” This exclusive offer provides you with a 30% discount on trading fees for a lifetime and a sign-up bonus of up to $5,000 for new users.
Toobit Exchange is celebrated for its user-friendly interface and a wide array of trading options, catering to both beginners and experienced traders. By applying this referral ID during registration, you’ll gain access to significant savings and exciting bonuses that enhance your trading experience.
Here are the key benefits of using Toobit Exchange Referral ID “l8xQZs”:
Exchange Toobit Exchange
Referral IDl8xQZsTrading Fee Discount30%BonusUp to $5,000Discount DurationLifetimeDate2024-25
To get started, simply sign up on Toobit Exchange using the Referral ID “l8xQZs.” You will immediately enjoy a 30% reduction on all trading fees, allowing you to maximize your profits with every trade. In addition, you’ll be eligible for a bonus of up to $5,000, giving your trading account a substantial boost right from the beginning.
Whether you’re new to cryptocurrency trading or a seasoned pro, Toobit Exchange offers a perfect combination of competitive fees and generous bonuses. Don’t miss out on this incredible opportunity—register today using the Referral ID “l8xQZs” and experience 30% off on trading fees for life along with up to $5,000 in bonuses!
Toobit Exchange Referral ID “l8xQZs” | Get 30% Off On Trading Fees for Lifetime + Up to $5,000 BonusUnlock remarkable savings with Toobit Exchange by using the Referral ID “l8xQZs.” This exclusive offer provides you with a 30% discount on trading fees for a lifetime and a sign-up bonus of up to $5,000 for new users.Toobit Exchange is celebrated for its user-friendly interface and a wide array of trading options, catering to both beginners and experienced traders. By applying this referral ID during registration, you’ll gain access to significant savings and exciting bonuses that enhance your trading experience.Here are the key benefits of using Toobit Exchange Referral ID “l8xQZs”:Exchange Toobit ExchangeReferral IDl8xQZsTrading Fee Discount30%BonusUp to $5,000Discount DurationLifetimeDate2024-25To get started, simply sign up on Toobit Exchange using the Referral ID “l8xQZs.” You will immediately enjoy a 30% reduction on all trading fees, allowing you to maximize your profits with every trade. In addition, you’ll be eligible for a bonus of up to $5,000, giving your trading account a substantial boost right from the beginning.Whether you’re new to cryptocurrency trading or a seasoned pro, Toobit Exchange offers a perfect combination of competitive fees and generous bonuses. Don’t miss out on this incredible opportunity—register today using the Referral ID “l8xQZs” and experience 30% off on trading fees for life along with up to $5,000 in bonuses! Read More
Ascendex Exchange Invitation Code “U7K2AXLF7” | Get 30% Discount On Trading Fees for Lifetime
Ascendex Exchange Invitation Code “U7K2AXLF7” | Get 30% Discount On Trading Fees for Lifetime
Maximize your trading potential with Ascendex Exchange by using the Invitation Code “U7K2AXLF7.” This exclusive offer provides you with a 30% discount on trading fees for a lifetime, ensuring you keep more of your profits as you trade.
Ascendex is recognized for its user-friendly platform and a wide variety of cryptocurrencies available for trading. By entering this invitation code during registration, you unlock significant savings that enhance your overall trading experience.
Here are the key benefits of using Ascendex Exchange Invitation Code “U7K2AXLF7”:
Exchange Ascendex
Invitation CodeU7K2AXLF7Trading Fee Discount30%Discount DurationLifetimeDate2024-25
To get started, simply sign up on Ascendex Exchange using the Invitation Code “U7K2AXLF7.” You will immediately benefit from a 30% reduction on all trading fees, allowing you to maximize your trading returns. This long-term discount is perfect for active traders looking to minimize costs and increase profitability.
Whether you’re new to the cryptocurrency world or a seasoned trader, Ascendex Exchange offers a competitive edge with its low fees and diverse trading options. Don’t miss out on this fantastic opportunity—register today using the Invitation Code “U7K2AXLF7” to enjoy a 30% discount on trading fees for life!
Ascendex Exchange Invitation Code “U7K2AXLF7” | Get 30% Discount On Trading Fees for LifetimeMaximize your trading potential with Ascendex Exchange by using the Invitation Code “U7K2AXLF7.” This exclusive offer provides you with a 30% discount on trading fees for a lifetime, ensuring you keep more of your profits as you trade.Ascendex is recognized for its user-friendly platform and a wide variety of cryptocurrencies available for trading. By entering this invitation code during registration, you unlock significant savings that enhance your overall trading experience.Here are the key benefits of using Ascendex Exchange Invitation Code “U7K2AXLF7”:Exchange AscendexInvitation CodeU7K2AXLF7Trading Fee Discount30%Discount DurationLifetimeDate2024-25To get started, simply sign up on Ascendex Exchange using the Invitation Code “U7K2AXLF7.” You will immediately benefit from a 30% reduction on all trading fees, allowing you to maximize your trading returns. This long-term discount is perfect for active traders looking to minimize costs and increase profitability.Whether you’re new to the cryptocurrency world or a seasoned trader, Ascendex Exchange offers a competitive edge with its low fees and diverse trading options. Don’t miss out on this fantastic opportunity—register today using the Invitation Code “U7K2AXLF7” to enjoy a 30% discount on trading fees for life! Read More
Excel – Macros
Hello,
I am currently working with 20 other colleagues on different excel files and I am wondering if I can create a macro that export my data to their files and then another macro that import their data to my file.
To be more specific:
On my file I complete columns from A to F, H and I and my colleagues should complete column G, J and K.
I update my file daily with new leads and, when I export, I do not want to overwrite data on their file, just to ad more rows to the existing ones. And when I make the import to my file, I want to return information on red columns from those 20 excel files.
Thank you in advance for help!
Here is an example.
Hello, I am currently working with 20 other colleagues on different excel files and I am wondering if I can create a macro that export my data to their files and then another macro that import their data to my file. To be more specific:On my file I complete columns from A to F, H and I and my colleagues should complete column G, J and K. I update my file daily with new leads and, when I export, I do not want to overwrite data on their file, just to ad more rows to the existing ones. And when I make the import to my file, I want to return information on red columns from those 20 excel files. Thank you in advance for help! Here is an example. Read More
Quickly transform some data for analysis using Copilot in Excel
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. We have transitioned from daily to weekly and we are posting on the Excel blog (https://aka.ms/xlblog).
This week’s example shows how to quickly transform this table:
Into this:
To read how to use Copilot to do this, click here: Quickly transform some data for analysis using Copilot in Excel.
Microsoft Excel Team
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. We have transitioned from daily to weekly and we are posting on the Excel blog (https://aka.ms/xlblog).
This week’s example shows how to quickly transform this table:
Table of partner meetings with columns for Meeting name, Attendee ID, Join Time and Leave Time
Into this:
Table of partner meetings with columns for Meeting name, Attendee Name, Attendee ID, Join Time, Leave Time and meeting duration.
To read how to use Copilot to do this, click here: Quickly transform some data for analysis using Copilot in Excel.
Microsoft Excel Team
Read More
CCEJ: Restorative Dialogue Training!
Led by California Conference for Equality and Justice adult education team, our relationship-centered trainings introduce the core concepts of Restorative Justice as foundational practices in establishing equitable and just cultures.
What is Restorative Justice?
Restorative Justice is centering relationships in all we do, including when harm happens. Community Building Circles are dialogue-based spaces to build empathy, strengthen community, prevent conflict, and prepare for using Restorative Justice as a way to hold people accountable. This work is rooted in a culture shift away from incarceration & carceral thinking, disposability of human beings, three strikes laws/zero-tolerance policies, racist formal and informal policing, and disproportionately punitive disciplinary models.
Training Summary:
We explore the following dialogue skills that affirm positive relationships and provide interventions to shift relationships towards accountability and self-directed actions: Affective Statements, Restorative Questions, Active Listening, and Motivational Interviewing. This training includes skill-building experiences and opportunities for self-reflective work to empower us to respond to challenges with others through a relationship-centered lens.
For more information visit:
https://www.cacej.org/trainings/restorative-dialogue-training-5jehe
Training: Restorative Dialogue
Dates: Wednesday, November 6, 2024, 9:00 AM – 12:00 PM
Location: CCEJ, 3605 Long Beach Blvd, Suite 100, Long Beach 90807
Registration Fee: $110
Registration Link: https://www.surveymonkey.com/r/RestorativeDialogue2024
Led by California Conference for Equality and Justice adult education team, our relationship-centered trainings introduce the core concepts of Restorative Justice as foundational practices in establishing equitable and just cultures. What is Restorative Justice?Restorative Justice is centering relationships in all we do, including when harm happens. Community Building Circles are dialogue-based spaces to build empathy, strengthen community, prevent conflict, and prepare for using Restorative Justice as a way to hold people accountable. This work is rooted in a culture shift away from incarceration & carceral thinking, disposability of human beings, three strikes laws/zero-tolerance policies, racist formal and informal policing, and disproportionately punitive disciplinary models. Training Summary:We explore the following dialogue skills that affirm positive relationships and provide interventions to shift relationships towards accountability and self-directed actions: Affective Statements, Restorative Questions, Active Listening, and Motivational Interviewing. This training includes skill-building experiences and opportunities for self-reflective work to empower us to respond to challenges with others through a relationship-centered lens. For more information visit:https://www.cacej.org/trainings/restorative-dialogue-training-5jehe Training: Restorative DialogueDates: Wednesday, November 6, 2024, 9:00 AM – 12:00 PMLocation: CCEJ, 3605 Long Beach Blvd, Suite 100, Long Beach 90807Registration Fee: $110Registration Link: https://www.surveymonkey.com/r/RestorativeDialogue2024 Read More
Windows Cumulative update KB5044030 and KB5044284 for 24H2 system not installing/downloading
I have recently factory reset my computer, and now, I have the 24H2 system and according to support I had to have opted in to that. When i checked my insider status it said I was not an insider and now my updates are not working. I was directed here to ask for help. Any help is appreciated.
I have recently factory reset my computer, and now, I have the 24H2 system and according to support I had to have opted in to that. When i checked my insider status it said I was not an insider and now my updates are not working. I was directed here to ask for help. Any help is appreciated. Read More
Azure Tag policy require specific tag with specific values
Hello:
I am trying to create policy that would require a specific tag with only certain values (for example, tag deployment that can only be prod/non-prod) and having trouble to do it.
Can someone please help?
Looks like I can do a policy where I can choose during assignment (in parameters) what exact value I want to see (see json below), but I want to deny anything (deployment, adjustments and etc.) if the tag value not in my list…
{
“mode”: “Indexed”,
“policyRule”: {
“if”: {
“not”: {
“field”: “[concat(‘tags[‘, parameters(‘tagName’), ‘]’)]”,
“equals”: “[parameters(‘tagValue’)]”
}
},
“then”: {
“effect”: “deny”
}
},
“parameters”: {
“tagName”: {
“type”: “String”,
“metadata”: {
“displayName”: “Tag Name1”,
“description”: “Name of the tag, such as ‘environment'”
}
},
“tagValue”: {
“type”: “String”,
“metadata”: {
“displayName”: “Tag Value1”,
“description”: “Value of the tag, such as ‘production'”
},
“allowedValues”: [
“prod”,
“non-prod”
]
}
}
}
Thank you!
Hello: I am trying to create policy that would require a specific tag with only certain values (for example, tag deployment that can only be prod/non-prod) and having trouble to do it. Can someone please help? Looks like I can do a policy where I can choose during assignment (in parameters) what exact value I want to see (see json below), but I want to deny anything (deployment, adjustments and etc.) if the tag value not in my list… {“mode”: “Indexed”,”policyRule”: {“if”: {“not”: {“field”: “[concat(‘tags[‘, parameters(‘tagName’), ‘]’)]”,”equals”: “[parameters(‘tagValue’)]”}},”then”: {“effect”: “deny”}},”parameters”: {“tagName”: {“type”: “String”,”metadata”: {“displayName”: “Tag Name1″,”description”: “Name of the tag, such as ‘environment'”}},”tagValue”: {“type”: “String”,”metadata”: {“displayName”: “Tag Value1″,”description”: “Value of the tag, such as ‘production'”},”allowedValues”: [“prod”,”non-prod”]}}} Thank you! Read More
Export Images from Jira to csv/excel
Dear experts ,
Greetings!
I have a query on jira export to csv, when I export jira Tickets to csv , using export to csv as below:-
The Tickets are exported properly in csv/excel, but the images used in those Tickets(description, analysis) are shown as below:-
I did some Google on this , it says we need to create some kind of scripts for this..
Could you please guide me on how to achieve this or if any such script already existing?
Thanks in Advance,
Br,
Anupam
Dear experts , Greetings! I have a query on jira export to csv, when I export jira Tickets to csv , using export to csv as below:-The Tickets are exported properly in csv/excel, but the images used in those Tickets(description, analysis) are shown as below:- I did some Google on this , it says we need to create some kind of scripts for this..Could you please guide me on how to achieve this or if any such script already existing? Thanks in Advance,Br,Anupam Read More
Excel Date Formula for On-time reporting
Hi,
I’m wanting to create a formula for creating an automatic statement as to whether a report has been submitted on time or not. The report due date doesn’t change, it’s always due on 28 October for the current year. I’m guessing there will be a lot of IF statements as I’m wanting it to say:
No – Submitted * day(s) late {Based on how many days it was submitted after 28 October}
Yes – Submitted on due date
Yes – Submitted * day(s) early {Based on how many days it was submitted before 28 October}
Mock example below
Hi,I’m wanting to create a formula for creating an automatic statement as to whether a report has been submitted on time or not. The report due date doesn’t change, it’s always due on 28 October for the current year. I’m guessing there will be a lot of IF statements as I’m wanting it to say:No – Submitted * day(s) late {Based on how many days it was submitted after 28 October}Yes – Submitted on due dateYes – Submitted * day(s) early {Based on how many days it was submitted before 28 October}Mock example below Read More
Uploading Test Cases as a Work Item type in DevOps
Our team is experiencing issues uploading work items of type “Test Case.” The error received is “Forbidden Work Item Type.” Please see the attached screenshot for reference.
All other work items are being imported correctly, with the exception of Test Cases. The file containing the same test cases had worked previously. I have also attached a sample file for your review.
We were able to upload test cases without any issues up to Sept 25th and now get the error.
Thanks,
Chris
Our team is experiencing issues uploading work items of type “Test Case.” The error received is “Forbidden Work Item Type.” Please see the attached screenshot for reference. All other work items are being imported correctly, with the exception of Test Cases. The file containing the same test cases had worked previously. I have also attached a sample file for your review.We were able to upload test cases without any issues up to Sept 25th and now get the error. Thanks, Chris Read More
calculate sum based on the multiple selections from a reference table
I have a reference table, “Office” and like to get the total personnel based on the selection of offices in the “Allocations” table where I have the data validation configured to select multiple offices.
For example, if I selected “Austin” and “Tampa” in the cell of “Allocation” column, I will get the total personnel of 55 from the Office table. Please advise how to do this. Thanks in advance!!
Office# of PersonnelAustin15Dallas21Las Vegas16Tampa40San Jose28Total120
AllocationsTotal PersonnelAustin, Dallas, Las Vegas52Austin, Tampa55
I have a reference table, “Office” and like to get the total personnel based on the selection of offices in the “Allocations” table where I have the data validation configured to select multiple offices. For example, if I selected “Austin” and “Tampa” in the cell of “Allocation” column, I will get the total personnel of 55 from the Office table. Please advise how to do this. Thanks in advance!! Office# of PersonnelAustin15Dallas21Las Vegas16Tampa40San Jose28Total120 AllocationsTotal PersonnelAustin, Dallas, Las Vegas52Austin, Tampa55 Read More
New GitHub course coming soon: AZ-2006: Automate Azure Load Testing by using GitHub
Course Name: AZ-2006: Automate Azure Load Testing by using GitHub
Release Date: November 15th, 2024 (Release dates are subject to change)
Duration: 1-Day ILT
Solution Area: Azure Infrastructure
Credential: Applied Skills Assessment
Course Description:
This course is designed for students who are planning to take the Automate Azure Load Testing by using GitHub Actions assessment. In this course, the student will learn how to create workflows on GitHub, create load tests in Azure, and use GitHub Actions for Azure to initiate load tests on deployments.
Audience:
Students should be familiar with creating resources in Azure, configuring Azure App Service and Azure Load Testing, and authoring GitHub Actions workflows. Candidates should have experience using Git and Visual Studio Code.
Please note: This is not a support forum. Only comments related to this specific blog post content are permitted and responded to.
For ILT Courseware Support, please visit: aka.ms/ILTSupport
If you have ILT questions not related to this blog post, please reach out to your program for support.
Microsoft Tech Community – Latest Blogs –Read More
Coming soon: MS-4002: Prepare security and compliance to support Microsoft 365 Copilot
Course Name: MS-4002: Prepare security and compliance to support Microsoft 365 Copilot
Release Date: November 8th, 2024 (Release dates are subject to change)
Duration: 1-Day ILT
Solution Area: Modern Work
Credential: Applied Skills Assessment
Course Description:
This course examines the key Microsoft 365 security and compliance features that administrators must prepare for to successfully implement Microsoft 365 Copilot.
Audience:
Please note: This is not a support forum. Only comments related to this specific blog post content are permitted and responded to.
For ILT Courseware Support, please visit: aka.ms/ILTSupport
If you have ILT questions not related to this blog post, please reach out to your program for support.
Microsoft Tech Community – Latest Blogs –Read More