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 has released SQL Server 2008 Feature Pack RC0, a collection of stand-alone install packages which bring additional value to SQL Server 2008.
Microsoft has released SQL Server 2008 RC0 to the general public.
Community Technology Preview 6 has been in developer's hands for almost a month.
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 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.
Hosting server applications inside VM images is all the rage today. The ability to quickly move a virtual server from one machine to another as needs change is a big win for IT departments. But can this be applied to heavyweight systems like SQL Server? Conor Cunningham says no.
Microsoft is looking to change how SQL Server is managed by incorporating the SQL Server Best Practices Analyzer into the core of SQL Server 2008. This new feature, known as the Declarative Management Framework, allows for proactive enforcement of database policies.
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.
Tree-like hierarchies has always a problem in relational databases. Microsoft's first attempt at addressing this was in SQL Server 2005 with the implementation of Common Table Expressions. While CTEs work over existing schema, Microsoft has sought a way to treat hierarchies as first-class concepts. To this effect, they have introduced the HierarchId data type in SQL Server 2008.
Francois Ajenstat has recently announced that SQL Server is the next to pick up PowerShell scripting in the next CTP.
SQL Server 2008, code name Katmai, is expected to be released in May. It brings with it a whole host of new features, including several new compression options.
Microsoft introduced their synchronization platform known as the Microsoft Sync Framework. This framework allows developers to create off-line applications, devices and services that will integrate any type of data with any application.
Cory Foy walks developers step-by-step through unit testing logic implemented at the database layer.
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.