• FAQ: Top 5 SQL Server backup and recovery problems

    Backup and recovery in SQL Server is another one of those 'do or die' areas. We've tallied your page hits and compiled a Top 5 list of frequently asked questions on the topic, so you'd have a quick reference.  Continue Reading

  • Developing CLR database objects: 10 tips, 10 minutes

    The integration of the .NET Framework's Common Language Runtime (CLR) with SQL Server 2005 is arguably the most significant new development featured in the SQL Server 2005 release. In this book excerpt, you'll learn about capabilities to create ...  Continue Reading

  • FAQ: SQL Server comparison features

    In this FAQ, our SQL Server experts answer your questions about comparison features in both SQL Server 2000 and SQL Server 2005. Have you wanted to know which data type to use, nvarchar or varchar when storing character information? Or, are you ...  Continue Reading

  • FAQ: SQL Server passwords

    Troubleshoot SQL Server passwords with these frequently asked questions from our readers. Recover lost passwords, create new passwords and change your SQL Server passwords with this advice from our SQL Server experts.  Continue Reading

  • FAQ: DTS packages in SQL Server

    Since the release of SQL Server 2005, the spotlight has been on SQL Server Integration Services (SSIS) as it is the new and powerful ETL tool (short for extraction, transforming and loading). SSIS is making managing SQL Server data a more customized...  Continue Reading

  • 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