SharePoint API – Download \ Upload Documents (Tool)

Thursday, October 27, 2011

Tweet A long time ago I wrote about SharePoint 2007 Files Restore Tool, tool that allows you to connect to SharePoint content database (not need to have SharePoint installation) and extract documents. The reason I wrote this tool was a customer that upgrade TFS and perform a new installation of SharePoint so he lost all his documents, this tool helped me to extract all documents and added them to the new SharePoint site. SharePoint upgrade/migration can be unpleasant and sometimes I prefer to do a clean installation when upgrading or moving TFS and then just import the documents...

Cannot Create Database Project – Cannot load file or assembly "Microsoft.SqlServer.Management.SqlParser"

Friday, July 22, 2011

CodeProject Couple of days ago I’ve format my computer, a fresh start . Today I tried to open a Database project I’m working on and I got the following error message:   Of course I’ve installed SQL 2008 + with Management Studio and all the other things coming with Visual Studio 2010, but I did make some changes to the 2008 R2 installation… I wanted to remove the Default SQL Express coming with Visual Studio and install the complete suite. During this process I’ve removed several SQL installations from my machine and this what cause the problem, the SQL Management is working just fine...

Create OLAP Failed – XML parsing failed at line 1, column 0: A document must contain exactly one root element.

Tuesday, December 8, 2009

Create OLAP Failed – XML parsing failed at line 1, column 0: A document must contain exactly one root element. I’ve visit one of my customers and saw a strange error in the event log: Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TfsWarehouse.0.db\Today.886.dim.xml'. Detailed Message: Create OLAP failed Exception Message: XML parsing failed at line 1, column 0: A document must contain exactly one root element. ...

Cannot open database "TfsWarehouse" requested by the login

Thursday, June 25, 2009

Cannot open database "TfsWarehouse" requested by the login I Installed TFS 2008 on Server 2008 with SQL 2008, everything during the installation went fine except the reports. When I tried to process the cube using SSMS I got the following error: Detailed Message: Cube processing runtime error: \r\nMicrosoft.AnalysisServices.OperationException: Internal error: The operation terminated unsuccessfully.Internal error: The operation terminated unsuccessfully.OLE DB error: OLE DB or ODBC error: Cannot open database "TfsWarehouse" requested by the login. The login failed.; 42000.Errors in the high-level relational engine. A connection could not be made to the data source...

Some Team Foundation Server 2008 Reports give errors with SQL Server 2008

Thursday, April 16, 2009

Some Team Foundation Server 2008 Reports give errors with SQL Server 2008 Some reports will generate errors, when no errors occur with the same reports if used against SQL Server 2005. Depending on the specific data available for the report, and parameters selected, you may see errors similar to the following. You may also see some variations of these error messages, or see errors listed under a reports below when viewing other reports. The full error information will appear only if viewing the reports directly on the SQL...

Working With TFS Data Manager

Monday, November 3, 2008

Working With TFS Data Manager In the post I talked about Disaster Recovery for VSTS 2008 and now I will show how to work with TFS Data Manager. Every one can download the trial version and check for your self Download Page After downloading (9.5mb) the install is very simple. Choose the backup location, make sure you have al least 800mb , basiclly it’s like SQL backup. Select your Team System database and proper User & Password After the installation you...

Disaster Recovery for VSTS 2008

  Disaster Recovery for VSTS 2008 Team System has become the kernel for many companies, We all know that we can Backing Up a Team Foundation Server database using simple maintance plan in the database, but is it enough? What is TFS Data Manager? At its core, TFS Data Manager provides Disaster Recovery for VSTS 2008, specifically Team Foundation Server. This includes backing up and restoring an entire TFS server, individual Team Projects, or Entities, such as Work Items, Reports, Source Code, Builds, Documents and a project's Web Portal. In addition to critical Disaster Recovery, TFS Data Manager also provides broader Data Management...

How To Connect SQL 6.5 Database With .NET

Sunday, October 5, 2008

How To Connect SQL 6.5 Database With .NET Today I started working on a Migration tool between PVCS Tracker and TFS. During the debug I had a problem with the SqlConnection with the PVCS DB.I trying couple of thing to fix the problem but nothing, then I check the DB version and saw that it's 6.5 DB. SqlConnection is only fits for 7.0 and later, so I had to use OLE DataTable OLEDataReader = new DataTable(); OleDbConnection sqlconn = new OleDbConnection("Provider=sqloledb;Data Source=" + SQLSERVER + "; ...
no comments

How To: Create DB Unit Test With Team System

Thursday, September 11, 2008

How To: Create DB Unit Test With Team System In my last post I talked about What Is Database Unit Testing and Why? , in this post I'll show how to create DB Unit Test. Building on the AdventureWorks sample project from VSTSRTM08-V7 VPC, I'll unit test a modified version of the uspLogError stored procedure. --Removed the error check IF @dbVersion = '9.04.10.13.00' BEGIN IF ERROR_NUMBER() IS NULL RETURN; END ... INSERT . ( , , ...
one comment

What Is Database Unit Testing and Why?

What Is Database Unit Testing and Why? Unit testing is a well-understood concept in application development, but the database community has not yet embraced the advantages and strategies of this approach. Therefore, I'd like to start by exploring the fundamental tenets of the unit-testing methodology. Unit testing provides a structured and automated way of testing individual components of a system. Unit tests are most often authored by the developer of the component that is being tested. Each unit test tests a specific module of the code in an isolated fashion to ensure that the component behaves as expected....
no comments