InfoQ Homepage SQL Server Content on InfoQ
-
Database Virtualization - Is it worth it?
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.
-
SQL Server Best Practices Analyzer to be Integrated into SQL Server 2008
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.
-
Post-VS 2008-Technology: LINQ to XSD and LINQ to Stored XML
Today, Shyam Pather, Principal Development Lead on the Data Programmability Team at Microsoft, is giving a presentation on LINQ to XML: Visual Studio 2008, Silverlight, and Beyond at the XML 2007 Conference in Boston. He talks about the current and future technologies surrounding LINQ to XML.
-
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.
-
New SQL Server Data Type: HierarchyId
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.
-
Microsoft Ups Their Support for PHP
PHP is a cornerstone of LAMP development. In an attempt to lure PHP developers off Linux and MySQL, Microsoft is beginning to offer deep support for PHP in IIS 7 and SQL Server.
-
PowerShell Scripting Added to SQL Server 2008
Francois Ajenstat has recently announced that SQL Server is the next to pick up PowerShell scripting in the next CTP.
-
New Compression Features in SQL Server 2008
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 is Ready to Go Offline : Introduces Sync Framework
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 on Database Unit Testing
Cory Foy walks developers step-by-step through unit testing logic implemented at the database layer.
-
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.
-
Book Excerpt and Review: Hitchhiker's Guide to Visual Studio and SQL Server
With SQL Server 2000's hitting its end of life date next April, many shops that have been delaying the upgrade to SQL Server 2005 need to start looking at it seriously. This is why we have chosen to review the seventh edition of William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server.
-
Using SSIS in a Team Setting
Jamie Tomson talks about his experiences trying to use SQL Server Integration Services in a team environment.
-
MERGE Syntax for SQL Server 2008
SQL Server 2008 will include new syntax for merging data between two rowsets. The MERGE statement allows developers to use one command to perform deterministic inserts, updates, and deletes on a table based on a source table.