• February 23, 2007 23 Feb'07

    CASE statements now supported by MDX script in SQL Server 2005

    MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language.  Continue Reading

  • February 23, 2007 23 Feb'07

    T-SQL in SSIS: The power and the weaknesses

    Using T-SQL vs. the Data Flow task in SQL Server Integration Services (SSIS) is a decision dependent on a number of factors. Serdar Yegulalp shares some things to consider, including data origin, operation complexity and stored procedure purpose.  Continue Reading

  • February 21, 2007 21 Feb'07

    Top 5 SQL Server query tips

    SQL Server queries should guide you toward successful, trouble-free data retrieval. Our SQL Server experts have written tips on troubleshooting queries, to tips on how to run queries in Analysis Services.  Continue Reading

  • February 21, 2007 21 Feb'07

    SQL Server .VHD trial editions that impress

    Virtualization in Microsoft Windows has made it possible to create SQL Server trial versions in the form of standalone virtual machines. These are distributed in Microsoft's Virtual Hard Drive or .VHD format. Serdar Yegulalp shares the unique ...  Continue Reading

  • February 19, 2007 19 Feb'07

    SQL Server 2005 backup and recovery: 5 handy tips

    Backup and recovery with SQL Server 2005 include several new features worthy of your attention. These features include database mirroring and database snapshots, which have been hailed as "gems" in terms of overall new features. Below, you'll find ...  Continue Reading

  • February 16, 2007 16 Feb'07

    Update table rows in SQL Server 2000

    How can I update the first row of a group? I have a table like this structure: col1 col2 1 row1 * 2 row1 3 row1 4 row2 * 5 row2 6 row2 I want to update the col1 field of the record with *. ...  Continue Reading

  • February 16, 2007 16 Feb'07

    Calling a stored procedure remotely

    I'm using an ASP (Active Server Page) to call a stored procedure on a remote SQL Server. It's not executing, instead it's stalling. When my Web server and SQL Server are on the same machine I don't have this problem. What step am I missing to get ...  Continue Reading