THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » video   (RSS)
Showing page 2 of 3 (22 total posts)
  • Inequality joins, Asynchronous transformations and Lookups : SSIS

    It is pretty much accepted by SQL Server Integration Services (SSIS) developers that synchronous transformations are generally quicker than asynchronous transformations (for a description of synchronous and asynchronous transformations go read Asynchronous and synchronous data flow components). Notice I said “generally” and not “always”; there are ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 14, 2010
  • SSIS Prehistory video

    I’m currently wasting spending my Easter bank holiday putting together my presentation SSIS Dataflow Performance Tuning for the upcoming SQL Bits conference in London and in doing so I’m researching some old material about how the dataflow actually works. Boring as it is I’ve gotten easily sidelined and have chanced upon an old video on Channel 9 ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 2, 2010
  • Parsing flat files using SSIS : SSIS Nugget

    Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component; I show different ways that you can pull data from ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 24, 2010
  • Destination Adapter Comparison : SSIS Video Nugget

    In this, my latest video nugget, I demonstrate and compare three ways that you can insert data into a SQL Server table from the SSIS DataFlow: OLE DB Destination without Fast Load OLE DB Destination with Fast Load SQL Server Destination The demo peels back the covers to see how these three methods actually ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 2, 2010
  • Outputting data to an XML file : SSIS video nugget

    The last video nugget that I produced seemed to be fairly well received so I thought I would attempt a few more; and indeed, here is the next one. In this video I demonstrate a simple technique for outputting data to an XML file using SSIS’s Script Task. The video is 8m22s long and is embedded below however I’m aware of some problems that we ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 27, 2010
  • Looping over SQL scripts and executing them : SSIS video nugget

    Earlier today while surfing the SSIS forum on MSDN I noticed a question that asked how one could execute a series of .sql files using SSIS. One suggested approach was to read the contents of the file(s) into a variable using a Script Task and then execute the contents of that variable using an Execute SQL Task. Well, that would work but there is ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 24, 2010
  • CozyRoc demonstration videos

    Lately I have been working with software vendor CozyRoc to help them demonstrate their wares to the SSIS community. As part of that work I have produced a series of videos that demonstrate ten of the tasks and components that CozyRoc provide for to help you with your SSIS development. Here is a list of those videos along with links to them on ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 14, 2010
  • Video: SQL Server Data Services Business Value

    A while back I made a blog post about a video describing SQL Server Data Services here: Video: SQL Server Data Services Architecture Channel 9 has posted another SQL Server Data Services video; in this one Group Program Manager Tudor Toma and Architect Soumitra Sengupta talk about the business value of SSDS. You can watch the video here: ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on May 2, 2008
  • Video: SQL Server Data Services Architecture

    SQL Server Technical Evangelist Ryan Dunn sits down and talks turkey with two of the creators of SQL Server Data Services (SSDS), Architect Istvan Cseri and Development Manager Nigel Ellis. Istvan and Nigel dig into how to design applications for SSDS and cover a number of the interesting aspects of working with SSDS in terms of features, design, ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on April 7, 2008
  • 3rd Annual Colorado PASSCamp (w/video!)

    Recently, the three SQL Server user groups in Colorado hosted the third annual Colorado PASSCamp – this year extending the free event to two days. The second day keynote was a rousing panel discussion hosted and video taped by CS TechCast with SQL Server CatTeam guru Kevin Cox, myself and .Net developer Ben Hoelting. This year we had a ...
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on March 25, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement