InfoQ Homepage SQL Server Content on InfoQ
-
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.
-
Occasionally Connected Client Support With VS 2008 SP1
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.
-
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 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.
-
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.
-
Deprecated and Discontinued Features in SQL Server 2008
Everybody is waiting for the new features coming with Microsoft SQL Server 2008, but there are some deprecated and discontinued features that we should be aware of.
-
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.
-
DbFit 1.0 With Enhanced Querying Capabilities and User Docs
Gojko Adzic has recently announced the version 1.0 release of DbFit, his popular FIT/FitNesse extension used for practicing TDD on database code.
-
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.