• August 27, 2007 27 Aug'07

    Podcast: SQL Server high availability options

    SQL Server high availability options include database mirroring, replication and log shipping. In this podcast series, you'll get the basics and best practices for each.  Continue Reading

  • August 27, 2007 27 Aug'07

    Replication techniques in SQL Server

    The following list will educate you on the replication process in SQL Server and also guide you on how to enhance your techniques when replicating your database(s). If you have database servers that must be involved in various types of replication, ...  Continue Reading

  • August 22, 2007 22 Aug'07

    Best SQL Server indexing strategies

    SQL Server supports only two index types for most data types: clustered and non-clustered. Learn how and why building the appropriate index type during your database design will significantly impact SQL Server performance.  Continue Reading

  • August 17, 2007 17 Aug'07

    SQL Server filegroups for backup and restore

    SQL Server filegroups have hundreds of significant uses in your database. What will be your backup and restore strategy for these filegroups? Database administrator Eric Johnson examines filegroup sizes and scenarios and shows you how to optimize ...  Continue Reading

  • August 16, 2007 16 Aug'07

    SQL Server backup and restore school

    In this SQL Server backup and recovery school you'll get overall best practices, learn commands for backup and restore functions and be introduced to SQL Server 2005 features – all via webcasts and podcasts.  Continue Reading

  • August 16, 2007 16 Aug'07

    New T-SQL features in SQL Server 2005

    Have you experienced the new T-SQL features in SQL Server 2005? SQL Server database administrator Eric Johnson outlines four of its hottest development features: error handling, ROW_NUMBER function, DDL triggers and CLR.  Continue Reading

  • August 13, 2007 13 Aug'07

    Creating SQL Server Reporting Services templates

    Tired of creating templates in SQL Server Reporting Services? SQL Server Business Intelligence Development Studio makes it possible to maintain reusable reporting templates in SQL Server 2005.  Continue Reading

  • August 13, 2007 13 Aug'07

    SQL Server business intelligence toolbox

    Deploying optimal Business Intelligence applications in SQL Server 2005 is becoming key to database administrators as the area of BI grows in importance. In this toolbox, we've compiled a handful of tools and expert advice to assist you in areas ...  Continue Reading

  • August 08, 2007 08 Aug'07

    SQL Server patch pros and cons

    Are you afraid to patch your SQL Server systems? Installing a patch can bring your database server down and corrupt data. Yet, unpatched software leaves your system vulnerable to attacks by unruly insiders. IT security specialist Kevin Beaver ...  Continue Reading

  • August 06, 2007 06 Aug'07

    Temporary tables in SQL Server vs. table variables

    Once you've written your T-SQL code, it's time to execute it. You'll most likely need a table in which to store data temporarily. SQL Server database architect Denny Cherry explains your four options while offering the pros and cons of using ...  Continue Reading