Tracking change and innovation in the enterprise software development community
Tools to get
Visual Studio
2008 Projects
Under Control
TargetProcess:
Plan, Track
Succeed with
Agile PM tool.
Free Download!
Testing Tools to
Support Agile
Software Delivery
Whitepaper
Terracotta:
Scale your
Apps w/ease
Offload the DB:
Learn More!
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 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 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.
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.
Visual Studio 2008 SP1 provides increased support for occasionally connected clients through an enhanced DataSet designer, integrating ADO.NET Sync Services and SQL Server 2008 Change Data Capture.
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.
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.
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.
