Cannot pull because there are uncommitted changes. Commit or undo your changes before pulling again

If you are using Visual Studio 2015’s integration with Visual Studio Team Foundation Server, VSTFS for short. You might have run across this issue when using GIT as your repository. We love using GIT over Microsoft’s TFS repository. I have heard from people within the company that their developers prefer GIT and they are doing away with their own TFS. Something to keep in mind.

This issue comes up after you do a fetch and pull or sync;

“Cannot pull because there are uncommitted changes. Commit or undo your changes before pulling again. See the Output window for details.”


  • Go to directory where your project is and right click on the folder
    Git Bash
  • Type ‘git status’
    • this gives you an idea what files are blocking your pull
    • GIT Pull
  • Now uncommit the changes or stash them
  • Type got pull
  • Reload your project and you are back in business
    Reload Project

Excel To SQL Server 2012 Import Error: Microsoft.ACE.OLEDB Provider Error

I ran into this problem when trying to import an excel spreadsheet into a Microsoft 2012 SQL Server. It was a new instance and not much was installed on it. It didn’t know what to do with the excel spreadsheet.


I got the following error:
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine (System Data)

'Microsoft.ACE.OLEDB.12.0' provider error

The solution was easy. All you need to do is download and install the following file from Microsoft.

Microsoft Access Database Engine 2010 Redistributable

Microsoft Access Database Engine 2010 Redistributable

Download the regular exe, not the 64-bit version. The SQL server was a 64-bit version, I installed it but did not work.


Once you install the code you should be able to import the file. No need for a server reboot.


How To Fix Dogecoin Wallet Stuck, Not Syncing, Much Problem

With the recent increase in Dogecoin price. I wanted to see how my wallet was doing. It has been over 2 years since it has been synced to the network. After lots of reading in the Dogecoin subreddit, I finally found a solution that worked.

Some of the error messages I ran across while trying to get my dogecoin wallet working again.

  • no block source available
  • ERROR: AcceptToMemoryPool: non-final
  • peer=4 using obsolete version 70002; disconnecting

I was getting stuck on a certain block number. I would let in run for 24hrs and it would do nothing. I tried to fix this issue attacking it from all angles.

Steps I used to fix the issue;

  1. Update your wallet to the latest version. As of this writing, it is 1.10
  2. Download the latest Dogecoin bootstrap file. This can take an hour to download.
  3. Go to C:\Users\[username]\AppData\Roaming\DogeCoin\ and back up the wallet.dat file and blocks and chainstate folders. Just to be safe.
  4. In C:\Users\[username]\AppData\Roaming\DogeCoin\ and delete the blocks and chainstate folders
  5. Follow these instructions on the Bootstrap for Dogecoin website
  6. Start the Dogecoin Wallet… and wait… and wait.

Simple Way To Remove Special Characters From C# String

One of our clients has an ASP.Net C# application that pulls string data from another source. The text it is using is usually copy and pasted by the user. Doing this seems fine on the surface and fine from the users perspective but could prove problematic for developers.

Sometimes when someone copies from Microsoft Word or another text source. Hidden characters come along with it. Even though you don’t see them initially. When the text displays on the application they can appear as ? or a small dot. This confuses the user and anyone looking at the site.

He is some code we used to ‘clean up’ copy and pasted text by removing the hidden characters. Use this c# string to remove all special characters.


markup = Regex.Replace(markup, @"<[^>]+>|&nbsp;", "").Trim();
markup = Regex.Replace(markup, @"[^\u0020-\u007F]", String.Empty);

The Best Office 365 Plan For Your Business

In today’s business world, leaders need technology to gain an edge over competitors and to unleash the potential of their employees. Without technology in your business, you will surely lose revenue to your competitors. There are dozens of companies out there offering technology solutions for your business, but how can you be sure which one will have the best quality for the best price? There is a simple answer to this question: Office 365 for business. Office 365 has been the leader in providing technology to business for decades. Here are the plans they provide and some general information so that you can decide which one is right for your business. Please be reminded that for the price per month it is the price per user. So if you want ten employees to have the features, multiply the price per number by 10.

E1 Is For The Small Business

E1 provides the basis for your business such as emails/calendars/ online meetings, file storage, and Skype. This is the most basic plan costing $8 a month with a yearly commitment. This plan provides great assets for a business that might not have a big budget or for start-up companies that need to watch how they spend their cash. With this plan, employees will be able to communicate with each other much easier and have a lot of new ways to complete their tasks. One drawback with this plan is that it does not provide applications like word and excel. This plan is perfect for a business that does not have many employees or one that needs to watch their cash because they are on a strict budget.

ProPlus Is For The Business That Needs Applications

The ProPlus plan has all the great features of the E1 plan but with popular applications such as Word and Excel. ProPlus is the E1 plan, but with the wonderful applications, Microsoft provides. These applications are great tools for your employees to get work done and to complete presentations. This plan is priced at $12 a month for a year commitment which makes it only slightly more expensive than the E1 plan, but with so many features and applications that can make your business leap forward in gaining revenue. Another great feature about the ProPlus plan is that it can go across all devices and computers so that if one of your employees writes a report on Word another employee can easily access that report on a device. This makes it even easier to be able for the company to share information that will enhance productivity which will enhance revenue over the long term.

E3 Is For The Business That Needs Advanced Data Management

E3 is a big leap from the previous two plans, both in features and in price. At $20 a month for a yearly commitment, you gain all the previous great benefits listed in the two previous plans with some new features such as data loss prevention, workflow automation, and mobile/app development. This plan is really geared towards companies that need a much more higher technical advantage and for companies that are big in size that need a lot of data managed. With this plan, you are gaining a lot more data management geared benefits and features. With data management, instead of relying on a person to mounted your business data, allow Microsoft to do it for you.

