Need workaround to make event trigger on Datalake ADLS Gen1
I need to find out a workaround solution to trigger my ADF V2 pipeline when files are placed in data lake ADLS Gen1. So anyone tell me an alternative approach to make a workable solution. Any reference solutions or links are appreciated.
User Information list not showing Title and Department values for users.
Hello, In SharePoint 2013 User Profile Synchronization is working fine and users with all data including Title and Department is synced with UPSA. When search for the few users in "User Information List" it just shows the user name , no…
Why print job queue status is showing Ready while printer is not reachable
In one of my print server running windows Server 2016, I see the job queue status is showing READY while the printer is not reachable from the print server. Printer was offline. Why the job queue status of printer in print server not updated to…
old webpages don't work as expected in IE11 when i add the site to compatibility view settings manually. But when I debug the website(F12) and Emulate it in IE7 ot IE5,it work well.
Hi, As I said in the title, I have some apps that are a bit on the older side, and will not get upgraded. and they work only in IE version under 8(8 not included) (No other browsers). Now I need to use it in IE11. Step1: I debug the…
Anyone encountered this SSRS error?
I am getting the following error in SSRS 2016 builder, appears to be a bug. System.Web.Services.Protocols.SoapException: The expression used for the parameter ‘@Anonymous ’ in the dataset ‘@Anonymous ’ refers to a field. Fields cannot be used in…
SQL Database Shrink
Hi all, Quick question, I have a database which due to a one-time mass photo import has grown to 600GB with 54% of it now unallocated. The photos were uploaded to the DB, which grew to accommodate them, and were then later moved off to the filestore…
WPF : Curly lines are getting drawn differently on different height( y coordinate)
Issue: I am facing issue in wpf while trying to draw curly lines i.e curls are appearing fine at some points but not on all points for y coordinate. Observation : Looks like it draws curves correctly only if y coordinate is multiple of width of rect…
Django app successfully deployed to Azure App Service failing to start up
We have a Django app which was successfully deployed earlier to a default Linux Azure container on Azure App Service using Github actions. After recent deployment, the site will not start up, Below is the container log which just says "Worker…
Discover is not an option in Azure Migrate
The current Microsoft documentation says to select Discover under Migration Goals > Servers > Azure Migrate: Discovery and assessment. In my Azure Migrate portal, Servers, Databases and Web Apps have been consolidated into one menu item, and there…
Azure Data Box transfer Speed
Hi, What is the maximum transfer speed can be achieved with Azure data Box ? We have a azure data box, but not sure how can we get max speed. Currently, we connected the data box to our core switch using the DATA1 and DATA2 NICs with SFP…
Recursive date in a sql view
Hello, I have a table with the following fields: LineId FromDate ToDate Amount 1 01.01.2021 10.01.2021 100 2 05.07.2021 07.07.2021 300 and so on I want a recursive query which will help me…
How to loop through multiple SQL Tables in SSIS using Foreach Loop?
I want to export data from multiple SQL tables to .csv file in SSIS using Foreach loop Container. How do I achieve the same?
Connecting multiple Quickbooks account in power BI
Hi - I have a parent company and 3 subsidiaries and i want to connect all 4 quickbooks company to power BI to get consolidated reports and charts. I was unable to connect more than one company in Quickbooks. Please help if there is a solution around…
Quarterly data load in SSIS package
I just started using SSIS tool and i need quick help to load data quarterly Here`s my scenario: I came up with a query ( source Database: DB2 ) which will extract data from 2010-01-01 to 2021-12-31,(12 years of data) however the data volume is too…
Lookup File
I have 2 csv files. FileA has a dataset. FileB only has a list of row numbers in FileA that need to be imported. How do you link the 2 files to get the right rows in FileA?
"windows does not have enough information to verify the certificate"
On my Lenovo Feb 2020 workstation computer internet options (control panel) > content > certificates > personal > double left click on highlighted ( c0ecc.. Ms-Org...3/...<non ) > Certificate > Certificate Information message…
Azure APIM- cache-lookup-value failed to validate on POST Request
Below is the policy configured at the API level but it failed to validate cache-lookup-value key <cors> <allowed-origins> <origin></origin> </allowed-origins> …
If log4J is only for SQL 2019 and not for prior versions of SQL
Hello, Our application is using SQL 2019 Express. After installation of SQL 2019 SQL 2019 Express edition RTM (15.0.2000.5) Log4J components are found under "C:\Program Files\Microsoft SQL Server\150\DTS\Extensions\Common\Jars". We did our…
SQL query help in removing duplicates
I have a requirement to delete duplicate rows from my table. I am trying to simulate the issue using #temp table below. As you can see, there are duplicate records for the same Unit, AccNo, Menu and RefDate. Only difference is the EnteredDateTime. I…
AD Bulk users of description with account name form CSV Import
I want to be able to add/update the description attribute in AD from a CSV import, the CSV will have two columns: sAMAccountName and description, so I want the script to be able to search using the user account and then add the corresponding description.…