Browse by Tags
All Tags »
SQL (
RSS)
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...
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...
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...
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...
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...
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 can open TFS Data Manager, Perform Backup...
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...
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="...
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 [ dbo ] . [ ErrorLog ] ( [ UserName ] , [ ErrorNumber ] , ...
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...
Read the full and original article from Jon Sayce Here In the last post I talked about How To: Create Windows Live Messenger Addin Now let's create SQL Server Management Studio Addin. Start: Let's open Visual Studio and create a new Visual Studio Add-in project. Check the right options for your Addin. After you finish the wizard please add new Setup project. Add Project output -> Primary output and change the output group registration to vsdrpCOM Enter to Registry Editor and add your Addin...
SQL Load Testing Introduction - SQL Load Test This tool generates a Visual Studio 2005/2008 Unit Test from a SQL Server Profiler trace. The tool extracts all the SQL statements and stored procedure calls from the trace and turns them into a single Visual Studio Unit Test, which can then be configured as a Visual Studio Load Test. The tool does not interact with the database itself when it generates the test code and so it can be used “offline”. Requirements: SQL Server 2005 SDK and the SQL Server...