Powershell Scripting with Hyper-V and PoC
Hi Guys, I'm currently working on a powershell script to build my PoC environment and using the following code to set memory for each of my VMs $MemoryAvailable = (Get-VMHostNumaNode).MemoryAvailable/4 I'm splitting the total memory by 4 to get the…
Error: DTS Script task has encountered an exception in user code : Cannot load script for execution
Hi. I am using SSIS. I have solution which contains multiple packages. Each package contains multiple data flow tasks and script tasks . Most of the things were working earlier, but suddenly the script tasks are giving error as: DTS Script task has…
Device Wipe goes to WinRE in 10%
We are using Device Wipe to re-install Wi10 machine before handing it out to another user. In 10% cases, computer goes to WinRE and is not recoverble. We need to use USB installation media then to fully re-install the machine. Laptops are not exactly…

Windows10Enterprise
How to remove the PIN login way in Windows10 Enterprise


Sharepoint 2013 - BDC custom content source crawl error
Hi Our Sharepont 2013 Servers have been hardened to TLS 1.2 We have a custom BDC model/external system and we have as a custom content source which uses the BDC service application and when we crawl this custom content source gives an error below : Error…
side by side scom 2012 and 2019
hey i need an assistant with an issue , i have scom 2012 and i was created new scom 2019 on other server. now i noticed that in my 2019 scom i havent the basic monitors for cpu / memeory / logical disk .... when i am trying to install my 2012 MP…
Accessing Ingres via ODBC
I am creating a series of SSIS packages to extract data from an Ingres data source. We have created the ODBC User Source. We have created an SSIS Connection Manager, which tests correctly. But when we define the ODBC Data Source, we are not able…
Excel issue
how can i split them to two columns ? These data are irregularly. chinese and number, but different width and no space between them
How to integrate CCTV, NVR with Azure Cognitive services?
How to integrate CCTV, NVR with Azure Cognitive services?
IKEv2 not responding to certificate request
I am connecting to a strongSwan VPN using IKEv2. After a reboot the connection works, but after a disconnect and reconnect I get the message that the remote server is not responding, however it is clear from Wireshark that a connection has been initiated…
SSISDB Object Reference not set to an instance of an object
Hi, Can you help discover possible reasons why that when I execute a SSIS from VS2017 the process is running, but when I deploy it to the SSISDB and running the same package the process return a error: "Object Reference not set to an instance of an…
SQL Query Help, Distinct and Group By
Hello, This should be an easy question but I'm relatively new to SQL. I have a table of products (actually a view) with about 500,000 rows. Amongst other columns I have [Supplier Name] and Brand. I have 301 distinct [Supplier Name] and I have…
NIC teaming and DHCP
When using NIC teaming in Windows Server 2016/2019 there is no way of determining which member interface becomes primary at boot. Because we cannot determine this, we do not know which member's MAC address will be used by the team. This makes DHCP…
One SharePoint site collection is not openign from sharepoint desinger
One SharePoint site collection is not openign from sharepoint desinger nor from edit list from SharePoint list. there was a issue in opening the sharepoint sites (2016) from sharepoint designer (2013) ,After SP 1 designer 2013 installed, I could open…
Reset WSUS in SCCM to start from scratch
Have done these steps: > I. REMOVE SUP and WSUS Remove SUP role from SCCM console. Check the SUPSetup.log to check when the removal was successfull. Run Administrative PowerShell to remove WSUS role and management tools: …
How to join between xquery data and table data
DECLARE @XmlData AS XML=N'<?xml version="1.0" encoding="utf-16"?> <Root> <PeriodicalData> <Section>Consensus Model</Section> <LineItem>Total…
Issues with form after migrating to SharePoint 2016 from SharePoint 2010
After migration users are facing the following issues in 2016, so Display From- does not show create or modified dates NewForm - Not able to edit EditForm -Not able to edit Please help and let me know what could be the issue.
Finding Daily Averages for Values in Large File
I have a large spreadsheet of wave data from Lake Michigan spanning from May 2019 to October 2019. This data is collected from a buoy that records the values every 10 minutes. The file is large and contains over 20,000 rows. I need to find the daily…

Why Parts Mass Value changed From table temppc to table tmpParts when separated by comma and How to solve?
I work on SQL Server 2012. When using Stuff to collect data separated by comma, I get strange results. Mass number separated by comma in table #tmpParts Not exactly what exist in the original table #TempPC. To summarize my issue mass for part 5223986-2…
excel file issue after migration
I Have migrated 2010 production site to 2016 lab using DB Migraiton Method so now 2016 lab has been given for testing. Please help on how to solve below requirement from end user. Below is the query from end user who is testing 2016 lab site…