SQL Server

SQL Server 2014 – In Memory OLTP (Project Hekaton)

Posted by on February 18, 2014 at 3:28 am

Have you been wondering what SQL Server 2014 has in store for you? Memory optimized tables are in, slow running transactions are out! With multi-version optimistic concurrency, a completely new data structure optimized for memory and a brand new set of memory optimized indexes in the form of Hash indexes and Range indexes, SQL Server […]

Real-Time Insights & Complex Event Processing – SQL Server StreamInsight & the Real-Time Web

Posted by on April 11, 2013 at 7:32 pm

Thanks for everyone who attended the Malibu SQL Server User Group The┬áslides are here. I will be posting some of the source code and video if the quality is descent enough. Presentation: Real-Time Insights & Complex Event Processing – SQL Server StreamInsight & the Real-Time Web Discover the power of SQL Server StreamInsight for processing […]

SQL Server Ranking Functions Row_Number(), Rank(), Dense_Rank() and NTIle()

Posted by on March 26, 2011 at 9:28 am

SQL Server 2005 introduced new ranking functions. This article is tailored as an introduction to these functions, difference between them and when to use each and a few examples. Ranking What: The new ranking functions are new internal functions to SQL Server 2005/2008. From MSDN “Ranking functions return a ranking value for each row in […]

SQL Server Modeling Services – Quadrant and M Overview

Posted by on March 24, 2011 at 7:39 am

Last week I was part of an interesting “call” with Microsoft around SQL Server Modeling Services and what it had to offer. The purpose to get client feedback on the proposition and also provide us with some insight on what it was and where it was heading. First let me clarify that SQL Server Modeling […]