Category: Microsoft
Category Archives: Microsoft
GitHub Copilot and SSMA: Strap a GenAI conversion booster to your Oracle to SQL Migrations
Overview
In this blog post we will see demonstration and detailed walk through of how Generative AI capabilities of GitHub Copilot can work together with SQL Server Migration Assistant (SSMA) for Oracle and accelerate code conversion from PL/SQL to T-SQL and simplify Oracle migration journey to Azure SQL. Before we delve into how GitHub Copilot can accelerate your code conversion journey, lets get a brief overview of GitHub Copilot, SSMA for Oracle, Database migrations and the criticality of code conversion in the migration process.
What is GitHub Copilot?
GitHub Copilot is an AI coding assistant that helps developers write code faster with less effort, allowing developers to focus on problem solving and collaboration. It improves developer productivity by doing completions, answering coding questions, fix issues, generate unit test cases, jumpstarting your project and much more. GitHub Copilot also has Language Translation ability that can translate code from one Programming language to another, for example: Python to JavaScript or HTML to Markdown, PL/SQL to T-SQL etc. In this demo we will see how GitHub Copilot Language translation capability can simplify your Oracle to SQL Server database migration by automatically converting PL/SQL into T-SQL.
GitHub Copilot is available as an extension in IDEs, GitHub Mobile as a chat interface, on command line as GitHub CLI and more. In this demo we are going to use Visual Studio Code extension of GitHub Copilot.
What is SQL Server Migration Assistant (SSMA) for Oracle
Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a desktop tool to automate migration from Oracle database(s) to SQL Server, Azure SQL Database, Azure SQL Database Managed Instance and Azure SQL Data Warehouse. SSMA for Oracle converts Oracle database objects and loads those objects into SQL Server or Azure SQL, and then migrates data. For more information on how to use SSMA for Oracle, please refer to SQL Server Migration Assistant for Oracle.
Database Migrations overview
Database migration is a process of moving data from one or more source platforms to the desired target platforms. Data migration can happen between databases of the same database management system (DBMS) from the same provider or between databases from different database management system (DBMS) providers. For example, Migration of SQL Servers from on-premises infrastructure or non-Azure cloud platforms to Azure SQL (which includes following three products: Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM) is called Homogenous Migrations and Migration of non-SQL server databases like Oracle, DB2, Sybase etc. to Microsoft SQL Server or Azure SQL is called Heterogenous migrations. Both homogenous and heterogenous are a multi-phase journey with the following phases:
Discovery: Users must first Discover their entire source database estate either in on-prem or in other clouds and determine which of these databases need to be migrated.
Total Cost of Ownership (TCO) comparison analysis between source and target platforms to quantify the potential cost savings by migrating the databases.
Assess the source databases to understand the workload patterns and determine the right configuration of the target database and provision the target.
Convert the code and other source database objects to make them target compatible.
Migrate the data from source to target databases either.
Conversion using SQL Server Migration Assistant for Oracle
SQL Server Migration Assistant for Oracle provides extensive conversion rule set engine that converts most of your Oracle objects into PL/SQL code into SQL Server compatible objects and T-SQL with 100% accuracy. Additionally, SSMA provides multiple reusable customization options for mapping datatypes and extending inbuilt rule engine that help you accelerate the overall code conversion process. High-level steps for conversion in SSMA are:
Mapping Oracle and SQL Server data types: SSMA for Oracle offers a default set of type mappings, which meets common conversion requirements in most of the cases. This data type mapping is inherited by default at project level for all the underlying object categories and object types. Users can customize them as needed at object category level and create exceptions
Assessing Oracle Schemas for conversion: Before loading objects and migrate data to SQL Server, you should determine how complex the migration will be and how much time the migration will take. SSMA for Oracle creates an assessment report that shows the percentage of objects that will be successfully converted, and it also lets you view the specific issues that cause conversion failures. Additionally, SSMA also tells you the amount of manual effort required in hours to convert the objects that could not be automatically converted.
Converting Oracle Schemas into SQL Server Schemas: Converting database objects takes the object definitions from Oracle, converts them to similar SQL Server objects, and then loads this information into the SSMA metadata. It does not load the information into the instance of SQL Server. You can then view the objects and their properties by using the SQL Server Metadata Explorer. During the conversion, SSMA prints output messages to the Output pane and error messages to the Error List pane. Use the output and error information to determine whether you have to modify your Oracle databases or your conversion process to obtain the desired conversion results.
Loading converted database objects into SQL Server: To load the converted database objects into SQL Server without modification, you can have SSMA directly create or recreate the database objects. To modify the Transact-SQL that is used to create objects for more control over object creation, use SSMA to create scripts. You can then modify those scripts to create each object individually, and even use SQL Server Agent to schedule creating those objects. To secure the converted database objects in SQL Server, you can grant and deny permissions on those objects. It is recommended to set the security permissions before performing data migration.
More details about the Oracle to SQL Server migration and the conversion process can be found in Migrate Oracle to SQL Server (OracleToSQL)
GitHub Copilot, a great companion to SSMA in code conversion
SSMA for Oracle provides comprehensive conversion rule engine that converts majority of the datatypes and objects into SQL Server compatible type with 100 % accuracy. Objects that could not be converted automatically by SSMA, need to be converted manually and this can take multiple hours of manual effort. Users can leverage the full power of Generative AI capabilities available in GitHub Copilot to automate the conversion of Oracle database objects that could not be converted by SSMA for Oracle. GitHub Copilot is available as a Visual Studio extension, which facilitates conversion of large and complex Oracle procedures and functions to T-SQL procedures and functions with few clicks. Here is a step-by-step guide on how to leverage GitHub Copilot VS Code extension to automate the conversion:
Create and view the conversion assessment report generated by SSMA to know the list of all objects that could not be automatically converted by SSMA into SQL Server compatible objects. Here is a screenshot that shows how the assessment report would look like capturing details on number of objects and actual objects that could not be converted (Pie chart on the left) and the amount of manual effort required to convert these objects (Pie chart on the right):
Select an object (ex: a PL/SQL procedure or function) that could not be successfully converted by SSMA. As shown the screenshot below, we have selected get_employee_info () procedure which has ref cursor as a return type which is not supported directly in T-SQL
As a next step, copy the query, open GitHub Copilot extension in VSCode and paste it into a new file which is saved with .sql extension. In this case, I saved the file with the PL/SQL code as ora2sql.sql.
To setup GitHub Copilot in Visual Studio Code follow the instructions in: GitHub Copilot setup in VSCode.
After pasting the PL/SQL procedure in VS Code, hit Ctrl+I to invoke the GitHub Copilot inline chat that lets you ask questions or give specific commands in Natural Language. In the chat interface please type convert PL/SQL to T-SQL and hit enter.
In few seconds the entire PL/SQL code is rewritten to convert the return cursor type to a table type and the generated T-SQL function is also correct. We can either Accept or Discard the changes. In this case I will go ahead and accept the suggestion:
As a quick check, will copy the generated query into SSMS and see if it can be validated and run successfully:
With the T-SQL procedure validated, you can copy the generated T-SQL procedure into the SSMA project and synchronize/load it along with the other converted Oracle objects.
Here is the demo video that captures this entire scenario end to end:
GitHub Copilot can handle even more complex conversion scenarios and help you save lot of manual effort and time by converting them to correct T-SQL syntax with few clicks. Here is another demo video showcasing a complex PL/SQL package with inbuilt PL/SQL procedures and a user defined data type being converted to T-SQL automatically using GitHub Copilot:
To summarize in this blog post we have seen how the combination of SSMA’s rule-based conversion and GitHub Copilot’s AI-driven approach could significantly accelerate code conversion, potentially achieving high conversion success rates in the late 80s to 90s percentage range.
Microsoft Tech Community – Latest Blogs –Read More
How to KQL query *live* EmailEvents table and NOT the streaming API
EmailEvents table in the advanced hunting schema – Microsoft Defender XDR | Microsoft Learn – this page tells us:
Note
* The LatestDeliveryLocation and LatestDeliveryAction columns are not available in the Streaming API.
I’ve found that a lot of my queries come back with blank LatestDeliveryLocation. This means I’m searching via the streaming API. But I don’t want to do that, I want to search the live EmailEvents table and even want to filter based on LatestDeliveryLocation. I am working in Defender portal, within the Advanced Hunting section. Example query:
// Works (time range set in UI dropdown):
EmailEvents
| where LatestDeliveryLocation in~ (‘Quarantine’, ‘Junk folder’) and DeliveryLocation =~ ‘Inbox/folder’
// Does NOT work:
EmailEvents
| where TimeGenerated >= ago(1d)
| where LatestDeliveryLocation in~ (‘Quarantine’, ‘Junk folder’) and DeliveryLocation =~ ‘Inbox/folder’
So it seems as though if your query sets the time range, you’re searching the streaming API. Can anyone please confirm I have this understood correctly? My next question would be, can I add something else to my query to ensure I’ll be searching the live table?
Microsoft 365 Defender Streaming API: Identity and CloudApp Events in General Availability – Microsoft Community Hub – I asked this in the comments over there too.
EmailEvents table in the advanced hunting schema – Microsoft Defender XDR | Microsoft Learn – this page tells us:Note* The LatestDeliveryLocation and LatestDeliveryAction columns are not available in the Streaming API. I’ve found that a lot of my queries come back with blank LatestDeliveryLocation. This means I’m searching via the streaming API. But I don’t want to do that, I want to search the live EmailEvents table and even want to filter based on LatestDeliveryLocation. I am working in Defender portal, within the Advanced Hunting section. Example query: // Works (time range set in UI dropdown):
EmailEvents
| where LatestDeliveryLocation in~ (‘Quarantine’, ‘Junk folder’) and DeliveryLocation =~ ‘Inbox/folder’
// Does NOT work:
EmailEvents
| where TimeGenerated >= ago(1d)
| where LatestDeliveryLocation in~ (‘Quarantine’, ‘Junk folder’) and DeliveryLocation =~ ‘Inbox/folder’ So it seems as though if your query sets the time range, you’re searching the streaming API. Can anyone please confirm I have this understood correctly? My next question would be, can I add something else to my query to ensure I’ll be searching the live table? Microsoft 365 Defender Streaming API: Identity and CloudApp Events in General Availability – Microsoft Community Hub – I asked this in the comments over there too. Read More
Bing Maps “Birds eye View” Alternative
Hi Community,
I need to batch download high-resolution images of specific locations based on latitude and longitude. Previously, I used Bing Maps Bird’s Eye View, which provided the detail and perspective needed to identify objects like 40-yard dumpsters. With the Bing Maps API now discontinued for new users, I’m looking into Azure Maps.
My requirements:
High clarity to accurately identify objects with the zoom level that I can set.Bird’s Eye View (like Bing Maps) to capture depth and dimensions.
Can you suggest which Azure Maps services would best match these needs? Any guidance would be helpful.
Thanks!
Hi Community,I need to batch download high-resolution images of specific locations based on latitude and longitude. Previously, I used Bing Maps Bird’s Eye View, which provided the detail and perspective needed to identify objects like 40-yard dumpsters. With the Bing Maps API now discontinued for new users, I’m looking into Azure Maps.My requirements:High clarity to accurately identify objects with the zoom level that I can set.Bird’s Eye View (like Bing Maps) to capture depth and dimensions.Can you suggest which Azure Maps services would best match these needs? Any guidance would be helpful.Thanks! Read More
KQL Query problem with two double quotes
Hello,
We have a Sharepoint Highlighted Contents webpart with a KQL query like this:
RefinableString110:”True”
The webpart worked fine until a couple of weeks ago, then all of a sudden it didn’t return any result. When looking at the issue, we could find a workaround. We added a double quote at the end of the search query and this fixed the issue:
RefinableString110:True”
which was quite strange.
We checked with the “Search Query Tool” and we got the expected results: the first query worked and the second query returned HTTP/1.1 500 Internal Server Error, so it’s not an issue with the Microsoft service.
We tested with all combinations of quotes, capitals, etc. The only think that worked was putting one double quote at the end of the search query.
Could you please help?
Screenshots show the issue.
Thanks.
Regards,
Hello,We have a Sharepoint Highlighted Contents webpart with a KQL query like this:RefinableString110:”True”The webpart worked fine until a couple of weeks ago, then all of a sudden it didn’t return any result. When looking at the issue, we could find a workaround. We added a double quote at the end of the search query and this fixed the issue:RefinableString110:True” which was quite strange.We checked with the “Search Query Tool” and we got the expected results: the first query worked and the second query returned HTTP/1.1 500 Internal Server Error, so it’s not an issue with the Microsoft service.We tested with all combinations of quotes, capitals, etc. The only think that worked was putting one double quote at the end of the search query.Could you please help?Screenshots show the issue.Thanks.Regards, Read More
Microsoft Defender For Endpoint API Recommendations
Good Afternoon;
We have integrated with the API Endpoint to get the recommendations, we then use the recommendation id to get a list of machine references, which works fine.
We encountered an issue where one of our recommendation id had a / in the string. For example
va-_-microsoft-_-edge_chromium-based/odbc
This isn’t the exact item, but it did have a / in it.
My question is: Is the / in there supposed to be encoded, stripped away? If we then use this id to hit the next endpoint for get a list of machine References, it will error.
Good Afternoon;We have integrated with the API Endpoint to get the recommendations, we then use the recommendation id to get a list of machine references, which works fine.We encountered an issue where one of our recommendation id had a / in the string. For exampleva-_-microsoft-_-edge_chromium-based/odbcThis isn’t the exact item, but it did have a / in it.My question is: Is the / in there supposed to be encoded, stripped away? If we then use this id to hit the next endpoint for get a list of machine References, it will error. Read More
Deploy and configure Azure Monitor Applied Skills assessment not available
Does anyone know when the Applied Skills: Deploy and Configure Azure Monitor assessment will be available again?
I’ve been trying to take it for the past few weeks, but it keeps showing the message “This assessment is currently undergoing maintenance,” as shown in the screenshot.
Does anyone know when the Applied Skills: Deploy and Configure Azure Monitor assessment will be available again? I’ve been trying to take it for the past few weeks, but it keeps showing the message “This assessment is currently undergoing maintenance,” as shown in the screenshot. Read More
Word accessibility checker stuck on “updating results”
I have a weird issue with a user and the Check Accessibility feature in Word. It’s required that they use it before they send these documents out as they go to various clients. About a month ago, it just stopped working correctly, and gets stuck on “Updating Results”
New document with text added using Word desktop app – worksExisting document from SharePoint using Word desktop app – doesn’t work. Same document works with the web version of WordSave document from SharePoint to local desk using Word desktop app – worksOpening an Word attachment in email using Word desktop app – works. Saving same attachment to OneDrive then using Word desktop app – doesn’t work.
So the problem appears to be centered around files that get opened on OneDrive/SharePoint and using the Word app. It works when it’s a local file, but the same file that is saved in SharePoint will not work. The web version will work though.
We are on the monthly enterprise channel, and currently on version 2406, build 16.017726.20206 9×64).
Any ideas?
I have a weird issue with a user and the Check Accessibility feature in Word. It’s required that they use it before they send these documents out as they go to various clients. About a month ago, it just stopped working correctly, and gets stuck on “Updating Results” New document with text added using Word desktop app – worksExisting document from SharePoint using Word desktop app – doesn’t work. Same document works with the web version of WordSave document from SharePoint to local desk using Word desktop app – worksOpening an Word attachment in email using Word desktop app – works. Saving same attachment to OneDrive then using Word desktop app – doesn’t work.So the problem appears to be centered around files that get opened on OneDrive/SharePoint and using the Word app. It works when it’s a local file, but the same file that is saved in SharePoint will not work. The web version will work though. We are on the monthly enterprise channel, and currently on version 2406, build 16.017726.20206 9×64). Any ideas? Read More
How to Migrate Files from Dropbox to OneDrive While Maintaining Folder Structure
I have a corporate Dropbox account where each folder is named after a specific deal from my database. Inside each deal folder, there are subfolders representing the different stages of the deal as it progresses through the database.
Recently, I set up a Microsoft 365 business account and recreated the same folder structure in OneDrive. This means I have the deal folders with their corresponding names, and within each deal folder, I’ve already created the stage-based subfolders.
What I want to achieve is to migrate all the files from Dropbox to their respective folders in OneDrive.
Example:
In Dropbox, I have a folder named “Company1” that contains subfolders like “Emails,” “Attachments,” and “Presentations.” Each of these subfolders contains files.
In OneDrive, I’ve already created the “Company1” folder with the same subfolders: “Emails,” “Attachments,” and “Presentations.” I need to transfer the files from Dropbox so that files from “Emails” in Dropbox go into “Emails” in OneDrive under the “Company1” folder, and so on for the other subfolders.
Request:
I’m looking for the best method to perform this migration while ensuring that the folder structure and file placement remain intact. Is there a native method within Microsoft 365 to accomplish this, or do you know of any third-party applications that can handle this type of migration efficiently? Any advice or step-by-step guidance would be greatly appreciated!
I have a corporate Dropbox account where each folder is named after a specific deal from my database. Inside each deal folder, there are subfolders representing the different stages of the deal as it progresses through the database.Recently, I set up a Microsoft 365 business account and recreated the same folder structure in OneDrive. This means I have the deal folders with their corresponding names, and within each deal folder, I’ve already created the stage-based subfolders.What I want to achieve is to migrate all the files from Dropbox to their respective folders in OneDrive.Example:In Dropbox, I have a folder named “Company1” that contains subfolders like “Emails,” “Attachments,” and “Presentations.” Each of these subfolders contains files.In OneDrive, I’ve already created the “Company1” folder with the same subfolders: “Emails,” “Attachments,” and “Presentations.” I need to transfer the files from Dropbox so that files from “Emails” in Dropbox go into “Emails” in OneDrive under the “Company1” folder, and so on for the other subfolders.Request:I’m looking for the best method to perform this migration while ensuring that the folder structure and file placement remain intact. Is there a native method within Microsoft 365 to accomplish this, or do you know of any third-party applications that can handle this type of migration efficiently? Any advice or step-by-step guidance would be greatly appreciated! Read More
Is there a „=Sheetname(1)“ in Excel for direct input into a cell (no macro or VBA)
I am looking for an Excel-function „sheetname(1)“ with name of the first sheet presented in the workspace for the construction of references. Does this function exist in Excel 365 for direct input without macro or VBA?
Rolf Heller
I am looking for an Excel-function „sheetname(1)“ with name of the first sheet presented in the workspace for the construction of references. Does this function exist in Excel 365 for direct input without macro or VBA?Rolf Heller Read More
Bookings is greyed out
Hi, we’ve noticed today that bookings is grey out, we have 6 services and all are affected, I can’t see any obvious changes as to why this might be. Any initial thoughts would be grateful, thanks
Hi, we’ve noticed today that bookings is grey out, we have 6 services and all are affected, I can’t see any obvious changes as to why this might be. Any initial thoughts would be grateful, thanks Read More
Cash amortization table
Hello,
I am trying to figure which formulate would be best to populate the chart. I am currently doing basic manual formulas for each row but can be very time consuming.
For each week I have total sales. I am trying to figure how much I can expect to collect each week. For example, the cells in yellow are indicating to me in which week to expect to collect the totals sales from week number 1, $500,000
Any suggestion greatly appreciated.
Hello, I am trying to figure which formulate would be best to populate the chart. I am currently doing basic manual formulas for each row but can be very time consuming. For each week I have total sales. I am trying to figure how much I can expect to collect each week. For example, the cells in yellow are indicating to me in which week to expect to collect the totals sales from week number 1, $500,000 Any suggestion greatly appreciated. Read More
phishing emails with only a name as the sender and no visible email address
There has been a sudden surge of spam or phishing emails flooding the main inbox, with only a name as the sender and no visible email address. Could this be due to a newly exploited vulnerability in the app or web app?
Clicking on the senders just expend a empty span and holding open the “contact” of it but once again its just the name, no address.
I have received like on of them every hour ….
On webapp from Edge :
literally says “No sender address” here, c’mon it’s an email, how is this even permitted/supported/possible ??
There has been a sudden surge of spam or phishing emails flooding the main inbox, with only a name as the sender and no visible email address. Could this be due to a newly exploited vulnerability in the app or web app? Clicking on the senders just expend a empty span and holding open the “contact” of it but once again its just the name, no address. I have received like on of them every hour …. On webapp from Edge :literally says “No sender address” here, c’mon it’s an email, how is this even permitted/supported/possible ?? Read More
Simulate api failure when using the C# sdk
Hi
I use the C# SDK to call the grap api, now the tester wants to test the app, but there is a scenario that the call to API should fail, lets say the API is not reachable or request takes a long time, I tried some proxy apps to prevent outgoing request to graph api, but I did not succussed. Can you help ?
HiI use the C# SDK to call the grap api, now the tester wants to test the app, but there is a scenario that the call to API should fail, lets say the API is not reachable or request takes a long time, I tried some proxy apps to prevent outgoing request to graph api, but I did not succussed. Can you help ? Read More
Unique identifier #
Hi,
I’m trying to create a list of unique identifier numbers that users can link to their activity line items with a their expenses along with a way that shows the user if a unique identifier number was already used to avoid duplication/errors. Does excel have the functionality to do this? If so, can you kindly explain? Thank you!
Hi, I’m trying to create a list of unique identifier numbers that users can link to their activity line items with a their expenses along with a way that shows the user if a unique identifier number was already used to avoid duplication/errors. Does excel have the functionality to do this? If so, can you kindly explain? Thank you! Read More
Troubles accessing Chat
Hi all,
Since yesterday, we discover that some people of our organisation stop randomly accessing to the chat icon. The error message says Sorry … we didn’t find this application.
Anyone got it? have you solve it?
Thanks MG
Hi all, Since yesterday, we discover that some people of our organisation stop randomly accessing to the chat icon. The error message says Sorry … we didn’t find this application. Anyone got it? have you solve it? Thanks MG Read More
Talking to your relational Database using GPT not just to one table or view, but to multiple v/t
Dear Community, What is the best solution for a chat app that can interact with a relational database, not just limited to a single table or view? Thank you!
Dear Community, What is the best solution for a chat app that can interact with a relational database, not just limited to a single table or view? Thank you! Read More
How to use a template file in VBA when it is stored online (Teams or SharePoint)?
As many companies are on the brink of migrating to Microsoft 365 and moving all files from the file server to the cloud (OneDrive/SharePoint), I need to know how I can use templates stored in Teams, from VBA.
Here is an example:
I have an Excel file in which I generate a chart, using a chart template with VBA.
This works fine as long the chart template is on a file server, but when I move it to Teams, my code can’t use the template.
so the template path is:
(xxxxxxxxxxxxxxx = company id).
When I run the procedure, I get this error message:
How can I solve this?
GrtZ, BartH_NL
As many companies are on the brink of migrating to Microsoft 365 and moving all files from the file server to the cloud (OneDrive/SharePoint), I need to know how I can use templates stored in Teams, from VBA.Here is an example:I have an Excel file in which I generate a chart, using a chart template with VBA.This works fine as long the chart template is on a file server, but when I move it to Teams, my code can’t use the template.so the template path is:https://xxxxxxxxxxxxxx.sharepoint.com/sites/msteams_a046009/Shared%20Documents/General/DRR%20Test/DRR.crtx(xxxxxxxxxxxxxxx = company id).When I run the procedure, I get this error message:How can I solve this? GrtZ, BartH_NL Read More
Creating a Rubric with Checkboxes and Auto Calculations
Hello all,
I’ve been trying to figure this out on my own, but to no avail. I would like to make a scoring rubric for faculty to use on student projects that auto-calculates. If a certain box is checked, it will assign a value and the section total will be tallied up at the end. I have the Sum function no problem. What I cannot figure out is how to get the check boxes formatted so they will create a certain value for that rubric item.
For example, if B7 is checked, that should return a value of 4. If unchecked, a value of 0. If D8 is checked, that should return a value of 2 (if unchecked, then 0).
Everything would be tallied up in H11 so the instructors do not have to manually calculate the overall score. They simply check a box for each criteria listed in 7-10 and get the sum total. (I have the SUM function inserted and working properly)
Any help on how to format the check boxes to return values is much appreciated. I’ve spent hours using tutorials and articles and am stumped! Thank you.
Hello all, I’ve been trying to figure this out on my own, but to no avail. I would like to make a scoring rubric for faculty to use on student projects that auto-calculates. If a certain box is checked, it will assign a value and the section total will be tallied up at the end. I have the Sum function no problem. What I cannot figure out is how to get the check boxes formatted so they will create a certain value for that rubric item. For example, if B7 is checked, that should return a value of 4. If unchecked, a value of 0. If D8 is checked, that should return a value of 2 (if unchecked, then 0).Everything would be tallied up in H11 so the instructors do not have to manually calculate the overall score. They simply check a box for each criteria listed in 7-10 and get the sum total. (I have the SUM function inserted and working properly) Any help on how to format the check boxes to return values is much appreciated. I’ve spent hours using tutorials and articles and am stumped! Thank you. Read More
List all DL’s in on-prem Exchange with Zero members
We are trying to clean up our 1000’s of Distribution Lists before migrating them to 365.
Could somebody please help me with a script that would accomplish this?
I have tried everything I can think of and have struck out miserably.
Thanks in advance.
We are trying to clean up our 1000’s of Distribution Lists before migrating them to 365.Could somebody please help me with a script that would accomplish this?I have tried everything I can think of and have struck out miserably.Thanks in advance. Read More
New Outlook Personalization Background image
Hello – generally I like the Outlook Mail client but the new one which it seems I’m forced to switch to this year seems to be a retrograde step. I have tried all the settings and can not make it nearly as compact as the previous version. Perhaps the biggest annoyance is that the old client allowed the background image (full screen) to be a user selected photo. Now it seems the choice is a plain colour or a fairly bland microsoft background. This does not seem like a complex capability but the lack of it is stopping me switching and prompting me to explore other clients. Have I missed something?
Hello – generally I like the Outlook Mail client but the new one which it seems I’m forced to switch to this year seems to be a retrograde step. I have tried all the settings and can not make it nearly as compact as the previous version. Perhaps the biggest annoyance is that the old client allowed the background image (full screen) to be a user selected photo. Now it seems the choice is a plain colour or a fairly bland microsoft background. This does not seem like a complex capability but the lack of it is stopping me switching and prompting me to explore other clients. Have I missed something? Read More
