MCS UK Solution Development Team

The blog of the UK Solutions Development Team of Microsoft Consulting Services.

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (6 items)