File xxx.ps1 cannot be loaded because running scripts is disabled on this system

This short article shows you how to fix the error “File C:\somePowerScriptFileName.ps1 cannot be loaded because running scripts is disabled on this system”

It is quite simple for this solution. Make sure you run PowerShell as Administration.

Issue the following command:

Set-ExecutionPolicy RemoteSigned

Posted in .Net, Community, Operating System | Tagged , , , | Leave a comment

Setup SharePoint 2016 Development Environment

This short article is showing you how to setup your own SharePoint 2016 Development Environment or some people will call it a development box.

There are other ways to do it of course but below is what I was doing.

1. Install Windows Server 2012 R2.

2. Install SQL Server 2014 with Service Pack 1.

3. Set a static IP v4 address.

4. Add Active Directory Domain Services role.

5. Run SharePoint 2016 PrerequisiteInstaller.exe.

clip_image002

 

clip_image004

clip_image006

6. Run SharePoint 2016 Setup.

clip_image007

7. Select the installation location. Click Install Now.

clip_image008

 

clip_image009

8. Check the Configuration Wizard then Close.

clip_image010

9. Click Next to start.

clip_image011

10 Choose Yes.

clip_image012

11. For me, everything is in a Box so Create a new server farm.

clip_image013

12. This is very important. SharePoint survivor is depending on the MS SQL Server. Type in all the right information before click Next.

clip_image014

13. You can type in any characters but do remember.

clip_image015

14. I only use one box so Single-Server Farm.

clip_image016

After this I will leave everything by default till the completion.

clip_image017

 

 

clip_image018

 

clip_image019

You have completed if you see the screen like the one below.

clip_image020

Now it is time to setup the default Site Collection. Click Start the Wizard.

clip_image022

Type in the Site name that you prefect then click Next.

clip_image024

One the Wizard is done then you can either choose Configure Hybrid Features or Finish. For me, I choose finish to end the setup.

clip_image026

You can now have your SharePoint 2016 running like the one below.

clip_image028

Posted in .Net, Community, Office 365 | Tagged , , , , , | Leave a comment

Advanced Mode to edit html page in SharePoint Designer 2013

This is shorting article to let you know do not go to the Edit tab to look for Advanced Mode in SharePoint Designer 2013.

The simple article can save you minutes and even hours.

You might bump into a link like, SharePoint Designer: Its all about control (http://www.sharethepoint.com/sharepoint-designer-its-all-about-control/) So you see Edit File in Advance Mode, If you have used SharePoint Designer 2010 before, your guess is right. This is not SharePoint Designer 2013.

clip_image002

 

But if you get this link from the forums, https://social.msdn.microsoft.com/Forums/en-US/bb035480-45a0-41ba-bdef-2e7cd709ce77/how-to-enable-sharepoint-designer-2013-advanced-mode-which-is-alwayes-grayed-out?forum=sharepointdevelopment. Looks like the Advanced Mode is in Edit tab.

 

 

clip_image004

No, it is not. The correct place to find the Advanced Mode is in the Home tab in the latest SharePoint Designer 2013 with Service Pack 1 (could be the last version of SharePoint Designer).

clip_image006

Posted in .Net, Community | Tagged , , , | Leave a comment

WINDOWS 10 IT PRO ESSENTIALS – Free ebook

Top 10 Tools for Windows 10

https://blogs.msdn.microsoft.com/microsoft_press/2016/04/26/free-ebook-windows-10-it-pro-essentials-top-10-tools/?MC=CloudPlat&MC=MSAzure&MC=Windows&MC=EntMobile&MC=SecSys

Dive in to Windows 10 with award-winning journalist and Windows Expert Ed Bott in this highly curated free eBook covering the top apps, accessories, and utilities included in the box with Windows 10.

The sheer volume of Windows programs and accessories says a lot about the power and complexity of Windows—a fact that every IT pro knows from firsthand experience. There’s a tool for nearly every task, and a large part of the process of becoming a Windows expert is knowing how to find the appropriate one when you need it.

This eBook contains descriptions and hands-on advice to help IT Pros work faster and smarter. Some of these tools are for everybody—end users and experts alike—whereas some are strictly for professionals. A few are so specialized that you’ll only need them once in a blue moon. Collectively, though, they make up a toolbox that can save you (and your company) time and money.

Posted in .Net, Community, Operating System | Tagged , , , , | Leave a comment

How to Split Date Column using Power Query

This short article shows you now to Split Date Column using Power Query. This short article also assumed you already know Power Query.

This article assumed you already know the basic of Power Query.

If you have a Date / Time column as below.

clip_image002

You want to split it just the column by clicking Split Column and use the character /. Well it would not work for me.

clip_image004

The is what I did.

1.      Right click on the Date / Time column. Select Change Type. Select Date.

clip_image006

2.      Right click on the Date column again. Select Transform. Select Date Only.

clip_image008

3.      Click on Split Column. Select By Delimiter.

 

clip_image010

4.      Select –Custom—in Select or enter delimiter combobox.

5.      Type / as the delimiter and click OK.

clip_image012

You can see the split columns now.

clip_image014

Channel 9 video: https://channel9.msdn.com/Blogs/MVP-Data-Platform/How-to-use-Power-Query-to-Split-Date-Column

Posted in .Net, Community, Microsoft Office | Tagged , , , | 2 Comments

Cannot start Microsoft Office Program like Word

This short article shows you one of the possibilities your Microsoft Office Program such as Word or Excel will not start.

When you start my Word 2016 then I realized there is a message like Office 365 SharePoint hopeless error message that does not tell anything at all beside “Something went wrong”.

clip_image002

The Microsoft Office Click-to-Run Service service could have set to Disable or deleted.

Posted in .Net, Cloud, Community, Microsoft Office | Tagged , , , | Leave a comment

How to deploy On-Premise Microsoft SQL Database to Windows Azure SQL Database

This short article shows you how to move On-Premise Microsoft SQL Database to SQL Azure Database.

In the past we have struggling to restore the database to SQL Azure but unfortunately this is not happening.

Somehow Microsoft added a feature Deploy Database to Windows Azure SQL Database in SQL Management Studio.

To export the On-Premise Microsoft SQL Database to Windows Azure SQL Database, do the following.

1.      Start SQL Management Studio 2014.

2.      Right click on the database that you want to export, for example “NORTHWND (tree item)”.

3.      Select Deploy Database to Windows Azure SQL Database.

clip_image002

4.      Click on “Next > (button)” in “Deploy Database ‘NORTHWND'”.

clip_image004

5.      Click on “Connect… (button)” in “Deploy Database ‘NORTHWND'”.

clip_image006

6.      Type the authentication for your Windows Azure SQL Server.

clip_image008

7.      Select on “S0 (list item)” if you remember the price showing in my previous blog. Click Next.

clip_image010

8.      Review the summary then click on “Finish button)”.

clip_image012 

9.      Click Close when it is done.

 

clip_image014

You can now sign in to your portal and check.

Posted in .Net, Cloud, Community, Servers | Tagged , , , , | Leave a comment