• September 21, 2006 21 Sep'06

    Ownership chaining in SQL Server 2005

    Ownership chains have unique permissions' issues in SQL Server 2005. Understanding their dynamic is important when using one type of object to access another in an environment where different access levels are granted. Contributor Serdar Yegulalp ...  Continue Reading

  • September 19, 2006 19 Sep'06

    Migrating SQL Server 2000 DTS packages to SSIS

    SSIS is more than a replacement for SQL Server 2000's DTS packages. The scale of changes is vast and this SQL Server 2005 ETL platform more powerful. In his tip, contributor Joe Toscano helps make the migration as painless as possible by guiding you...  Continue Reading

  • September 14, 2006 14 Sep'06

    Database backup and restore corruption you haven't considered

    Backups are common practice to minimize data loss. Equally important is scheduled routine maintenance, i.e. integrity checks. These checks ensure no corruption exists in your database on the SQL Server level. Taken a key step further to examine the ...  Continue Reading

  • September 12, 2006 12 Sep'06

    Database security options to protect data in SQL Server

    Encryption and data separation in SQL Server are not easy or cheap methods. But customers want security controls in place to protect their sensitive data. In this tip, contributor Kevin Beaver shares alternative tools and techniques to protect ...  Continue Reading

  • September 12, 2006 12 Sep'06

    Analysis Services 2005 in SQL Server has improved security

    Analysis Services in SQL Sever 2005 has resolved security issues of its predecessor. Challenges are a thing of the past when it comes to administrative permissions, creating member roles and cube processing. In this tip, Contributor Baya ...  Continue Reading

  • September 07, 2006 07 Sep'06

    Stored procedures vs. dynamic SQL: When should you use each?

    Stored procedures and dynamic SQL each have their place in the SQL Server world. You must consider parameters, tables being queried, the number of databases and so forth. In this tip, Serdar Yegulalp maps out the best scenarios for each.  Continue Reading

  • September 05, 2006 05 Sep'06

    SQL Server indexes made handy

    Indexes should be reviewed to ensure prime performance. Weed out valueless indexes in SQL Server, while identifying the best indexes for your application. In this tip learn how to validate and build indexes for best performance.  Continue Reading

  • September 05, 2006 05 Sep'06

    FAQ: SQL Server query errors and explanations

    Queries in SQL Server have many daunting components. To ease the pain of running a query we've compiled a dozen Frequently Asked Questions. Here, our experts address areas including how to fix code errors, speed up queries, show the query navigation...  Continue Reading