SQL Server 2012 RC0 Released

The first release candidate of SQL Server 2012, formerly called Denali, has been released.  Though Microsoft notes several changes from CTP3 in terms of reliability and efficiency, there have been almost no changes since CTP3 to the database engine’s syntax.  … Read More

Using Date Functions in SQL Server Denali

Previously, we discussed the SQL Server 2008 data types for storing dates and times.  Today, we would like to discuss the new date-related functions added to SQL Server Denali, the upcoming version of SQL Server which is currently in the … Read More

Storing Unstructured Content in SQL Server

One of the questions that gives engineers heartburn is the question of how to store unstructured content for their application.  When we speak of “unstructured content”, we are talking about text, HTML, images, Word docs, etc.  Unstructured content may be … Read More

SQL Server Denali – Sequences

The latest installment of Microsoft’s SQL Server database management system, codenamed Denali, is in the community technology preview stage, where it is available to developers for review :: http://blog.jasedigitalmedia.com/index.php/2011/01/12/sql-server-denali-sequences :: Among the numerous new features of what will presumably eventually … Read More

SQL Server Denali – Query Paging

Recently, we wrote about a new feature of SQL Server Denali called sequences.  (Denali is the code name for the next version of Microsoft SQL Server.  No release date has been announced, but it will presumably be released late this … Read More

SQL Server Denali – Sequences

The latest installment of Microsoft’s SQL Server database management system, codenamed Denali, is in the community technology preview stage, where it is available to developers for review. Among the numerous new features of what will presumably eventually become SQL Server … Read More