InfoQ Homepage SQL Server 2008 Content on InfoQ
-
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.
-
SQL Server PowerShell Extensions
PowerShell is quite possibly going to be the most important language for Windows administrators over the next few years. This is all the more evident when you look at the extensive PowerShell support being added to Microsoft server products such as SQL Server.
-
Microsoft SQL Server 2008 Feature Pack RC0 Available for Download
Microsoft has released SQL Server 2008 Feature Pack RC0, a collection of stand-alone install packages which bring additional value to SQL Server 2008.
-
SQL Server 2008 RC0 Has Been Released to the Public
Microsoft has released SQL Server 2008 RC0 to the general public.
-
The Buzz on SQL Server 2008 CTP6
Community Technology Preview 6 has been in developer's hands for almost a month.
-
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.
-
Microsoft Claims to Hold the ETL Record at 1 TB in 30 Minutes
Microsoft and Unisys are claiming that they hold the record for loading information into a relational database. The unofficial benchmark was 1 TB of TPC-H data moved in under 30 minutes using an Extract, Transform, and Load (ETL) tool. The previous record for that volume was 45 minutes and was held by Informatica.