Category

Microsoft

• Microsoft, SQL

  Import CSV data into Microsoft SQL 2005 using bulk insert

  05.15.09 | Permalink | 2 Comments

  A little problem I had recently was to import a CSV file with about 16mb of data, into a Microsoft SQL 2005 database, using Microsoft SQL Studio Express. A csv file is a file with data that has “comma seperated values” (CSV) and by using SQL bulk load we can read this file from disk [...]

• Microsoft, SQL

  You do not have permission to use the bulk load statement

  05.09.09 | Permalink | 1 Comment

  I had a problem when trying to bulk load a CSV file into my Microsoft SQL 2005 database. The error was “You do not have permission to use the bulk load statement”. It turned out to be quite a simple solution.
  The solution: It was simply a permission issue and your SQL login needs to be [...]

• Microsoft, SQL

  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 [...]

• Microsoft, SQL

  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 = [...]

• Microsoft, SQL

  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 [...]

• ColdFusion, Google, Microsoft, SEO, XML

  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 [...]

• ColdFusion, Microsoft, XML

  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, ColdFusion, Microsoft, SQL, XML

  SQL Bulk Load with ColdFusion - SQLXMLBulkLoad.SQLXMLBulkLoad

  01.16.08 | Permalink | 1 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 [...]

• Adobe, Flex, Frameworks, Microsoft, Silverlight

  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, Adobe, Ajax, Flex, Microsoft, Silverlight

  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 [...]

Fusion Team Blog