How to rotate videos in Windows for free?

You took a video with your phone but it’s upside down? There are several mobile and desktop apps but it’s tricky to find one that is easy to use and free of charge.

I came across an app called Movie Maker. It gets the job done easily. You can rotate videos 90 degrees at a time.

Here is how to rotate a video in seconds:

Download at Microsoft Store:




Solved: “Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk. The system cannot find the file specified”

You may run into the error below while doing development in Visual Studio:

Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk.Sfc, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.


You are missing SQL Server libraries that connects Visual Studio to SQL Server database. In order to fix this issue, download and install these two packages from the following URL.

  • SharedManagementObjects.msi
  • DB2OLEDBV5_x64.msi


Note: The URL above is for SQL Server 2012. Download libraries for the version you use if it is not 2012 version.

How to fetch data from Active Directory from your .NET application?

By using System.DirectoryServices namespace, you can easily send LDAP queries to your Active Directory and return attribute values.

Make sure that LDAP port is open between your machine and the Active Directory server (Default port is 389 and Global Catalog query port is 3268. You may use another port if it is specified in your DirectoryEntry method)

string displayName = "";
string username = "AD username";

DirectoryEntry oDirectoryEntry = new DirectoryEntry("LDAP://AD-server");
DirectorySearcher oDirectorySearcher=new DirectorySearcher(oDirectoryEntry);

SearchResult oSearchResult = null;

   oDirectorySearcher.Filter = "(&(objectClass=user)(sAMAccountName=" +username+ ")) ";
   oSearchResult = oDirectorySearcher.FindOne();

   if (oSearchResult != null && oSearchResult.Properties.Contains("displayName"))
      displayName = oSearchResult.Properties["displayName"][0].ToString();
catch (Exception ex)
   // Error handling