Category: Microsoft
Category Archives: Microsoft
ODBC Driver 18.4 for SQL Server Released
Version 18.4 of the Microsoft ODBC Driver 18 for SQL Server has been released. Version 18.4 brings some minor changes and fixes to the driver.
Added
Following the renaming of Azure Active Directory to Microsoft Entra ID, text and labels in DSN creation UI have been updated
Support for Ubuntu 24.04
Support for Alpine Linux 3.19
Added the ability to accept the EULA for DEB and RPM packages by the presence of a file
Fixed
Fix crashes when receiving invalid data from server
Fix sending of null data for fixed-length types using DAE
Fix 10-minute delay upon disconnection after timeout
Fix memory leak upon disconnection when an error occurs
Fix memory leak upon reconnection with Strict encryption
Fix intermittent crash when connecting with Strict encryption and TLS 1.3
Fix crashes under low-memory conditions
Next steps
For Windows installations, you can directly download the Microsoft ODBC Driver 18 for SQL Server.
Linux and macOS packages are also available. For installation details see the online instructions.
David Engel
Microsoft Tech Community – Latest Blogs –Read More
SPFx and CKEditor 5 [or any version of CKEditor that will work]
Looking for help installing or getting started with CKEditor in an SPFx SharePoint online React Functional Component.
After installing, uninstalling and reinstalling, I continue to have the following [partial error]
�[31m./node_modules/@ckeditor/ckeditor5-build-classic/build/ckeditor.js 6:473701�[39m
�[31mModule parse failed: Unexpected token (6:473701)�[39m
�[31mYou may need an appropriate loader to handle this file type, currently no loaders are configured to process this file
Providing additional details in hope that someone can point be to either a solution or a proper forum for this type of issue.
My Node version is v18.20.4
My package.json looks as follows:
{
“name”: “approvals”,
“version”: “2024.02.29”,
“private”: true,
“engines”: {
“node”: “>=16.13.0 <17.0.0 || >=18.17.1 <19.0.0”
},
“main”: “lib/index.js”,
“scripts”: {
“build”: “gulp bundle”,
“clean”: “gulp clean”,
“test”: “gulp test”,
“typecheck”: “tsc”,
“typecheck:watch”: “tsc -w”,
“serve”: “fast-serve”
},
“dependencies”: {
“@ckeditor/ckeditor5-build-classic”: “^42.0.2”,
“@ckeditor/ckeditor5-react”: “^8.0.0”,
“@emotion/react”: “^11.11.4”,
“@emotion/styled”: “^11.11.5”,
“@fluentui/react”: “^7.204.0”,
“@microsoft/sp-component-base”: “1.18.0”,
“@microsoft/sp-core-library”: “1.18.0”,
“@microsoft/sp-lodash-subset”: “1.18.0”,
“@microsoft/sp-office-ui-fabric-core”: “1.18.0”,
“@microsoft/sp-property-pane”: “1.18.0”,
“@microsoft/sp-webpart-base”: “1.18.0”,
“@mui/material”: “^5.15.20”,
“@pnp/graph”: “^3.12.1”,
“@pnp/logging”: “^3.18.0”,
“@pnp/sp”: “^3.6.0”,
“@pnp/sp-commonjs”: “^2.15.0”,
“@pnp/spfx-controls-react”: “3.15.0”,
“ckeditor4”: “^4.24.0”,
“immer”: “^10.0.3”,
“react”: “17.0.1”,
“react-dom”: “17.0.1”,
“react-scripts”: “^5.0.1”,
“react-tooltip”: “^5.27.0”,
“tslib”: “2.3.1”
},
“devDependencies”: {
“@babel/core”: “^7.25.2”,
“@babel/plugin-proposal-class-properties”: “^7.18.6”,
“@babel/preset-env”: “^7.25.2”,
“@babel/preset-react”: “^7.24.7”,
“@microsoft/eslint-config-spfx”: “1.18.0”,
“@microsoft/eslint-plugin-spfx”: “1.18.0”,
“@microsoft/rush-stack-compiler-4.7”: “0.1.0”,
“@microsoft/sp-build-web”: “1.18.0”,
“@microsoft/sp-module-interfaces”: “1.18.0”,
“@rushstack/eslint-config”: “2.5.1”,
“@types/react”: “17.0.45”,
“@types/react-dom”: “17.0.17”,
“@types/react-tooltip”: “^4.2.4”,
“@types/webpack-env”: “~1.15.2”,
“ajv”: “^6.12.5”,
“babel-loader”: “^8.3.0”,
“css-loader”: “^6.7.0”,
“eslint”: “8.7.0”,
“eslint-plugin-react-hooks”: “4.3.0”,
“gulp”: “4.0.2”,
“raw-loader”: “^4.0.2”,
“sass-loader”: “^13.3.0”,
“spfx-fast-serve-helpers”: “~1.18.0”,
“style-loader”: “^3.3.0”,
“typescript”: “4.7.4”
}
}
My project does not have either .babelrc file nor babel.config.js
I do not have a webpack.config but have the following webpack.extend.js
const path = require(‘path’);
module.exports = function (buildOptions, webpackConfig) {
// Rule to handle JavaScript and JSX files with Babel
webpackConfig.module.rules.push({
test: /.(js|jsx|mjs)$/,
exclude: /node_modules/,
use: {
loader: ‘babel-loader’,
options: {
presets: [‘@babel/preset-env’, ‘@babel/preset-react’],
plugins: [‘@babel/plugin-proposal-class-properties’]
}
}
});
webpackConfig.module.rules.push({
test: /.mjs$/,
include: /node_modules/,
type: ‘javascript/auto’,
});
// Rule to handle CSS files
webpackConfig.module.rules.push({
test: /.css$/,
use: [‘style-loader’, ‘css-loader’]
});
// Rule to handle SCSS files specifically for CKEditor
webpackConfig.module.rules.push({
test: /.scss$/,
include: path.resolve(__dirname, “node_modules/@ckeditor”),
use: [
‘style-loader’,
‘css-loader’,
‘sass-loader’
]
});
// Rule to handle SVG files specifically for CKEditor
webpackConfig.module.rules.push({
test: /.svg$/,
include: path.resolve(__dirname, “node_modules/@ckeditor”),
use: [‘raw-loader’]
});
// Add alias for the react-dom profiler
webpackConfig.resolve.alias = {
“react-dom$”: “react-dom/profiling”
};
return webpackConfig;
};
/*
module.exports = function (buildOptions, webpackConfig) {
// Your custom webpack configurations go here. For example:
webpackConfig.resolve.alias = {
“react-dom$”: “react-dom/profiling”,
};
return webpackConfig;
};
*/
My tsconfig looks as follows:
{
“extends”: “./node_modules/@microsoft/rush-stack-compiler-4.7/includes/tsconfig-web.json”,
“compilerOptions”: {
“target”: “es2017”,
“forceConsistentCasingInFileNames”: true,
“module”: “esnext”,
“moduleResolution”: “node”,
“jsx”: “react”,
“declaration”: true,
“sourceMap”: true,
“experimentalDecorators”: true,
“skipLibCheck”: true,
“outDir”: “lib”,
“inlineSources”: false,
“noImplicitAny”: true,
“noUnusedParameters”: false,
“noUnusedLocals”: false,
“allowSyntheticDefaultImports”: true,
“esModuleInterop”: true,
“typeRoots”: [
“./node_modules/@types“,
“./node_modules/@microsoft“,
],
“types”: [
“webpack-env”,
],
“lib”: [
“es2017”,
“dom”,
“es2015.collection”,
“es2015.promise”
]
},
“include”: [
“src//*.ts”,
“src//.tsx”,
“declaration.d.ts”
],
“exclude”: [
“node_modules”,
“**/.spec.ts”
]
}
I also use SPFx-fast-server and have a gulpfile.js as follows:
“use strict”;
const build = require(“@microsoft/sp-build-web”);
build.addSuppression(Warning – [sass] The local CSS class ‘ms-Grid’ is not camelCase and will not be type-safe.);
var getTasks = build.rig.getTasks;
build.rig.getTasks = function () {
var result = getTasks.call(build.rig);
return result;
};
build.tslintCmd.enabled = false;
/* fast-serve /
const { addFastServe } = require(“spfx-fast-serve-helpers”);
addFastServe(build);
/ end of fast-serve */
build.initialize(require(‘gulp’));
build.configureWebpack.mergeConfig({
additionalConfiguration: (wpcfg) => {
// if dev build, mod config for profiling react
if (wpcfg.mode === “development”) {
test: /.mjs$/,
include: /node_modules/,
type: ‘javascript/auto’,
});
// add alias for the react-dom profiler
wpcfg.resolve.alias = {
“react-dom$”: “react-dom/profiling”,
};
// remove externalization of react & react-dom
wpcfg.externals = wpcfg.externals.filter((external) => {
return external !== “react” && external !== “react-dom”;
});
}
return wpcfg;
},
});
Looking for help installing or getting started with CKEditor in an SPFx SharePoint online React Functional Component.After installing, uninstalling and reinstalling, I continue to have the following [partial error]�[31m./node_modules/@ckeditor/ckeditor5-build-classic/build/ckeditor.js 6:473701�[39m�[31mModule parse failed: Unexpected token (6:473701)�[39m�[31mYou may need an appropriate loader to handle this file type, currently no loaders are configured to process this fileProviding additional details in hope that someone can point be to either a solution or a proper forum for this type of issue.My Node version is v18.20.4My package.json looks as follows:{“name”: “approvals”,”version”: “2024.02.29”,”private”: true,”engines”: {“node”: “>=16.13.0 <17.0.0 || >=18.17.1 <19.0.0″},”main”: “lib/index.js”,”scripts”: {“build”: “gulp bundle”,”clean”: “gulp clean”,”test”: “gulp test”,”typecheck”: “tsc”,”typecheck:watch”: “tsc -w”,”serve”: “fast-serve”},”dependencies”: {“@ckeditor/ckeditor5-build-classic”: “^42.0.2″,”@ckeditor/ckeditor5-react”: “^8.0.0″,”@emotion/react”: “^11.11.4″,”@emotion/styled”: “^11.11.5″,”@fluentui/react”: “^7.204.0″,”@microsoft/sp-component-base”: “1.18.0”,”@microsoft/sp-core-library”: “1.18.0”,”@microsoft/sp-lodash-subset”: “1.18.0”,”@microsoft/sp-office-ui-fabric-core”: “1.18.0”,”@microsoft/sp-property-pane”: “1.18.0”,”@microsoft/sp-webpart-base”: “1.18.0”,”@mui/material”: “^5.15.20″,”@pnp/graph”: “^3.12.1″,”@pnp/logging”: “^3.18.0″,”@pnp/sp”: “^3.6.0″,”@pnp/sp-commonjs”: “^2.15.0″,”@pnp/spfx-controls-react”: “3.15.0”,”ckeditor4″: “^4.24.0″,”immer”: “^10.0.3″,”react”: “17.0.1”,”react-dom”: “17.0.1”,”react-scripts”: “^5.0.1″,”react-tooltip”: “^5.27.0″,”tslib”: “2.3.1”},”devDependencies”: {“@babel/core”: “^7.25.2″,”@babel/plugin-proposal-class-properties”: “^7.18.6″,”@babel/preset-env”: “^7.25.2″,”@babel/preset-react”: “^7.24.7″,”@microsoft/eslint-config-spfx”: “1.18.0”,”@microsoft/eslint-plugin-spfx”: “1.18.0”,”@microsoft/rush-stack-compiler-4.7″: “0.1.0”,”@microsoft/sp-build-web”: “1.18.0”,”@microsoft/sp-module-interfaces”: “1.18.0”,”@rushstack/eslint-config”: “2.5.1”,”@types/react”: “17.0.45”,”@types/react-dom”: “17.0.17”,”@types/react-tooltip”: “^4.2.4″,”@types/webpack-env”: “~1.15.2″,”ajv”: “^6.12.5″,”babel-loader”: “^8.3.0″,”css-loader”: “^6.7.0″,”eslint”: “8.7.0”,”eslint-plugin-react-hooks”: “4.3.0”,”gulp”: “4.0.2”,”raw-loader”: “^4.0.2″,”sass-loader”: “^13.3.0″,”spfx-fast-serve-helpers”: “~1.18.0″,”style-loader”: “^3.3.0″,”typescript”: “4.7.4”}}My project does not have either .babelrc file nor babel.config.jsI do not have a webpack.config but have the following webpack.extend.jsconst path = require(‘path’);module.exports = function (buildOptions, webpackConfig) {// Rule to handle JavaScript and JSX files with BabelwebpackConfig.module.rules.push({test: /.(js|jsx|mjs)$/,exclude: /node_modules/,use: {loader: ‘babel-loader’,options: {presets: [‘@babel/preset-env’, ‘@babel/preset-react’],plugins: [‘@babel/plugin-proposal-class-properties’]}}});// Rule to handle `.mjs` files
webpackConfig.module.rules.push({
test: /.mjs$/,
include: /node_modules/,
type: ‘javascript/auto’,
});
// Rule to handle CSS files
webpackConfig.module.rules.push({
test: /.css$/,
use: [‘style-loader’, ‘css-loader’]
});
// Rule to handle SCSS files specifically for CKEditor
webpackConfig.module.rules.push({
test: /.scss$/,
include: path.resolve(__dirname, “node_modules/@ckeditor”),
use: [
‘style-loader’,
‘css-loader’,
‘sass-loader’
]
});
// Rule to handle SVG files specifically for CKEditor
webpackConfig.module.rules.push({
test: /.svg$/,
include: path.resolve(__dirname, “node_modules/@ckeditor”),
use: [‘raw-loader’]
});
// Add alias for the react-dom profiler
webpackConfig.resolve.alias = {
“react-dom$”: “react-dom/profiling”
};
return webpackConfig; };/*module.exports = function (buildOptions, webpackConfig) {// Your custom webpack configurations go here. For example:webpackConfig.resolve.alias = {“react-dom$”: “react-dom/profiling”,};return webpackConfig;};*/My tsconfig looks as follows:{“extends”: “./node_modules/@microsoft/rush-stack-compiler-4.7/includes/tsconfig-web.json”,”compilerOptions”: {“target”: “es2017″,”forceConsistentCasingInFileNames”: true,”module”: “esnext”,”moduleResolution”: “node”,”jsx”: “react”,”declaration”: true,”sourceMap”: true,”experimentalDecorators”: true,”skipLibCheck”: true,”outDir”: “lib”,”inlineSources”: false,”noImplicitAny”: true,”noUnusedParameters”: false,”noUnusedLocals”: false,”allowSyntheticDefaultImports”: true,”esModuleInterop”: true,”typeRoots”: [“./node_modules/@types”,”./node_modules/@microsoft”,],”types”: [“webpack-env”,],”lib”: [“es2017″,”dom”,”es2015.collection”,”es2015.promise”]},”include”: [“src//*.ts”,”src//.tsx”,”declaration.d.ts”],”exclude”: [“node_modules”,”**/.spec.ts”]}I also use SPFx-fast-server and have a gulpfile.js as follows:”use strict”;const build = require(“@microsoft/sp-build-web”);build.addSuppression(Warning – [sass] The local CSS class ‘ms-Grid’ is not camelCase and will not be type-safe.);var getTasks = build.rig.getTasks;build.rig.getTasks = function () {var result = getTasks.call(build.rig);result.set(“serve”, result.get(“serve-deprecated”));
return result; };build.tslintCmd.enabled = false;/* fast-serve /const { addFastServe } = require(“spfx-fast-serve-helpers”);addFastServe(build);/ end of fast-serve */build.initialize(require(‘gulp’));build.configureWebpack.mergeConfig({additionalConfiguration: (wpcfg) => {// if dev build, mod config for profiling reactif (wpcfg.mode === “development”) { wpcfg.module.rules.push({
test: /.mjs$/,
include: /node_modules/,
type: ‘javascript/auto’,
});
// add alias for the react-dom profiler
wpcfg.resolve.alias = {
“react-dom$”: “react-dom/profiling”,
};
// remove externalization of react & react-dom
wpcfg.externals = wpcfg.externals.filter((external) => {
return external !== “react” && external !== “react-dom”;
});
}
return wpcfg;
}, }); Read More
New Windows 365 features reach general availability
It’s been three years since Windows 365 became broadly available. Today, Scott Manchester, Vice President – Windows Cloud Experiences, shared new updates to Windows 365 based on customer feedback.
For more details on these updates — including features now generally available — check out today’s posts on the Windows IT Pro Blog from the Windows 365 PMs:
New Windows 365 features help provide a more secure workspace
Windows 365 GPU-enabled Cloud PCs now generally available
AI-driven insights reduce TCO for Windows 365 Cloud PCs
Windows App general availability coming soon
There were also announcements about partner integrations, specifically:
Windows 365 management capabilities now on N-able Cloud Commander
How to integrate Windows 365 with Omnissa Horizon
If you have questions about any of today’s announcements, please leave a comment on the blogs. To submit feedback, visit the Windows 365 Feedback Portal.
It’s been three years since Windows 365 became broadly available. Today, Scott Manchester, Vice President – Windows Cloud Experiences, shared new updates to Windows 365 based on customer feedback.
For more details on these updates — including features now generally available — check out today’s posts on the Windows IT Pro Blog from the Windows 365 PMs:
New Windows 365 features help provide a more secure workspace
Windows 365 GPU-enabled Cloud PCs now generally available
AI-driven insights reduce TCO for Windows 365 Cloud PCs
Windows App general availability coming soon
There were also announcements about partner integrations, specifically:
Windows 365 management capabilities now on N-able Cloud Commander
How to integrate Windows 365 with Omnissa Horizon
If you have questions about any of today’s announcements, please leave a comment on the blogs. To submit feedback, visit the Windows 365 Feedback Portal. Read More
how to send SSIS redirected error rows to json/nvarchar column in sql sever table
I have SSDT transformation component where I have configured in case any truncation, send them to SQL server table. requirement is to capture error information, error code and other column info in json format. I know this can be achieved using script component, but looking for any code snippet.
I have SSDT transformation component where I have configured in case any truncation, send them to SQL server table. requirement is to capture error information, error code and other column info in json format. I know this can be achieved using script component, but looking for any code snippet. Read More
Need to Restore a SharePoint Server From a Full Database Backup
This is a sticky and complex issue (I think). We shut down a SharePoint Server several years ago and now we need it back up. I did a Full SQL database backup of everything on the server. Here is the version information:
Microsoft SQL Server 2016 (SP2-GDR) (KB4532097) – 13.0.5102.14 (X64) Dec 31 2019 22:39:35 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: )
See below for a list of all the databases that were in the backup.
Questions:
Who do I need to talk to for a process to restore these databases on a server?
What kind of restoration should I expect? Will I end up with a functional SP server?
Thanks,
Joseph
This is a sticky and complex issue (I think). We shut down a SharePoint Server several years ago and now we need it back up. I did a Full SQL database backup of everything on the server. Here is the version information: Microsoft SQL Server 2016 (SP2-GDR) (KB4532097) – 13.0.5102.14 (X64) Dec 31 2019 22:39:35 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) See below for a list of all the databases that were in the backup.Questions:Who do I need to talk to for a process to restore these databases on a server?What kind of restoration should I expect? Will I end up with a functional SP server? Thanks,Joseph Read More
Issue running DLT pipeline
I am new to Azure. I was trying to do a lab in Azure data engineering:Create a data pipeline with Delta Live tables. I followed all steps as mentioned in the lab instructions in Microsoft learn. But I got the following issue when I tried to start Delta live tables pipeline.
DataPlaneException: [DLT ERROR CODE: CLUSTER_LAUNCH_FAILURE.CLOUD_PROVIDER_FAILURE] Failed to launch pipeline cluster 0801-165638-xpgr89hv with termination code AZURE_QUOTA_EXCEEDED_EXCEPTION and termination type CLIENT_ERROR: Encountered Quota Exhaustion issue in your account: azure_error_code: QuotaExceeded, azure_error_message: Operation could not be completed as it
results in exceeding approved Total Regional Cores ..
Could anybody please help me out? What can I do? I am clueless.
I am new to Azure. I was trying to do a lab in Azure data engineering:Create a data pipeline with Delta Live tables. I followed all steps as mentioned in the lab instructions in Microsoft learn. But I got the following issue when I tried to start Delta live tables pipeline. DataPlaneException: [DLT ERROR CODE: CLUSTER_LAUNCH_FAILURE.CLOUD_PROVIDER_FAILURE] Failed to launch pipeline cluster 0801-165638-xpgr89hv with termination code AZURE_QUOTA_EXCEEDED_EXCEPTION and termination type CLIENT_ERROR: Encountered Quota Exhaustion issue in your account: azure_error_code: QuotaExceeded, azure_error_message: Operation could not be completed as itresults in exceeding approved Total Regional Cores .. Could anybody please help me out? What can I do? I am clueless. Read More
Selecting cells adjacent to empty cells.
So here is an example,
I want select the cells adjacent to empty cells (e.g Numbers which are in bold) and move them up to the third column on the side of the same number.
I have data in following format:
A1 B2 2 C3 D4 4 E5 F6 6 G7 7 H8
I want the output in following format:
A1 B22 C3 D44 E5 F66 G77 H8
Can anyone help since the data I have is much bigger near to 500 rows.
Thank you!
So here is an example,I want select the cells adjacent to empty cells (e.g Numbers which are in bold) and move them up to the third column on the side of the same number. I have data in following format: A1 B2 2 C3 D4 4 E5 F6 6 G7 7 H8 I want the output in following format: A1 B22 C3 D44 E5 F66 G77 H8 Can anyone help since the data I have is much bigger near to 500 rows.Thank you! Read More
Is Unified Inbox in New Outlook for Windows 11 a myth?
I’m very confused – is there really a Unified Inbox in the new Outlook for Windows 11? The documentation encouraging users to try the new Outlook says so, I’ve heard from other users that it exists, and I’ve even seen very specific instructions for how to enable it, but I don’t see any options to turn it on in the new Outlook, and many others in the Microsoft Community forums seem to think it does not exist (based on recent posts). Is there some trick to enabling it? Do I need to delete and re-add all my accounts? Or is it simply a myth that it exists.
My calendar is already showing a unified view so that’s a plus.
I’m very confused – is there really a Unified Inbox in the new Outlook for Windows 11? The documentation encouraging users to try the new Outlook says so, I’ve heard from other users that it exists, and I’ve even seen very specific instructions for how to enable it, but I don’t see any options to turn it on in the new Outlook, and many others in the Microsoft Community forums seem to think it does not exist (based on recent posts). Is there some trick to enabling it? Do I need to delete and re-add all my accounts? Or is it simply a myth that it exists. My calendar is already showing a unified view so that’s a plus. Read More
Offboarded from Microsoft Partner Program — How do we get back on?
I recently took on a role where I need to determine why my company was offboarded from the Microsoft Partner Program and to work on reinstating our full program participation. We have monthly earnings recorded until September 2022, but we were offboarded in July 2022 with no notification, despite our monthly spend remaining consistent. The Microsoft Incentives Support Team directed us to this community support hub for assistance and information. Could we get some direction on where to start and how to proceed?
I recently took on a role where I need to determine why my company was offboarded from the Microsoft Partner Program and to work on reinstating our full program participation. We have monthly earnings recorded until September 2022, but we were offboarded in July 2022 with no notification, despite our monthly spend remaining consistent. The Microsoft Incentives Support Team directed us to this community support hub for assistance and information. Could we get some direction on where to start and how to proceed? Read More
Digital signature missing in Connectivity file in Microsoft 365 network connectivity test
Hi,
The Microsoft 365 network connectivity test is widely used to check and tshoot issues related with MS products. Some colleagues and myself, have seen than this week, the tool is not running ok.
When I checked, the downloaded file today is missing a digital signature which makes it untrusted for the browsers.
I read a post from May pointing an issue, to a possible lack of digital signature too.
Are you guys aware of this? When would this be fixed?
Thanks for your collaboration in advance!
Hi,The Microsoft 365 network connectivity test is widely used to check and tshoot issues related with MS products. Some colleagues and myself, have seen than this week, the tool is not running ok. When I checked, the downloaded file today is missing a digital signature which makes it untrusted for the browsers. I read a post from May pointing an issue, to a possible lack of digital signature too. Are you guys aware of this? When would this be fixed? Thanks for your collaboration in advance! Read More
No content for Purview
When I search for Purview, I don’t find anything, see below, Can someone investigate this and get it fixed?
When I search for Purview, I don’t find anything, see below, Can someone investigate this and get it fixed? Read More
Flow to update a SharePoint list item when a new item is created in a different SharePoint list
I have two lists that are related to projects – ‘Dashboard’ & ‘Status Reports’. Both of these lists contain the columns ‘RAG Status’.
I want to create a flow that updates the ‘Dashboard’ ‘RAG Status’ column with the ‘RAG Status’ information from the most recent item submitted on the ‘Status Reports’ list for that specific project.
The project name information on the ‘Dashboard’ list is called ‘Full Project Name’ and the same information is stored under ‘Project Name’ on the ‘Status Reports’ list.
I have two lists that are related to projects – ‘Dashboard’ & ‘Status Reports’. Both of these lists contain the columns ‘RAG Status’. I want to create a flow that updates the ‘Dashboard’ ‘RAG Status’ column with the ‘RAG Status’ information from the most recent item submitted on the ‘Status Reports’ list for that specific project. The project name information on the ‘Dashboard’ list is called ‘Full Project Name’ and the same information is stored under ‘Project Name’ on the ‘Status Reports’ list. Read More
Solve for X with Functions
Hello everyone,
I have a spreadsheet that I am trying to automate as much as allowed by policies. The issue I currently have could be solved with a Macro, Goal Seek, and even Solver, but we need something that is automatic and does not use any of those 3 tools. Hence, why I’m asking for help building a function instead.
For the spreadsheet I have attached, here is an explanation of each component:
Cost, On Hand, Adjustment, and Pending: Manual entries. Don’t need help with those.
Factor 1 and Factor 2: Constant values that only get changed when C-Suites give the order.
Variable: The one entry that I need to play around with in order to get the end result I need.
Cash Total: The end result I need, which needs to be >= 0.
Deficit: This is the calculated cell that tells me what I need to enter in Variable to make Cash Total >= 0. It is the cell that I need help with writing a function for it for whenever Cash Total is a negative value.
To calculate Cash Total, the equation would be as follows:
(On Hand + Variable – Adjustment) * (1 + Factor 1) * Cost + Factor 2
I appreciate any help provided for this as I’m at my wits end.
Hello everyone, I have a spreadsheet that I am trying to automate as much as allowed by policies. The issue I currently have could be solved with a Macro, Goal Seek, and even Solver, but we need something that is automatic and does not use any of those 3 tools. Hence, why I’m asking for help building a function instead. For the spreadsheet I have attached, here is an explanation of each component:Cost, On Hand, Adjustment, and Pending: Manual entries. Don’t need help with those.Factor 1 and Factor 2: Constant values that only get changed when C-Suites give the order. Variable: The one entry that I need to play around with in order to get the end result I need.Cash Total: The end result I need, which needs to be >= 0.Deficit: This is the calculated cell that tells me what I need to enter in Variable to make Cash Total >= 0. It is the cell that I need help with writing a function for it for whenever Cash Total is a negative value. To calculate Cash Total, the equation would be as follows:(On Hand + Variable – Adjustment) * (1 + Factor 1) * Cost + Factor 2 I appreciate any help provided for this as I’m at my wits end. Read More
Copilot in Teams only searching 1 month
Why can Copilot in Teams chat only search the previous month? Is this a downgrade, I could have sworn that the search capabilities previously had a larger timeframe?
Why can Copilot in Teams chat only search the previous month? Is this a downgrade, I could have sworn that the search capabilities previously had a larger timeframe? Read More
Certification Email
Hello,
I recently acquired a Microsoft Certification and it shows up under my profile -> credentials -> certifications, but I still have not received my email with the certification in it. Is there something I need to do to prompt the email? It has been right around 24 hours since I officially passed.
Hello, I recently acquired a Microsoft Certification and it shows up under my profile -> credentials -> certifications, but I still have not received my email with the certification in it. Is there something I need to do to prompt the email? It has been right around 24 hours since I officially passed. Read More
Email Disappears
This has been going on for several months. If I send and email to myself, it flashes in the inbox for a couple of seconds and then disappears. It is nowhere! I have no rules or filters applied to Outlook. At times random email from others does the same thing. I just did an online repair of Office. That didn’t help. There are literally hundreds of other people on the internet who have the same problem. No viable solution is evident. This is a serious problem. Can anyone help?
This has been going on for several months. If I send and email to myself, it flashes in the inbox for a couple of seconds and then disappears. It is nowhere! I have no rules or filters applied to Outlook. At times random email from others does the same thing. I just did an online repair of Office. That didn’t help. There are literally hundreds of other people on the internet who have the same problem. No viable solution is evident. This is a serious problem. Can anyone help? Read More
In adf get file name in blob, & add it to same file with new column for each row.
Wanted to add new column in file which is in blob, column value should be file name itself.
Example: assigned.csv is a file.
New column Employee Id
1. Assigned 242344
2. Assigned 234553
3. Assigned 423222
Wanted to add new column in file which is in blob, column value should be file name itself.Example: assigned.csv is a file. New column Employee Id1. Assigned 2423442. Assigned 2345533. Assigned 423222 Read More
Real Time Monitoring and Behavior Monitoring
Good afternoon,
I am running into an issue with DLP protecting endpoints, the following are the findings:
In purview:
– Real-Time Monitoring Enabled
– Behavior Monitoring Enabled
The devices are using CrowdStrike as the active AV client and the Defender AV client is in EDR Block Mode however when testing Policies that should restrict USB, Printing, and Copy and Paste of Sensitive Data the policies are not being enforced. The test device is not generating any alerts or notifications in the Purview portal or Toast Notifications.
Policies are enforced via GPO:
– Real Time Monitoring
– Behavior Monitoring
Endpoints have Windows Defender FW and Crowdstrike enabled, but have been disabled on the test device.
Any insights on why the devices are showing in the MDE Portal that RTM and BM are disabled
Good afternoon, I am running into an issue with DLP protecting endpoints, the following are the findings: In purview:- Real-Time Monitoring Enabled- Behavior Monitoring Enabled The devices are using CrowdStrike as the active AV client and the Defender AV client is in EDR Block Mode however when testing Policies that should restrict USB, Printing, and Copy and Paste of Sensitive Data the policies are not being enforced. The test device is not generating any alerts or notifications in the Purview portal or Toast Notifications. Policies are enforced via GPO: – Real Time Monitoring- Behavior Monitoring Endpoints have Windows Defender FW and Crowdstrike enabled, but have been disabled on the test device.Any insights on why the devices are showing in the MDE Portal that RTM and BM are disabled Read More
New metered billing for GitHub Enterprise Cloud (GHE) and GitHub Advanced Security (GHAS)
GitHub introduces metered billing for GitHub services such as Enterprise Cloud (GHE) and GitHub Advanced Security (GHAS) offering customers a consistent & unified billing experience, added flexibility to scale and provision resources on-demand, and expanded paths to purchase GitHub solutions via Microsoft Cloud Solution Partners (CSP), modern commerce contracts (MCA-E) and Web Direct.
NOTE: LSPs will still be able to sell through prior-existing licensing method, but are now available to offer sales through the new consumptive/metered model as well.
Empower customers with more self-serve and self-enablement paths to accelerate adoption by accessing to the different resources we have for partners:
Live Technical bootcamp and resources: aka.ms/GitHubTechSkilling
Live Sales & Pre-sales bootcamp and resources: aka.ms/GitHubSalesSkilling
GitHub Sales and Presales Partner Skilling on demand assets
Partner Center Announcement
CSP Launch Blog post: https://aka.ms/GitHubMeterUpdate
Microsoft Tech Community – Latest Blogs –Read More
Terminating a Process for Another User
New Release: Windows 11 24H1
I am currently facing a challenge with user switching on our Windows computers. The issue arises when multiple users are using the same computer and an application automatically launches at startup. If another user logs in through Fast User Switching, they encounter an error message indicating that the application is already running.
To address this issue, I attempted to resolve it by adjusting the application’s auto-start settings and creating a batch file with the following commands:
Code:
taskkill /im program.exe /t /f
@start “” “C:pathprogram.exe”
Subsequently, I generated a shortcut for the batch file and placed it in the C:ProgramDataMicrosoftWindowsStart MenuProgramsStartup directory.
One potential cause of this error could be related to user permissions, specifically if some users do not have admin privileges.
New Release: Windows 11 24H1 I am currently facing a challenge with user switching on our Windows computers. The issue arises when multiple users are using the same computer and an application automatically launches at startup. If another user logs in through Fast User Switching, they encounter an error message indicating that the application is already running. To address this issue, I attempted to resolve it by adjusting the application’s auto-start settings and creating a batch file with the following commands: Code:taskkill /im program.exe /t /f@start “” “C:pathprogram.exe” Subsequently, I generated a shortcut for the batch file and placed it in the C:ProgramDataMicrosoftWindowsStart MenuProgramsStartup directory. One potential cause of this error could be related to user permissions, specifically if some users do not have admin privileges. Read More