Implementing LOB Storage in Memory Optimized Tables

Introduction Memory optimized tables do not have off-row or large object (LOB) storage, and the row size is limited to 8060 bytes. Thus, storing large binary or character string values can be done in one of two ways: Split the LOB values into multiple rows Store the LOB values in a regular non-memory optimized (file…


Adventures in TSQL: Using CTEs when performing UPDATE operations

In a recent post I discussed using CTEs for managing ordered DELETE operations. Adventures in TSQL: Using CTEs when performing DELETE operations However CTEs are also useful for ordered UPDATE operations, as I will hopefully show in this post. One of the limitations of UPDATE TOP() statement is that an ORDER BY cannot be specified….


Adventures in TSQL: Using CTEs when performing DELETE operations

In most applications these days there will always be some form of backend database. So hopefully over the coming months I thought it would be a good idea to share some TSQL bits, starting with using Common Table Expressions (CTEs) for managing DELETE operations. It seems in quite a few applications of late there has…


SQL Azure Date and Time Functions derived from the Operating System

Transact-SQL includes a number of date and time functions that have values are derived from the operating system of the computer on which the instance of SQL Server is running. With SQL Azure these functions are all standardised on UTC (as you would expect) so you will receive the same result irrespective of the datacentre…


Introduction to SQL Server StreamInsight

StreamInsight is a platform being released alongside SQL Server 2008 R2 to enable the development of Complex Event Processing (CEP) applications. So what does that mean? If you have something which is giving output as an unbounded data stream (the example shown at PDC09 was a power monitor to a laptop, but this can be…


Ruby on Rails on Windows Azure with SQL Azure

I was recently talking to a customer about the possibility of moving a web site from Linux to Windows Azure. The hosting costs of the application are not excessive, and the customer is happy with the service received. Nevertheless they were very interested in exploring the hosting costs and potential future benefits of the Windows…