BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ

Topics

Choose your language

InfoQ Homepage SQL Server 2008 Content on InfoQ

  • 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.

  • MapPoint Add-In For SQL Server Released

    Microsoft released a free MapPoint 2009 Add-In for SQL Server 2008 spatial data. The add-in can be used with MapPoint to build map graphics against queries on SQL Server 2008 spatial geography columns.

  • 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.

  • SQL Server 2008 Major Updates

    Microsoft has released significant updates for SQL Server 2008, including 2008 Service Pack 1, Express Edition Service Pack 1, large Feature Pack, Upgrade Advisor, SRS Report Builder 2.0, SharePoint integration, and data mining Office add-ins.

  • MIX 09: Nigel Ellis on Azure SQL Data Services

    Nigel Ellis, Architect at Microsoft, presented today a detailed overview of the new relational model of Azure SQL Data Service, which was announced a couple of weeks ago on the team's blog. Nigel also demonstrated how SDS could be used by WordPress (a PHP application) via an ODBC driver.

  • 256 Core SQL Server

    With Windows Server 2008 R2 and SQL Server Kilimanjaro, it is expected that SQL Server will be able to support at least 256 logical processors.

  • Performance Problems Mar SQL Server 2008 Full Text Search

    SQL Server Full Ttext Search is a rather specialized discipline among database administrators. For roughly a decade it has been something separate from the rest of SQL Server, and in most cases unnecessary. But for those who do use it, it tends to be core to how data is indexed and retrieved. For those using it and upgrading to SQL Server 2008, trouble is brewing.

  • SQL Server 2008 Report Builder 2.0 RC1 Ready for Download

    Microsoft has released SQL Server 2008 Report Builder 2.0 RC1. The Report Builder has full support for SQL Server 2008 Reporting Services including: various report layouts, data visualizations and formatted text.

  • SQL Server 2008 Express Series Is Available

    Microsoft has made available three versions of SQL Server 2008 Express. Express editions are free versions of SQL Server intended for learning or building small server applications, or for ISV redistribution. The Tools edition contains the Management Studio, while the Advanced Services edition has full-text search and Reporting Services.

  • Table-Valued Parameters in SQL Server

    Table-valued parameters are a new feature introduced in SQL Server 2008. They provide a built-in way to send multiple rows of data from a client application to SQL Server in a single parameterized SQL statement.

  • Sparse Columns, Filtered Indexes, and Column Sets

    Sparse Columns, Filtered Indexes, and Column Sets are new features for SQL Server 2008. While they allow you to break the 1024 limit on columns and save significant disk space, if not used correctly they can be a disaster.

  • SQL Server 2008 Indexing Tips And Tricks

    Bill Vaughn provides a roundup of SQL Server 2008 indexing tips and tricks, based on advice form Kimberly Tripp and Paul Randall. The tips cover Query Optimizer selectivity and query optimization.

  • SQL Server 2008 Feature Pack RTM Is Available

    Microsoft has released SQL Server 2008 Feature Pack August 2008 the same day when SQL Server 2008 was released. Feature Pack is a collection of stand-alone packages, including Analysis Services, Command Line Utilities and many others, which provide additional value to SQL Server 2008.

  • SQL Server 2008 RTM Has Arrived

    After more than a year from its first CTP, SQL Server 2008 has finally been sent to manufacturing yesterday, August 6th, according to a Microsoft Press Release. The server was initially planned to be launched on February 27th, and it comes out almost 6 months later, but it is still in the 2-3 years timeframe, the goal set by Microsoft, from the launch of the previous SQL Server 2005.

  • Microsoft SQL Server 2008 August Release

    Microsoft has unofficially announced that SQL Server 2008 will be released in August, 2008 with no price increase over SQL Server 2005.

BT