Ian Beckett

RSS feed

    Recent posts

    Recent comments

    Archive

    Authors

    Tags

    Categories


    Blogroll

    Download OPML file OPML

    tool for testing web services (such as SQL End Points)

    http://www.soapui.org/

    soapUI; the Web Services Testing tool.

    soapUI is tool for Web Service Testing. With more than 300 000 downloads, it's the most used tool for SOA testing in the world.

    soapUI is Free and Open Source and is used for Inspecting Web Services, Invoking Web Services, Developing Web Services, Web Service Simulation and Web Service Mocking and Functional Testing of Web Services Load Testing of Web Services over HTTP.


    Tags: , , ,
    Categories: SQL 2005
    Posted by ibeckett on Monday, March 31, 2008 5:26 AM
    E-mail | Kick it! | DZone it! | del.icio.us
    Permalink | Comments (0) | Post RSSRSS comment feed

    sliding window partition swapping

    Download:
    http://www.codeplex.com/sql2005partitionmgmt 

    Project Description
    Sliding Window technique is commonly used with partitioned tables to manage large data volumes. It allows efficient loading of new data and archival or removal of the old data. The challenges in a sliding window scenario is to create the staging table(s) correctly for efficient partition SWITCH operations. This utility provides a command line interface to:

    1. Remove all the data from one partition by switching it out to a staging table. It creates the required staging table.
    2. Create a staging table for loading data into a partition. The staging table can be created with or without indexes -- if created without indexes this utility provides a separate command to create appropriate indexes on the staging table, before SWITCHing it into the partitioned table.

    The commands can be invoked from other scripts for end-to-end sliding window scenarios.

    Refer to the attached readme.htm file for more details and command syntax.

    Tags: , ,
    Categories: SQL 2005
    Posted by ibeckett on Monday, March 31, 2008 5:15 AM
    E-mail | Kick it! | DZone it! | del.icio.us
    Permalink | Comments (0) | Post RSSRSS comment feed

    adding http namespaces for end points

    HOWTO: The user '{whatever}' does not have permission to register endpoint '{whatever}' on the specified URL

    Cause: This happens when you try to create an HTTP ENDPOINT in SQL Server 2005 because the SQL Server process lacks permissions to register the endpoint with HTTP.SYS.

    Fix: Issue the following command before executing the CREATE ENDPOINT

    EXEC sp_reserve_http_namespace N'http://{hostname}:{port}/{path}'

    credit: http://sqljunkies.com/WebLog/ktegels/archive/2005/04/14/11616.aspx


    Tags: , ,
    Categories: SQL 2005
    Posted by ibeckett on Monday, March 31, 2008 5:10 AM
    E-mail | Kick it! | DZone it! | del.icio.us
    Permalink | Comments (0) | Post RSSRSS comment feed

    TableDifference version 2.0 released!!

    I just caught this (almost a month late) but TableDifference 2.0 by Alberto Ferrari has been released!  This is a great custom component for SQL 2005 Integration Services.  It is used within a dataflow step and the component accepts two inputs; one for "old" data (the existing table) and another for "new" data (new incoming rows).  The component compares rows from the two streams and provides output paths such as "new", "updated", "deleted", "unchanged", as well as any custom outputs you define. 

     There were a number of bugs in version 1x that have hopefully been resolved in v2. I really look forward to using this tool!

    http://www.sqlbi.eu/ - home of TableDifference SSIS component

     Here is the official annoucement:

    Table Difference 2.0 is ready

    Guys,

    The new version 2.0 of TableDifference is finished and available in the download area.

    The zip file contains both the DLL and complete sources. Moreover, in the sources folder there is a README.DOCX document that explains how to use the new features of the component, so I will not discuss them here.

    Main features are:

    User interfaces completely rewritten and made much more user-friendly
    Ability to disable output flows and/or single columns in the outputs
    Ability to ignore case in string comparisons
    Some speed improvement (haven't tested it carefully but it seems faster. :))
    Have a good download and don't be afraid to ask if something is going wrong.

    Alberto


    Tags: , , ,
    Categories: SQL 2005
    Posted by ibeckett on Monday, March 31, 2008 3:08 AM
    E-mail | Kick it! | DZone it! | del.icio.us
    Permalink | Comments (0) | Post RSSRSS comment feed