Author Archives: davidbridge

About davidbridge

I run David Bridge Technology Limited and specialise in Database design and development including administration and web application development using .net

SharePoint startup time very slow

I created a SharePoint Server installation to look after project documentation. All was well and I uploaded all of the specifications, design documents, project plans etc. The following day, when I wanted to show the site to someone important, it … Continue reading

Posted in Developer stuff, Operating Systems, Other stuff | Tagged , , , | Leave a comment

Windows Server 2008 R2 – Full or Server Core

I did not know which to install so I looked around and found this very entertaining and yet informative blog post. I like the fact that the post is attempting to add a humorous and more interesting spin on a … Continue reading

Posted in Developer stuff, Operating Systems | Tagged , , , , | Leave a comment

Sharepoint database connection string – what is it?

I use Team Foundation Server (TFS) for source control of my current data warehouse project with SSIS, SSRS and SSAS but my requirements documents which are mostly word but also Excel, Visio and xMind (Excellent mind mapping diagram software) were … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | 2 Comments

SSAS: Excel Data Connection Wizard missing cube(s)

This gallery contains 1 photo.

Have you got missing cubes in your Excel Data Connection Wizard? A customer noticed this yesterday and had spent all afternoon looking for the issue, rebuilding, deploying, processing, deleting and recreating on the server etc. all to no avail. He … Continue reading

Gallery | Tagged , , , , , , , , , , | Leave a comment

Excel Error: There was a problem sending the command to the program

Excel Error: There was a problem sending the command to the program 15 August 2012 If you click on an excel file and get this error instead of Excel opening your document and you have followed the MS link to … Continue reading

Posted in Developer stuff, Other stuff, SQL Stuff | Tagged , , , , , , , | Leave a comment

SSIS 2008 and SSIS 2008 R2 are the same (or are they?)

SSIS 2008 and SSIS 2008 R2 are the same Well pretty much. One big difference is that the ADO.NET Destination has been upgraded. Trouble is that the upgrade is tiny and SQL Server 2008 is not forwardly compatible. If you … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , | Leave a comment

Viewing cubes when upgrading to SQL Server 2012

This taken from “Behaviour Changes to Analysis Services Features in SQL Server 2012” Cube browser in Management Studio and Cube Designer has been removed The cube browser control that let you drag and drop fields onto a PivotTable structure in … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , | Leave a comment

Extraction from INFORMIX database using SSIS (Data warehouse ETL)

I have a customer for whom I am building a data warehouse solution using SQL server 2008. Source data comes in many forms including SQL Server 2000, SQL Server 2005, flat files (csv), Excel and Informix. SSIS handles connections to … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , , , , , | Leave a comment

A user name and password are being requested by http://localhost:8080. The site says: “XDB”

SSRS no longer working. Damn I got this error a few days ago when trying to connect to my local SQL Server Reporting Services. I only wanted to test some functionality and was annoyed that this prevented me from doing … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , | 2 Comments

IsNull versus COALESCE

Every day I receive emails from specialist interest groups (Mostly SQL Server) with tips, tricks and articles. One of todays emails mentioned a gotcha with the ISNULL function. I read the rather long winded, slightly repetitive and difficult to follow … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , | Leave a comment