E4 Is For Big Business

E4 is the biggest plan you can buy from Office 365 for business. Pricing is at $35 a month for yearly commitment and has all the great features of the previous plans but with voice capabilities, advanced security, and analytics. This really is for the big business that needs everything that Microsoft offers. This plan is great for providing security for your data, and ways to analyze their data quickly. One thing that might be considered bad about this plan is that it is a very big price leap from the previous plans. For the big price, you do not gain much from this plan unless you are in a big company that needs these advanced features.

With business, you need the best technology to be ahead of your competitors. Microsoft Office 365 for business does just that and more. With each plan, your company can find a price and a set of features that are required in the day to day work of your company. As technology evolves your business needs to evolve too. Feel free to go to the official Microsoft website to check out the plans and to decide which one is right for your business today.

How to Delete All Items From Sharepoint List Using Powershell

When we do a lot of SharePoint consultant work. We need to clear out what we worked on and try it again. Especially if we are doing any kind of SharePoint migration. In this example, we use a Powershell command to delete all the items from SharePoint list programmatically. No manual work is required. Give it a try

[System.Reflection.Assembly]::Load("Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
[System.Reflection.Assembly]::Load("Microsoft.SharePoint.Portal, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
[System.Reflection.Assembly]::Load("Microsoft.SharePoint.Publishing, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
[System.Reflection.Assembly]::Load("System.Web, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")
# "Enter the site URL here"
$site = new-object Microsoft.SharePoint.SPSite ( $SITEURL )
$web = $site.OpenWeb()
"Web is : " + $web.Title
# Enter name of the List below
$oList = $web.Lists["Posts"];
"List is :" + $oList.Title + " with item count " + $oList.ItemCount
$collListItems = $oList.Items;
$count = $collListItems.Count – 1
for($intIndex = $count; $intIndex -gt -1; $intIndex--)
"Deleting : " + $intIndex

Save this code as a .ps1 file and run it in SharePoint Powershell and you are go to go.

If you have any questions or comments please leave them in the comments section below.

We are always available to help your business with any SharePoint consultant work. If you are interested in learning more please contact us here.


Benefits Of Net Neutrality, Why You Should Care About It

Net neutrality has been an ongoing topic of debate since the earliest days of the internet, but it’s become an even more hotly debated issue in recent years. But what exactly is neutrality, and why should you care about whether or not the internet remains a neutral place or not?

What is It?
First, a net neutrality definition. Neutrality is the idea that each and every user on the internet has equal rights to access and use services from any website on the internet. Your internet service provider, which provides and controls your device’s access to the internet, cannot block or impede the services, applications or websites you use on the web.

It also prevents broadband internet providers from playing favorites—that is, creating “fast lanes” that force content-providing companies like Hulu or Netflix from having to pay additional fees to allow their customers to access their content at full speed. Companies that pay these fees to internet service providers would have preferential treatment and full broadband speeds while companies who don’t pay the fees would have their customers’ internet speeds limited, making streaming content much slower as a penalty.

What Would Happen if Net Neutrality Disappeared?

If neutrality were to disappear completely, the internet would be the wild west—companies like Comcast could decide to block websites like Netflix altogether unless Netflix paid licensing fees to Comcast. What this means, in a nutshell, is that your internet service provider would be able to block or hinder you (through slower speeds) from accessing any website on the internet, even lawful websites, simply because those sites have not paid up.

This “pay to play” system is a toxic one, and would irreparably damage the freedom of information that the internet currently provides.

Why Should you Care About Net Neutrality?

Here are a few reasons why you should care about net neutrality:

  • It doesn’t matter whether you use a tablet, a cell phone, a laptop or computer to access the internet—if you use the web, web neutrality will impact you, and in a big way.
  • If broadband providers have their way, they will be able to demand a “toll” from websites that you access every day. Let’s use Netflix as an example. If YouTube is forced to pay a toll to Verizon, Comcast, and other broadband providers, YouTube will then have to raise its subscription rates and increase advertisements, and the additional cost will be passed onto you.
  • These broadband companies will get monthly fees from you, and in addition, they will then charge fees to websites on the other end. Basically, they’re double-dipping, and the one who loses is ultimately you, the internet user.
  • I’ve mentioned large companies like Netflix and Hulu and YouTube, but what about smaller websites? If your favorite blog or website is forced to pay fees to Comcast, Verizon, AT&T and other ISPs, you will begin to see these sites disappear for lack of funds. They will be, essentially, priced out of the market. Keeping these sites around is one of the major benefits of net neutrality.
  • Freedom of speech may come under fire. What if I had a blog and said: “I hate AT&T and Comcast, they are terrible companies.” There would be nothing to stop those companies from blacklisting my blog and preventing their customers from accessing it, and I would have no recourse. The internet becomes North Korea, essentially, where freedom no longer exists and is replaced with a group of corporate dictatorships.
  • Without net neutrality, prepare yourself for a world in which Google searches bring up a list of websites that you may or may not be able to access, depending on your broadband provider. Click on the top search result and you’ll see “this website blocked by Comcast” because they haven’t paid Comcast’s fee. Doesn’t seem appealing, does it?

The reason web neutrality is under fire in the first place? It isn’t so much about censorship as it is about money. For years, customers had to pay for channels they did not want, allowing television stations to provide garbage to its customers.

Now, with people “cutting the cord” and abandoning cable television in droves, these companies are hemorrhaging subscribers—the old business model is broken, and they’re looking to pick up the slack through the elimination of neutrality.

There are pros and cons of net neutrality, but if you use the internet on any device, you should take a great interest in net neutrality.

1 2 3 14