October 2005

  • SQL Server 2005: 10 steps to justify and plan your upgrade

    Your decision to upgrade to SQL Server 2005 may come down to upgrade cost and time versus business improvement and competitive advantage. Edgewood Solutions' Jeremy Kadlec walks you through 10 step...

  • Quiz: Tech or treat!

    Tech or treat! Do you speak Geek? Technology is scary to a lot of people -- and no wonder, when you consider the harrowing terms and concepts involved. Here's our traditionally gruesome collection ...

  • Top 10 new features in SQL Server 2005

    From programming to administrative capabilities, SQL Server 2005 enhances many existing SQL Server 2000 features and goes well beyond. Edgewood Solutions' Jeremy Kadlec shares his SQL Server 2005 t...

  • Will SQL Server 2000 DTS packages work in SQL Server 2005?

    Concerned that your SQL Server 2000 DTS packages may not work in SQL Server 2005? Expert Adam Machanic discusses SQL Server 2005's answer to DTS packages.

  • Debugging SQL Server DTS packages

    Debug SQL Server DTS packages in production environments or risk poor performance and lost data integrity. You should use Dynamic Properties to debug in a QA or test environment first and then prom...

  • Step 3: Implementing your SQL Server backup

    You must have a well-planned and standardized approach to backing up your SQL Servers so you're prepared for the worst-case scenario. Edgewood Solutions' Greg Robidoux offers a three-part guide for...

  • Step 1: Planning your SQL Server backup

    You must have a well-planned and standardized approach to backing up your SQL Servers so you're prepared for the worst-case scenario. Edgewood Solutions' Greg Robidoux offers a three-part guide for...

  • How to properly back up a SQL Server: Step-by-Step Guide

    You must have a well-planned and standardized approach to backing up your SQL Servers so you're prepared for the worst-case scenario. Edgewood Solutions' Greg Robidoux offers a three-part guide for...

  • Step 2: Developing and testing your SQL Server backup

    You must have a well-planned and standardized approach to backing up your SQL Servers so you're prepared for the worst-case scenario. Edgewood Solutions' Greg Robidoux offers a three-part guide for...

  • Identifier field in Microsoft's SQL Server

    Ever wonder how to incorporate an Oracle ROWID or identifier field in Microsoft SQL Server? Monitoring and Administration expert Kevin Kline tells you how in this expert response.

  • Getting scheduled DTS packages to run

    Troubleshooting your DTS packages can be frustrating. In this expert response, Monitoring and Administration expert Kevin Kline discusses why a DTS package may run when executed but not when schedu...

  • CLR stored procedures versus T-SQL stored procedures

    Expert Adam Machanic discusses the performance differences between CLR and T-SQL stored procedures.

  • Stored procedure: Execute T-SQL code from a file

    Need to execute T-SQL code in a file from within other T-SQL code? The sp_ExecuteSQLFromFile stored procedure addresses the shortcomings and adds new functionality.

  • What's new with T-SQL in SQL Server 2005

    When asked what the most valuable new features are in the soon-to-be-released SQL Server 2005, users commonly refer to its T-SQL enhancements. Edgewood Solutions' Jeremy Kadlec explains the signifi...

  • Performance problems after installing Windows Service Pack 4

    If you have installed Windows Service Pack 4 and noticed degradation in performance, Monitoring and Administration expert Kevin Kline offers possible solutions.

  • Use SQLPing to prevent outside access

    Make sure no listening ports are open for public access on your SQL Server machines – or you could be relaying sensitive database information to the outside world.

  • Identifying new user accounts

    Security expert Steven Andres explains the one way you can identify when new user accounts are created.

  • Backup and recovery enhancements in SQL Server 2005

    The backup and restore capabilities of SQL Server 2005 are largely unchanged from SQL Server 2000, but there are several new features worthy of your attention. Edgewood Solutions' Greg Robidoux exp...

  • Improve performance by spreading data

    Monitoring and Administration expert Kevin Kline discusses the possible performance gains or limitations of spreading data across multiple files on the same hard drive.

  • SQL Server's emerging rootkit threat

    No rootkit attacks have been documented against SQL Server to date – but they're coming. Contributor Kevin Beaver explains just how easily a hacker could take control of your database using a...