Category Archives: SQL Server

Installing Balanced Data Distributor on SQL Server 2008 R2 SP1

Posted on January 25, 2012 by

Edit: This post refers to an older version of the BDD installer. As per JasonH’s comment below, Microsoft has released a new installation package which should hopefully fix the installation bug. It can be found here: http://www.microsoft.com/en-us/download/details.aspx?id=4123 Original post: Microsoft’s Balanced Data … Continue reading →

Posted in Computers and Internet, SQL Server | 12 Comments

Reporting Services Sysprep Resolution

Posted on May 15, 2008 by

Reporting Services 2005 was installed on a virtual machine prior to a sysprep. I received errors from http://localhost/Reports and http://localhost/ReportServer that ultimately indicated that it couldn’t connect to the reporting database. The resolution to this is to run a tool … Continue reading →

Posted in SQL Server | Leave a comment

Excel Connection Manager and Excel Source in Windows x64

Posted on June 29, 2007 by

There is no Microsoft.Jet.OLEDB.4.0 provider for 64 bit Windows editions. If you need to use an Excel Source task or Excel Connection Manager in Integration Services on a 64 bit machine (I’m using Vista Ultimate x64), you will need to … Continue reading →

Posted in SQL Server | Leave a comment

SSIS Lookup Transformation for SQL Server datetime type and DT_DATE

Posted on June 28, 2007 by

How do you perform a Lookup transformation using an input column of type DT_DATE (e.g. from a spreadsheet input) and a SQL Server table column that has the datetime type? Dragging the former onto the latter results in the error … Continue reading →

Posted in SQL Server | 1 Comment

Bugs/Omissions in Visual Studio Team Edition for Database Professionals

Posted on June 28, 2007 by

  I’m using Visual Studio Team Edition for Database Professionals and have spotted a couple of niggles with it. 1) If you rename a foreign key field, the schema compare fails to recognize that it needs to update the foreign … Continue reading →

Posted in SQL Server | Leave a comment

Calculated Measures DisplayFolder

Posted on June 25, 2007 by

In Business Intelligence Studio (AKA Visual Studio 2005), when editing a cube, there is a tab for creating calculations. This tab contains a handy ‘script organizer’ pane showing a list of the names of all your calculations, names sets, etc. … Continue reading →

Posted in SQL Server | 1 Comment

SCOPE_IDENTITY()

Posted on June 21, 2007 by

A technical post for a change. We recently noticed a difference in SQL Server 2005 over 2000 around the use of the SCOPE_IDENTITY function. I’ve been used to "SELECT SCOPE_IDENTITY()" returning INT as its data type, as that was the largest … Continue reading →

Posted in SQL Server | 1 Comment