• 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 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 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

    DTS package designed to overwrite extract.xls

    I have a DTS package that produces an output file called extract.xls. Every time the package runs, the output is appended to the extract.xls file. How can I design the DTS package to overwrite or delete the extract.xls file, before the output is ...  Continue Reading

  • February 16, 2007 16 Feb'07

    Delete .bak files automatically with CLR

    I have a query and I want to know if there is a stored procedure, SQL script, or T-SQL script to delete the .bak files, which are older than seven days. I have set up daily backups and after the day seven, the .bak files should purge off. How can I ...  Continue Reading