This short post shows you one of the reasons you cannot see Folder under the Upload button in SharePoint, like the picture below.
The reason here is because you use Internet Explorer. Internet Explorer has become helpless now a day. I need to open your SharePoint Document Library using Microsoft Edge or Google Chrome.
This post shows you how to get rid of the below error.
“System.InvalidOperationException: Connector: M365xxxxx.onmicrosoft.com – AAD is busy.”
When you issue the below command in PowerShell.
Start-ADSyncSyncCycle -PolicyType Delta
You need to do this to run the command.
Enter-PSSession -ComputerName TypeInYourComputerName
Start-ADSyncSyncCycle -PolicyType Delta
Exit-PSSession
This post shows one of the possible solutions
Set-MsolDirSyncEnabled : You cannot turn off Active Directory synchronization.”
When you run the following PowerShell command.
“Set-MsolDirSyncEnabled -EnableDirSync $true”
For me I start my Azure AD Connect. Choose Configure then choose Next.
Once it is done rerun the Set-MsolDirSyncEnabled -EnableDirSync $true. This works for me.
Reference: https://jaapwesselius.com/2018/03/22/set-msoldirsyncenabled-not-available/
This post guide you to Microsoft Forms Pro in the way I understand. When I reach https://formspro.microsoft.com/en-us/ then start to worry how much I need to pay for this because in order to create your Form with question with Italic font in it then you need Microsoft Forms Pro. Somehow I can get an evaluate without paying. When you reach the landing page, do not click the Sign n. Click Get started then put in your email address.
You will then get the feature of Forms Pro when you are creating a Form.
The end result is like the one below.
This post shows you how to divide huge single table data extracting in SSIS to multiple parallel data source using the T-SQL offset and fetch next feature.
The pre-requisite is you need to have a knowledge on SSIS and T-SQL. In this sample I will use northwind database Products tables and load the data parallelly into Products2 table. First you need to have a Control Flow as below. Create 2 SSIS variable name them varRows and varReminder.
The total rows will divide equally by 5. I will use Data Flow Task to Data Flow Task 4 to run them. The reminding rows will run in Data Flow 5. Assign the result divided by 5 into varRows, for example if the total rows is 78 then varRows will get 15. So Data Flow Task to Data Flow Task 4 will run 15 rows each. Data Flow Task 5 will run the reminding 3 rows. Inside the code into the Script Task as below.
public void Main()
{
string strCon = “data source=.;initial catalog=NorthWind;user id=sa; password=”password”;
string strSql = “SELECT COUNT(ProductId) as RowsCount FROM Products”;
SqlConnection conn = new SqlConnection(strCon);
conn.Open();
SqlCommand cmd = new SqlCommand(strSql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Dts.Variables[“User::varRows”].Value = long.Parse(dr[0].ToString()) / 5;
Dts.Variables[“User::varRemainer”].Value = long.Parse(dr[0].ToString()) % 5;
}
Dts.TaskResult = (int)ScriptResults.Success;
}
In the Data Flow Task OLE DB Source put the following SQL statement.
The task will start from row 0. It will take 15 rows.
SELECT * FROM Products
order by ProductId
OFFSET 0 ROWS
FETCH NEXT ? ROWS ONLY
In the Data Flow Task 1 OLE DB Source put the following SQL statement This task will start from row 16. You realized both parameters are also varRows.
SELECT * FROM Products
order by ProductId
OFFSET ? ROWS
FETCH NEXT ? ROWS ONLY
In the Data Flow Task 2 OLE DB Source put the following SQL statement This task will start from row 31 because Offset 15×2=30.
SELECT * FROM Products
order by ProductId
OFFSET (? * 2) ROWS
FETCH NEXT ? ROWS ONLY
In data Flow Task 5 the second parameter is the varReminder, the reminding rows to fetch.
SELECT * FROM Products
order by ProductId
OFFSET (? * 5) ROWS
FETCH NEXT ? ROWS ONLY
Theoretically, this should run faster than you run all the rows in one data source.
Source code: https://github.com/chanmmn/SSISOFFSETFETCHNEXT
This post shows you the installation of Hadoop in Windows 2016 Server but you might face the warning like I do. If you follow the step of https://muhammadbilalyar.github.io/blogs/How-to-install-Hadoop-on-Window-10/ then you can be successfully setup Hadoop in a Windows Server. Few things you need to watch out.
1. You need to download Hadoop 2.8.0 because you are not able to find 2.10.0 hadoop.dll.
2. I am using latest Java jdk 12, means the path in the article may not be the same as yours as well.
3. Don’t miss hdfs namenode –format else your http://localhost:50070 will not work.
After the installation normally you will to use the Hadoop fs command. I got the warning below that I cannot get rid of.
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.hadoop.security.authentication.util.KerberosUtil (file:/C:/hadoop-2.8.0/share/hadoop/common/lib/hadoop-auth-2.8.0.jar) to method sun.security.krb5.Config.getInstance()
WARNING: Please consider reporting this to the maintainers of org.apache.hadoop.security.authentication.util.KerberosUtil
WARNING: Use –illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
This is not the end. Pig has no update after 2017. You might try Hive. MapReduce is the Java code. So, I am yet to find a way to do the analysis part of it.
This post shows you the tools you can use when migrating your data to Microsoft SQL Server.
Compatibility Certification
What is Azure Database Migration Service?
https://docs.microsoft.com/en-us/azure/dms/dms-overview?WT.mc_id=DP-MVP-36769
Overview of Data Migration Assistant
https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15?WT.mc_id=DP-MVP-36769
Overview of Database Experimentation Assistant
SQL Server Migration Assistant
SQL Server Migration Assistant for MySQL (MySQLToSQL)
