Category

Microsoft

• SQL, Microsoft

  Alter a table that is published under SQL 2005 replication

  06.17.08 | Permalink | Comment?

  Having recently implemented Microsoft SQL 2005 replication for a client, we had a few issues with developers trying to alter schema on the database if the table is under replication. The issue is caused because the Microsoft Visual GUI tools for SQL 2005, tries to drop and recreate the table, which is obviously not acceptable […]

• SQL, Microsoft

  Microsoft SQL 2005 find tables missing primary keys

  06.04.08 | Permalink | Comment?

  I recently setup replication for Microsoft SQL 2005 server for a client and needed to provide a list of tables to the client without primary keys, as these are not transferred in the replication. This script came in very handy so thought I would share.

  SELECT c.name, b.name
  FROM sys.tables b
  INNER JOIN sys.schemas c ON b.schema_id = […]

• SQL, Microsoft

  MS SQL database publishing wizard for Backup and Restore

  02.21.08 | Permalink | Comment?

  I have been looking for a way to back up my MS SQL database that is hosted remotely, so that in the event of switching hosts or needing to restore I have a complete backup of my database. Using SQL Express 2005 this was not possible as you need to backup to a UNC network […]

• Google, XML, SEO, Microsoft, ColdFusion

  Using ColdFusion to Ping Sitemap Services

  02.20.08 | Permalink | 1 Comment

  I have found a great ColdFusion example of how to notify the major 4 search engines when your sitemap changes. The process is know as pinging and the example is provided on Jason Bartholme’s SEO Blog. Worth a look as can be useful for prompting the search engines to come and crawl your site until theri […]

• XML, Microsoft, ColdFusion

  XML RPC using ColdFusion and Microsoft.XMLHTTP COM Object

  02.19.08 | Permalink | 3 Comments

  I had recently been reviewing some documentation on a web based API that was available as an XML RPC. At first I was wondering how to achieve this, but then adapted an ASP example provided into a nice neat ColdFusion implementation. For anybody else with a similar problem of invoking an XML RPC API, the […]

• CFC, XML, SQL, Microsoft, ColdFusion

  SQL Bulk Load with ColdFusion - SQLXMLBulkLoad.SQLXMLBulkLoad

  01.16.08 | Permalink | Comment?

  I thought I would post this to help anybody else who might be struggling with loading large XML files and datasets into Microsoft SQL using ColdFusion.
  Using this technique, you can use a Microsoft COM object called “SQLXMLBulkLoad.SQLXMLBulkLoad”. This is a very fast object that allows you to provide an XML mapping file, the XML file […]

• Frameworks, Adobe, Microsoft, Silverlight, Flex

  Microsoft Silverlight - What’s it all about?

  06.20.07 | Permalink | Comment?

  Microsoft Silverlight
  Microsoft Silverlight is a cross-browser, cross-platform plugin for delivering the next generation of .NET based media experiences and rich interactive applications for the Web. Silverlight offers a flexible programming model that supports JavaScript, .NET, and other languages.Microsoft Silverlight looks like a good challenger to Adobe Integrated Runtime (AIR).
  It will be very interesting to keep […]

• AIR - Apollo, Ajax, Adobe, Microsoft, Silverlight, Flex

  Adobe Air - Formerly Adobe Apollo

  06.19.07 | Permalink | Comment?

  Adobe AIR
  Adobe® AIR™, formerly code-named Apollo, is a cross-operating system runtime that allows developers to use their existing web development skills to build and deploy rich Internet applications to the desktop.
  For web developers this will allow to use tools such as AJAX and Flex to build Rich Internet Applications that run on the desktop! Yes […]

• Adobe, SEO, Microsoft, Silverlight, Flex, Design, ColdFusion

  Welcome to the new Fusion Team Blog

  06.19.07 | Permalink | Comment?

  Welcome to the new Fusion Team blog. As you can tell this blog is still very empty and does not have too much content.
  Over the coming months I will be adding content to this blog about everything Adobe
  Fusion Team specialise in Adobe technologies and have some great experience with Adobe products such as ColdFusion, Photoshop, […]

Fusion Team Blog