-
Recent Posts
Tweets
- Always good to check up on how Cortana's doing. https://t.co/Xnu3nvKr9e 2 weeks ago
- I've just realised I've been avoiding listening to Django Django (the band) due to a negative association in my hea… twitter.com/i/web/status/1… 3 weeks ago
- A lot of enterprises (a third of those I've worked in) configure "SSL inspection", meaning they decrypt all HTTPS t… twitter.com/i/web/status/1… 3 weeks ago
- Amazon need to employ some AI to get rid of non-answers like this. https://t.co/hIu9LKK5HV 1 month ago
- Valentines sorted https://t.co/qo4iu84Lni 2 months ago
Archives
- March 2021
- January 2021
- September 2014
- June 2014
- January 2014
- May 2012
- January 2012
- November 2011
- September 2011
- June 2011
- March 2011
- August 2010
- July 2010
- April 2010
- November 2009
- October 2009
- September 2009
- August 2009
- March 2009
- February 2009
- July 2008
- May 2008
- March 2008
- February 2008
- January 2008
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- February 2007
- January 2007
- November 2006
- October 2006
- August 2006
- July 2006
- March 2006
- January 2006
- September 2005
- June 2005
- May 2005
- April 2005
Categories
Meta
Category Archives: SQL Server
Installing Balanced Data Distributor on SQL Server 2008 R2 SP1
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
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
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
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
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
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()
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