InfoQ Homepage SQL Server Content on InfoQ
-
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.
-
The Buzz on SQL Server 2008 CTP6
Community Technology Preview 6 has been in developer's hands for almost a month.
-
New File Storage Mechanism for SQL Server
SQL Server was never designed to act as a file system, but many developers use it that way nonetheless. Countless content management systems rely on either shoving large files into blobs or storing filenames. SQL Server 2008 seeks to correct this by introducing a filestream option that can be applied to a varbinary(max) column.
-
Recursive Selects using Common Table Expressions
Relational databases are great for storing most forms of structured data. The most notable exception is recursive data. Tree-like structures, essential for menus, normally require awkward stored procedures to efficiently return. SQL Server 2005 does have an answer though.
-
Table Value Constructors and Compound Assignments for SQL Server 2008
In SQL Server 2008, T-SQL will be getting some welcome enhancements to the syntax itself. Included among these are table value constructors, also known as row constructors, inline variable declaration, and compound assignments.
-
Launch Date set for Visual Studio 2008, SQL Server 2008 and Windows Server 2008
Yesterday Kevin Turner announced the release date of the next versions of Visual Studio, SQL Server Windows Server at the Worldwide Partner Conference in Denver, CO.
-
Sparse Columns Added to SQL Server 2008
SQL Server 2008 has lifted the limit of 1024 columns per table with a new option called "sparse columns". While this seems like its excessive, some developers have been running up against this limit.
-
SQL Server Always-On Solution Review Program
When building a mission critical database, a lot of attention needs to be paid to the hardware. Simply getting the fastest drives isn't enough if those drives cannot be hot swapped or corrupt data whenever the power fails. Fortunately Microsoft has created a program for choosing the correct storage mechanism.