blogs.conchango.com

Browse by Tags

• .Net
• .Net 2.0
• Merge Replication
• MSBuild
• RMO
• SQL Server
• SQL Server Integration Services
• SSIS
• Visual Studio 2005 Team Edition for Database Professionals
• VSTDB

• How To: Install SQL 2005 RMO merge applications on Win64 (x64).

  For my current project I have inherited a couple of customized RMO applications. They help to create the merge publication, publication snapshots, subscribers, subscribers snapshot and synchronization sessions. When it became time to use the application Read More... Posted 16 April 2007 11:32 by steve.wright | 0 Comments Filed under: SQL Server, .Net 2.0, SQL Server 2005, .Net, Merge Replication, RMO

• SQL Server 2005 Merge Replication Subscriber unexpectedly deleting during data Synchronisation.

  Within my current project I have been using SQL Server 2005 merge replication. While I have been testing some issues have been raised by our testers and I would like to write about another one of these in particular. Data, which was entered at the subscriber, Read More... Posted 16 April 2007 11:24 by steve.wright | 1 Comments Filed under: SQL Server, SQL Server 2005, Merge Replication

• SQL Server 2005 Merge Replication not replicationing changes to the subscribers

  I have been using SQL Server 2005 merge replication within my current project. It is a centralized Merge push topology using a custom RMO application with over 350 subscribers but that is the subject for another post… While we have been testing Read More... Posted 21 February 2007 19:02 by steve.wright | 0 Comments Filed under: SQL Server, SQL Server 2005, Merge Replication

• MSBuild using SQL Script parameters

  I have been working with MSBuild and the Microsoft.Sdc.Tasks to deploy my current project’s databases. Some of the SQL scripts that are executed within MSBuild need parameters to be set to create the database objects, which the Microsoft.Sdc.Tasks.Sql.Execute Read More... Posted 20 December 2006 10:12 by steve.wright | 0 Comments Filed under: SQL Server, SQL Server 2005, MSBuild

• To Collate or not to Collate

  Collation plays an important role within the database, as it sets out how the SQL Server has to manage string data within storage & queries, yet I don’t script out the collation when scripting out my databases. So why don’t I script out Read More... Posted 20 December 2006 10:08 by steve.wright | 0 Comments Filed under: SQL Server, SQL Server 2005, VSTDB, Visual Studio 2005 Team Edition for Database Professionals

• Dynamic SQL Server ordering without using dynamic SQL.

  For my current project I have a stored procedure that needs to sort data by 1 of 3 columns depending upon the option chosen by the user from the application. This is only the dynamic part of the stored procedure, which also happens to be very complicated, Read More... Posted 14 September 2006 15:55 by steve.wright | 0 Comments Filed under: SQL Server 2005

• Installing SQL Server 2005 Express with Remote Connections.

  I have managed to set-up a SQL Server 2005 Express instance, on a windows-XP machine, with remote connections enable. The actual installation of the SQL Server 2005 express instance was straightforward, but enabling the remote connections was problematic. Read More... Posted 23 March 2006 09:18 by steve.wright | 0 Comments Filed under: SQL Server 2005

• SSIS Changes Database Settings

  I have a SSIS package with a simple data flow task, which takes data from a flat file and loads it to an OLE-DB destination (which is configured to use Native OLE-DB\Native Client). As I ran the package via the command-line I noticed that SSIS made changes Read More... Posted 09 February 2006 14:50 by steve.wright | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS

• SSIS 2005 and Database Snapshots

  I have been looking into the feasibility of using database snapshots as method of rolling back an SSIS package that fails and this is what I found: Creating a database snapshot was not a real problem, there is one issue that you need to be aware of. For Read More... Posted 20 January 2006 13:26 by steve.wright | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS

• Visual Studio Beta and SQL Server 2005 CTP Installs

  Just had a nightmare of an install with the latest CTP version of SQL Server 2005. It all started when I uninstalled Visual Studio 2005 Beta from the pervious CTP (one which you have to use with SQL Server 2005). I uninstall this first as it was the last Read More... Posted 22 April 2005 15:53 by steve.wright | 0 Comments Filed under: SQL Server 2005