Month: August 2024
SQL Server Migration Assistant: How to customize SQL for an object in MSSQL after 1st conversion
So in the picture below, I’ve run “Convert Schema” for the first time. For the tEntity_d object, it gave an appropriate conversion error (“object not found”)
After that, in the bottom right MSSQL destination window (ambigously titled “SQL”) I fixed the bad code (see the comment “This incompatible statement has been deleted by me”). But there’s no option to save the fixed code in the to the MSSQL destination:
If I right click on tEntity_d in the bottom left “SQL Server Metadata Explorer” window, I see a “Synchronize with Database” option. Which database? The destination? When I try and run “Synchronize with Database” it asks if I want to save changes to “MsSQL SQL Editor” (the bottom right “SQL” window?). I answered “yes”.
Then I get a “Database” (destination?) “Not Found” error. What does this mean?
Thanks in advance
Ben
So in the picture below, I’ve run “Convert Schema” for the first time. For the tEntity_d object, it gave an appropriate conversion error (“object not found”) After that, in the bottom right MSSQL destination window (ambigously titled “SQL”) I fixed the bad code (see the comment “This incompatible statement has been deleted by me”). But there’s no option to save the fixed code in the to the MSSQL destination: If I right click on tEntity_d in the bottom left “SQL Server Metadata Explorer” window, I see a “Synchronize with Database” option. Which database? The destination? When I try and run “Synchronize with Database” it asks if I want to save changes to “MsSQL SQL Editor” (the bottom right “SQL” window?). I answered “yes”. Then I get a “Database” (destination?) “Not Found” error. What does this mean? Thanks in advanceBen Read More
2019 Server Cannot Connect to Network Due to Share IP address changed.
One of my 2019 servers which has not been used for some time no longer connects to the local network as the Share IP address has become different than the Server Ethernet address for the local network. As a result the server is no longer reachable. While he network is a local 192.168.. the Server Share IP address has become 169,254.. My other working servers have the Share IP address the same as the local network 192.168.. and worked fine. I did try running updates but that did not resolve the issue.
One of my 2019 servers which has not been used for some time no longer connects to the local network as the Share IP address has become different than the Server Ethernet address for the local network. As a result the server is no longer reachable. While he network is a local 192.168.. the Server Share IP address has become 169,254.. My other working servers have the Share IP address the same as the local network 192.168.. and worked fine. I did try running updates but that did not resolve the issue. Read More
Outlook access issue
Hi all,
I have a Micorosft 365 account with “onmicrosoft.com” domain. I am able to access the microsoft 365 account but not able to access the outlook emails for this account. I am getting the below error:
anyone experienced the same issue before?
Thanks
Hi all, I have a Micorosft 365 account with “onmicrosoft.com” domain. I am able to access the microsoft 365 account but not able to access the outlook emails for this account. I am getting the below error:anyone experienced the same issue before?Thanks Read More
Working with date columns using Excel Copilot
Greetings, This is the third in a series of posts that provides examples of what is possible with Copilot in Excel. Today I will continue with the list of employees that now contains a column for the hire date.
Table with these columns: Name Address City State. First two rows of data are: Claude Paulet 123 Main Avenue Bellevue Washington 8/24/2022 Jatindra Sanyal 1122 First Place Ln N Corona California 8/14/2023
I would like to add columns for which quarter and year the employees were hired to this table. To accomplish this, I’ll start by clicking on the copilot button on the right side of the Home tab, showing the copilot pane and type the prompt:
add columns for the quarter and year of the hire date
Excel Copilot looks at the content in the table and then suggests inserting 2 calculated columns, one for the hire quarter and one for the hire year.
Looking at A1:E17, here are 2 formula columns to review and insert in Columns F and G: 1. Hire Quarter Determines the quarter in which each employee was hired by converting the hire date into a corresponding quarter (Q1, Q2, Q3, or Q4) based on the month of the year. =CHOOSE(CEILING(MONTH([@[Hire Date]])/3,1),”Q1″,”Q2″,”Q3″,”Q4″) Show explanation 2. Hire Year Extracts the year from each hire date, providing a quick way to see when each person was hired. =YEAR([@[Hire Date]])
Hovering the mouse cursor over the “Insert columns” button in the copilot pane shows a preview of what inserting the new column formulas will look like. From the preview, it looks like it is doing what I wanted.
Picture of the list of employees with a preview of the new hire quarter and hire year columns that would be added.
Clicking on the Insert Columns button will accept the proposed change, inserting 2 new calculated column formulas that use the hire date column to determine the quarter and year of each hire. This is exactly the result I was looking for!
Picture showing the Excel workbook with copilot pane open. Includes the employee table with hire quarter and hire year added.
Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
Greetings, This is the third in a series of posts that provides examples of what is possible with Copilot in Excel. Today I will continue with the list of employees that now contains a column for the hire date.
Table with these columns: Name Address City State. First two rows of data are: Claude Paulet 123 Main Avenue Bellevue Washington 8/24/2022 Jatindra Sanyal 1122 First Place Ln N Corona California 8/14/2023
I would like to add columns for which quarter and year the employees were hired to this table. To accomplish this, I’ll start by clicking on the copilot button on the right side of the Home tab, showing the copilot pane and type the prompt:
add columns for the quarter and year of the hire date
Excel Copilot looks at the content in the table and then suggests inserting 2 calculated columns, one for the hire quarter and one for the hire year.
Looking at A1:E17, here are 2 formula columns to review and insert in Columns F and G: 1. Hire Quarter Determines the quarter in which each employee was hired by converting the hire date into a corresponding quarter (Q1, Q2, Q3, or Q4) based on the month of the year. =CHOOSE(CEILING(MONTH([@[Hire Date]])/3,1),”Q1″,”Q2″,”Q3″,”Q4″) Show explanation 2. Hire Year Extracts the year from each hire date, providing a quick way to see when each person was hired. =YEAR([@[Hire Date]])
Hovering the mouse cursor over the “Insert columns” button in the copilot pane shows a preview of what inserting the new column formulas will look like. From the preview, it looks like it is doing what I wanted.
Picture of the list of employees with a preview of the new hire quarter and hire year columns that would be added.
Clicking on the Insert Columns button will accept the proposed change, inserting 2 new calculated column formulas that use the hire date column to determine the quarter and year of each hire. This is exactly the result I was looking for!
Picture showing the Excel workbook with copilot pane open. Includes the employee table with hire quarter and hire year added.
Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
Read More
Prevent first column from sticking
With the new (horrible) SharePoint List, how do you prevent the first column from sticking? This default setting (in addition to the List itself) is disruptive to our workflow.
If anyone knows how to revert to the earlier SharePoint List that’s actually usable and productive, PLEASE LET ME KNOW.
With the new (horrible) SharePoint List, how do you prevent the first column from sticking? This default setting (in addition to the List itself) is disruptive to our workflow. If anyone knows how to revert to the earlier SharePoint List that’s actually usable and productive, PLEASE LET ME KNOW. Read More
Is a matrix with a condition number of 1e20 definitely more ill-conditioned than a matrix with a condition number of 1e19？
I am working with some ill-conditioned matrices, trying to find the relationship between the matrix’s ill-conditioning and the results. However, I have noticed that the condition numbers of some matrices are extremely large, with the smallest singular values even smaller than eps. Does this mean that the condition numbers I got might be inaccurate? Or is a matrix with a condition number of 1e20 definitely more ill-conditioned than a matrix with a condition number of 1e19？I am working with some ill-conditioned matrices, trying to find the relationship between the matrix’s ill-conditioning and the results. However, I have noticed that the condition numbers of some matrices are extremely large, with the smallest singular values even smaller than eps. Does this mean that the condition numbers I got might be inaccurate? Or is a matrix with a condition number of 1e20 definitely more ill-conditioned than a matrix with a condition number of 1e19？ I am working with some ill-conditioned matrices, trying to find the relationship between the matrix’s ill-conditioning and the results. However, I have noticed that the condition numbers of some matrices are extremely large, with the smallest singular values even smaller than eps. Does this mean that the condition numbers I got might be inaccurate? Or is a matrix with a condition number of 1e20 definitely more ill-conditioned than a matrix with a condition number of 1e19？ matrix MATLAB Answers — New Questions
How to access state-space matrices of a power-system simlink model?
Hello everyone,
I’m currently working on a project where I need to access the state-space matrices (A, B, C, D) of a synchronous machine model in Simulink. I’ve built a model of a synchronous machine connected to an RLC branch.
While I can successfully simulate the model and observe the output current, I need to extract the A, B, C, D matrices that define the synchronous machine’s internal dynamics.
I’ve explored the `powergui` block and its functionalities, but I haven’t been able to pinpoint the exact steps to obtain these matrices. Could anyone please guide me on how to access and export the A, B, C, D matrices of the synchronous machine model in Simulink?
Any help or suggestions would be greatly appreciated. Thank you!Hello everyone,
I’m currently working on a project where I need to access the state-space matrices (A, B, C, D) of a synchronous machine model in Simulink. I’ve built a model of a synchronous machine connected to an RLC branch.
While I can successfully simulate the model and observe the output current, I need to extract the A, B, C, D matrices that define the synchronous machine’s internal dynamics.
I’ve explored the `powergui` block and its functionalities, but I haven’t been able to pinpoint the exact steps to obtain these matrices. Could anyone please guide me on how to access and export the A, B, C, D matrices of the synchronous machine model in Simulink?
Any help or suggestions would be greatly appreciated. Thank you! Hello everyone,
I’m currently working on a project where I need to access the state-space matrices (A, B, C, D) of a synchronous machine model in Simulink. I’ve built a model of a synchronous machine connected to an RLC branch.
While I can successfully simulate the model and observe the output current, I need to extract the A, B, C, D matrices that define the synchronous machine’s internal dynamics.
I’ve explored the `powergui` block and its functionalities, but I haven’t been able to pinpoint the exact steps to obtain these matrices. Could anyone please guide me on how to access and export the A, B, C, D matrices of the synchronous machine model in Simulink?
Any help or suggestions would be greatly appreciated. Thank you! simpowersystems MATLAB Answers — New Questions
Power Automate create tasks in Planner Premium plans
Hello,
I noticed that Planner Premium plans still have a projectId rather than a groupId. Using the planner connector in PowerAutomate I am able to find all tasks (tasks of premium plans and non premium plans), however, when I want to create a new task I can only find the non premium plans and it seems to be not possible to create a task in a premium plan using the planner connector in PowerAutomate.
Is there a reliable workaround I can use (e.g. using the graphAPI)?
Best regards
Fabian
Hello,I noticed that Planner Premium plans still have a projectId rather than a groupId. Using the planner connector in PowerAutomate I am able to find all tasks (tasks of premium plans and non premium plans), however, when I want to create a new task I can only find the non premium plans and it seems to be not possible to create a task in a premium plan using the planner connector in PowerAutomate. Is there a reliable workaround I can use (e.g. using the graphAPI)? Best regardsFabian Read More
Outlook calendar availability not reflected in Bookings
When staff enter an appointment in manually to the outlook calendar associated with Bookings, the option to book that time still shows as available for folks booking online through Bookings, resulting in double bookings. This issue was not happening before, and the toggle to enable this connection is on, so I am not sure what the issue is?
When staff enter an appointment in manually to the outlook calendar associated with Bookings, the option to book that time still shows as available for folks booking online through Bookings, resulting in double bookings. This issue was not happening before, and the toggle to enable this connection is on, so I am not sure what the issue is? Read More
MS Forms Field that is Read Only or Has Default Text
Anyone have suggestions on how to have a read only field within an MS Form or have Default text in a text field? I am prompting for input however in many cases, it is going to be the same response so was hoping to either make it defaulted to specific text or just make it read only but displayed on the form.
Anyone have suggestions on how to have a read only field within an MS Form or have Default text in a text field? I am prompting for input however in many cases, it is going to be the same response so was hoping to either make it defaulted to specific text or just make it read only but displayed on the form. Read More
How to get excel to sort 2-number dates correctly
I’m working with a spreadsheet with over 28,000 rows of video/audio tape IDs that typically take this format: ID tag / Date (2 numbers) / Number. So, the 3rd Corporate tape from 1998 would be CORP98-0003. I want to sort this spreadsheet by ID tag first then numerically by date. The problem is that Excel automatically sorts the year 2000 (00) before the year 1999 (99) instead of doing it by date. This makes it take SOOO long to manually sort individual groups of NEW tapes into the 28,000-row spreadsheet. It would so much easier and faster if I could get Excel to automatically sort tapes my way. Just to be clear, I would like it to sort tapes this way:
CORP99-0099
CORP99-0100
CORP99-0101
CORP00-0001
CORP00-0002
CORP00-0003
etc.
How can I do that? I’m still fairly new to Excel. Thanks!
I’m working with a spreadsheet with over 28,000 rows of video/audio tape IDs that typically take this format: ID tag / Date (2 numbers) / Number. So, the 3rd Corporate tape from 1998 would be CORP98-0003. I want to sort this spreadsheet by ID tag first then numerically by date. The problem is that Excel automatically sorts the year 2000 (00) before the year 1999 (99) instead of doing it by date. This makes it take SOOO long to manually sort individual groups of NEW tapes into the 28,000-row spreadsheet. It would so much easier and faster if I could get Excel to automatically sort tapes my way. Just to be clear, I would like it to sort tapes this way:CORP99-0099CORP99-0100CORP99-0101CORP00-0001CORP00-0002CORP00-0003etc. How can I do that? I’m still fairly new to Excel. Thanks! Read More
Learn about Derek Coleman & Associates’ transactable partner solution in Azure Marketplace
Microsoft partners like Derek Coleman & Associates deliver transact-capable offers, which allow you to purchase directly from Azure Marketplace. Learn about this offer below:
Azure VMs on Windows Server Datacenter: Whether you’re a small business or an enterprise, Azure Virtual Machines on Windows Server Datacenter ensure scalability, security, and performance for your workloads. Consult with Derek Colemand & Associates for tailored, reliable, and robust solutions.
Microsoft Tech Community – Latest Blogs –Read More
How to generate vector with non-linear spacing?
Hello,
I am attempting to generate an array with non-linear spacing between the elements but struggling to figure out a way to impliment this. I need an array x of points spaced from a real, negative value a to a real, positive value b. Ideally the spacing should follow a Gaussian distribution such that many points are clustered about x=0 in the vicinity of some finite width d. Conversely the spacing should be large at the boundaries. More generally it doesn’t have to be Gaussian but some guidance on a scheme where I can specify a length d<<|b-a| across which many points should be distributed would be really appreciated.
I tried to work out an algorithm of sorts from pen and paper but it didn’t really work and resulted in something that did not appear to be immediately solveable.
ThanksHello,
I am attempting to generate an array with non-linear spacing between the elements but struggling to figure out a way to impliment this. I need an array x of points spaced from a real, negative value a to a real, positive value b. Ideally the spacing should follow a Gaussian distribution such that many points are clustered about x=0 in the vicinity of some finite width d. Conversely the spacing should be large at the boundaries. More generally it doesn’t have to be Gaussian but some guidance on a scheme where I can specify a length d<<|b-a| across which many points should be distributed would be really appreciated.
I tried to work out an algorithm of sorts from pen and paper but it didn’t really work and resulted in something that did not appear to be immediately solveable.
Thanks Hello,
I am attempting to generate an array with non-linear spacing between the elements but struggling to figure out a way to impliment this. I need an array x of points spaced from a real, negative value a to a real, positive value b. Ideally the spacing should follow a Gaussian distribution such that many points are clustered about x=0 in the vicinity of some finite width d. Conversely the spacing should be large at the boundaries. More generally it doesn’t have to be Gaussian but some guidance on a scheme where I can specify a length d<<|b-a| across which many points should be distributed would be really appreciated.
I tried to work out an algorithm of sorts from pen and paper but it didn’t really work and resulted in something that did not appear to be immediately solveable.
Thanks array, vector MATLAB Answers — New Questions
Delete a Task then Error: “Only members of the Microsoft 365 group are allowed to delete tasks.”
Hello, I want to delete a task and get the following error message:
Only members of the Microsoft 365 group are allowed to delete tasks.Technical details Correlation
ID: c4794c1f-eade-4dc0-bd40-b8e37b93d1cf
Timestamp: 2024-08-14T11:29:39.521Z
We don’t have a Microsoft 365 group Does anyone have an idea?
Greetings from Germany
Hello, I want to delete a task and get the following error message:Only members of the Microsoft 365 group are allowed to delete tasks.Technical details CorrelationID: c4794c1f-eade-4dc0-bd40-b8e37b93d1cfTimestamp: 2024-08-14T11:29:39.521ZWe don’t have a Microsoft 365 group Does anyone have an idea?Greetings from Germany Read More
The Expression is not valid, if the uri contain single quote inside the Uri field
I have a “Send an http request to SharePoint”, where i am passing a file name, as follow:-
now incase the file name contain a single quote such as :-
d’Emploi-Organization Grant.docx
i will get this error:-
{
“status”: 400,
“message”: “{“odata.error”:{“code”:”-1, Microsoft.SharePoint.Client.InvalidClientQueryException”,”message”:{“lang”:”en-US”,”value”:”The expression \”LeafName eq ‘d’Emploi-Organization Grant.docx’\” is not valid.”}}}rnclientRequestId: 55063edc-b342-4deb-98fe-88daf96c5dd3rnserviceRequestId: b9cc45a1-d019-6000-4a0f-328de72410d4″,
“source”: “*****/_api/web/RecycleBin?$filter=LeafName%20eq%20’d’Emploi%20-Organization%20Grant.docx’&$select=Id”,
“errors”: []
}
now i try to surround the file name with `encodeUriComponent` but did not fix the issue..
any advice?
Thanks
I have a “Send an http request to SharePoint”, where i am passing a file name, as follow:- now incase the file name contain a single quote such as :- d’Emploi-Organization Grant.docx i will get this error:- {
“status”: 400,
“message”: “{“odata.error”:{“code”:”-1, Microsoft.SharePoint.Client.InvalidClientQueryException”,”message”:{“lang”:”en-US”,”value”:”The expression \”LeafName eq ‘d’Emploi-Organization Grant.docx’\” is not valid.”}}}rnclientRequestId: 55063edc-b342-4deb-98fe-88daf96c5dd3rnserviceRequestId: b9cc45a1-d019-6000-4a0f-328de72410d4″,
“source”: “*****/_api/web/RecycleBin?$filter=LeafName%20eq%20’d’Emploi%20-Organization%20Grant.docx’&$select=Id”,
“errors”: []
} now i try to surround the file name with `encodeUriComponent` but did not fix the issue..any advice?Thanks Read More
ADX Web UI updates – July 2023
Welcome to the July 2024 update. We are excited to announce new features and improvements in ADX web UI.
Continue reading to learn more about:
Ad-hoc visual data exploration
Dashboards real time refresh rate
Enhanced data interaction for dashboard tiles
Resize and move dashboard tiles using keyboard only
Introducing ad-hoc visual Data Exploration feature
Our new “Data Exploration” feature allows you to dive deeper into the data on any dashboard, extending your exploration beyond the displayed tiles to uncover new insights. This user-friendly, form-like interface lets you add filters, create aggregations, and switch visualization types without writing queries. Now, you can explore data ad-hoc, leveraging existing tiles to start your journey and expand your data view.
Read more:
Announcement: Ad-Hoc Visual Data Exploration Feature – Microsoft Community Hub
Documentation: Explore data in dashboard tiles (preview) – Azure Data Explorer | Microsoft Learn
Dashboards real time refresh rate
We are excited to announce an enhancement to our dashboard auto refresh feature, now supporting continuous and 10 seconds refresh rates, in addition to the existing options.
This upgrade, addressing a popular customer request, allows both editors and viewers to set near real-time and real-time data updates, ensuring your dashboards display the most current information with minimal delay. Experience faster data refresh and make more timely decisions with our improved dashboard capabilities.
As the dashboard author you can enable the Auto refresh setting and set a minimum time interval, to prevent users from setting an auto refresh interval smaller than the provided value.
Note that the Continuous option should be used with caution. The data is refreshed every second or after the previous refresh completes if it takes more than 1 second.
Enhanced Data Interaction for Dashboard Tiles
We are excited to announce new capabilities that enhance your interaction with data presented visually in dashboard tiles, particularly when multiple data series are involved.
You can interact with the data by selecting specific items from the legend using the mouse, using Ctrl to add or remove selections, or holding Shift to select a range.
The Search button helps you quickly filter items, while the Invert button allows you to reverse your selections.
Navigate through your selections with ease using the Up and Down arrows to refine your data view.
Note that users with edit rights on a dashboard, can customize the legend location in their tiles, improving readability and data interpretation.
Resize dashboard tiles using keyboard only
We are excited to introduce a new accessibility feature that allows users to resize dashboard tiles using only the keyboard.
By pressing the Tab key, you can focus on a tile, and then use the arrow keys to move it.
To resize, hold the Shift key and use the arrow keys: right to increase width, left to decrease width, down to increase height, and up to decrease height.
This functionality mirrors the ease of moving and resizing with a mouse, enhancing the accessibility and usability of ADX web UI.
Azure Data Explorer Web UI team is looking forward for your feedback in KustoWebExpFeedback@service.microsoft.com
You’re also welcome to add more ideas and vote for them here – https://aka.ms/adx.ideas
Read more:
ADX Web May updates – ADX Web updates – May 2024 – Microsoft Community Hub
Microsoft Tech Community – Latest Blogs –Read More
Link between ansys workbench and matlab
How can i link between ansys workbench and matlab ?How can i link between ansys workbench and matlab ? How can i link between ansys workbench and matlab ? ansys workbench, matlab MATLAB Answers — New Questions
selstruc(): How to avoid hitting “Return” in command window?
I’m building a little App (.mlapp) for System Identification based on this example: https://www.mathworks.com/help/ident/gs/identify-linear-models-using-the-command-line.html
I’m using selstruc(arxstruc(…)) to estimate model parameter but after selection, it’s not sufficient to close with the "Close" button, but I have to switch to main Matlab command window and hit return, as mentioned in the dialog.
Is there any way to avoid this and continue directly after pressing "Close"?I’m building a little App (.mlapp) for System Identification based on this example: https://www.mathworks.com/help/ident/gs/identify-linear-models-using-the-command-line.html
I’m using selstruc(arxstruc(…)) to estimate model parameter but after selection, it’s not sufficient to close with the "Close" button, but I have to switch to main Matlab command window and hit return, as mentioned in the dialog.
Is there any way to avoid this and continue directly after pressing "Close"? I’m building a little App (.mlapp) for System Identification based on this example: https://www.mathworks.com/help/ident/gs/identify-linear-models-using-the-command-line.html
I’m using selstruc(arxstruc(…)) to estimate model parameter but after selection, it’s not sufficient to close with the "Close" button, but I have to switch to main Matlab command window and hit return, as mentioned in the dialog.
Is there any way to avoid this and continue directly after pressing "Close"? system identification, selstruc MATLAB Answers — New Questions
how can I download my licenses
how can I download my licenseshow can I download my licenses how can I download my licenses download licenses MATLAB Answers — New Questions
How to set up rooms and staff for booking page
I’m trying to create a page for booking. Where clients can book the appointment by themselves. I have to conditions, availability of room and availability of Advisor. if both are available then they can book the appointments how can I do this?
I’m trying to create a page for booking. Where clients can book the appointment by themselves. I have to conditions, availability of room and availability of Advisor. if both are available then they can book the appointments how can I do this? Read More
