Author Archive

SQL Server 2014 – In Memory OLTP (Project Hekaton)

February 18, 2014

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 […]

Posted in SQL Server | No Comments »

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

April 11, 2013

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 […]

Posted in SQL Server | No Comments »

Determine page number in SSRS 2005/2008

March 30, 2011

This method takes advantage of SQL Server’s new ranking functions and can be used in your SQL Reports to determine the page number in the body of a report and also possibly act upon that information to hide/display columns. Use this method if: You have a preset limit of how many records display on a […]

Tags: , ,
Posted in Reporting Services (SSRS) | 3 Comments »

FTP Task ++

March 30, 2011

FTP Task++ is a free SSIS Task that among other functionality gives you SFTP for SSIS. FTP Task ++ created to overcome both limitations of Microsoft’s stock FTP Task and erroneous behavior specifically with (Unix) non-Windows FTP Servers. What makes FTP Task ++ so special? Native to SSIS Secure FTP (SFTP) and FTP Delete from non-Windows […]

Tags: , , ,
Posted in Integration Services (SSIS) | 29 Comments »

Row Count++

March 30, 2011

RowCount++ is a free SSIS Data Flow component used to natively log record counts processed. RowCount++ comes in handy because logging record counts is not available out of the box. Microsoft’s stock Row Count component in SSIS allows you to save row counts in a variable but doesn’t have the ability to read custom data […]

Tags: ,
Posted in Integration Services (SSIS) | No Comments »

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

March 26, 2011

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 […]

Tags: , , , ,
Posted in SQL Server | 4 Comments »

SQL Server Modeling Services – Quadrant and M Overview

March 24, 2011

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 […]

Tags: ,
Posted in SQL Server | No Comments »