Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ


Choose your language

InfoQ Homepage SQL Server 2005 Content on InfoQ

  • SQL Server 2005 is No Longer Receiving Security Updates

    SQL Server 2005 has now officially hit its end of life. This means that it will no longer receive security updates and new vulnerabilities that are discovered will go unfixed. Yet a recent survey commissioned by Microsoft showed that 46% of companies using SQL Server had at least one production machine running SQL Server 2005.

  • SQL Server Unit Testing with tSQLt

    tSQLt is a free, open-source framework for unit testing in SQL Server. By writing tSQLt test cases, developers can create fake tables and views based on production data, then compare expected versus actual results. Tests can be created directly in SQL Server Management Studio.

  • MVP Erland Explores SQL Server Performance Concepts

    In "Slow in the Application, Fast in SSMS?", SQL Server MVP, Erland Sommarskog, explores the various things that affect Query Plan, compilation of Dynamic SQL and other things that ultimately affect your SQL Server Database Performance. He covers various concepts and scenarios like parameter sniffing, query plan caching, Blocking, saved settings, issues with linked servers and more.

  • Migrating from MySQL/Access to SQL Server/Azure with SSMA

    Microsoft has released the SQL Server Migration Assistant (SSMA) for MySQL 1.0, and has refreshed SSMA for Oracle v4.2, SSMA for Sybase v4.2, and SSMA for Access v4.2. These toolkits helps customers migrating their MySQL/Oracle/Sybase/Access databases to SQL Server and some even to SQL Azure.

  • Microsoft is Making a Play for MySQL Users

    Microsoft has released its first community tech preview for a MySQL to SQL Server migration tool. This tool supports SQL Server 2005, 2008, and Azure.

  • SQLAzureMW Migrates SQL Databases to SQL Azure

    The SQL Azure Migration Wizard (SQLAzureMW) is a CodePlex project and wizard that can be used to migrate SQL 2005 and SQL 2008 databases to SQL Azure.

  • SQL Enlight T-SQL Analyzer

    SQL Enlight is a tool designed to expedite and facilitate T-SQL development through code analysis and templating. SQL Enlight integrates into MS Visual Studio and SQL Management Studio.

  • Amazon's EC2 Switches from Beta to Production

    Amazon's EC2 services are no longer offered as beta, but they have been switched into production, Amazon offering a Service Level Agreement (SLA). Windows on EC2 is still available as beta.

  • Microsoft SQL Server 2005 Driver for PHP Released

    Version 1.0 of the Microsoft SQL Server 2005 Driver for PHP has been released, allowing greater interoperability between PHP and MS SQL 2005. The driver is available for download on MSDN, and the source code for the driver is available on Code Plex.

  • Implementing NOLOCK with LINQ to SQL and LINQ to Entities

    Scott Hanselman recently posted a really useful article on his blog covering the NOLOCK hint when using LINQ to SQL and LINQ to Entities. The problem is actually how to get the SQL generated by LINQ queries to use the NOLOCK hint as SQL developers are accustomed.

  • SQL Server Data Services: Microsoft's Answer to Amazon S3

    Microsoft has announced SQL Server Data Services (SSDS) at MIX08. Being a storage service on the web, SSDS is Microsoft's Amazon S3 competitor.

  • Database Virtualization - Is it worth it?

    Hosting server applications inside VM images is all the rage today. The ability to quickly move a virtual server from one machine to another as needs change is a big win for IT departments. But can this be applied to heavyweight systems like SQL Server? Conor Cunningham says no.

  • SQL Server Best Practices Analyzer to be Integrated into SQL Server 2008

    Microsoft is looking to change how SQL Server is managed by incorporating the SQL Server Best Practices Analyzer into the core of SQL Server 2008. This new feature, known as the Declarative Management Framework, allows for proactive enforcement of database policies.

  • Post-VS 2008-Technology: LINQ to XSD and LINQ to Stored XML

    Today, Shyam Pather, Principal Development Lead on the Data Programmability Team at Microsoft, is giving a presentation on LINQ to XML: Visual Studio 2008, Silverlight, and Beyond at the XML 2007 Conference in Boston. He talks about the current and future technologies surrounding LINQ to XML.

  • Microsoft Ups Their Support for PHP

    PHP is a cornerstone of LAMP development. In an attempt to lure PHP developers off Linux and MySQL, Microsoft is beginning to offer deep support for PHP in IIS 7 and SQL Server.