by Johan Meyer | Jun 12, 2014 | Development, SQL Server
While working on a client project we noticed that all string columns has been set to varchar columns on the SQL database. This was a small issue as all columns now contains empty spaces when not used and we wanted to remove white space characters from all columns in...
by Johan Meyer | Feb 14, 2013 | Development, SharePoint, SQL Server
If you ever had the problem where you need to extract files from a SharePoint Content Database or normal SQL Database stored as binary, this post will help you. The script I have included will export all the content from the SharePoint Content Database to the file...
by Johan Meyer | Mar 6, 2012 | .NET, Development, Visual Studio
After upgrading my Visual Studio 2008 to Visual Studio 2010 my server explorer decided to give me the following error. An unexpected error occurred in the .NET framework data provider for Microsoft SQL Server Compact. Please contact the provider vendor to resolve this...