An application generated sequential GUID

Recently one of our development teams implemented a GUID based on this SqlGuid Structure. Initially I did not give much thought to the implementation, however later during a code review, noting the choice of uniqueidentifier as the primary key, I began to join the dots. Clearly this is meant to be sequentially generated, and leaving […]

CISCO VPN Client dropping with “Reason 422: Lost contact with the security gateway”

Writing this out of embarrassment but hopefully it will help somebody else if they have the same issue with the CISCO VPN Client or similar. When at my girlfriends I VPN over her WiFi into my client, that’s always worked, but, last Thurs/Friday I started getting issues with the VPN dropping out after just a […]

Entity Attribute Value (EAV) data model meets SQL Server Clustered Columnstore for dramatic performance improvement (Part #1)

<sarcasm>Want to have complete flexibility adding/removing attributes without DDL, store all your data in a single database table and still have performance then read on….</> It’s often the complaint of developers they can’t easily adjust the data model and add more attributes to it (columns), rightly or wrongly it happens and it’s a legitimate requirement. Ordinarily data […]

SQL Server Version Upgrade – Don’t follow the myth of migrating to the previous version!

I thought I’d put out some thoughts around why I think people who’d rather migrate to or start a project afresh with SQL Server [Previous] are potentially costing themselves a lot of pain, resource and thus cash in the longer term. I’ve been working with SQL Server and Windows since the very early days – […]

NUMA remote (foreign) memory access overhead on Windows, SQL Server and In-Memory OLTP

In NUMA (Non-Uniform Memory Access), processors in the same physical location are grouped in a node which has its own local node memory. In a NUMA based system, there will be more than one such node and these nodes will use a shared interconnect mechanism to transfer data between them. In such a case, a […]

Non use of persisted data – Part Three

A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those columns) are not used (Part1, Part2). Recently I was drawn into an issue where the same thing was happening, a persisted computed column had been created with an index, but neither were being used when […]

Northdoor PLC Welcomes their SQL Server Technology Evangelist

I have the enormous pleasure of announcing that I’ve now joined Northdoor PLC www.northdoor.co.uk as their SQL Server Technology Evangelist, our office is centrally located in London It is exciting to be working with their existing team, and to bring along my own experiences and SQL Server knowledge to add to the mix, I will be primarily responsible for leading and developing […]

Partitioning

One of my favourite features I’ve been recently presenting on covers the practical usage of partitioning “Effective Index Partitioning & Compression Strategies” We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression, we can […]

SQL Relay 2014

SQLRelay 2014 – Unlock insights on any data We’re bringing SQL Server to a town near you Join us for our analytics focused, FREE all-day conference With some of the best speakers in the world! With a track dedicated to the SQL Server engine we’re helping you ensure maximum stability, availability and potential for your […]

BA Conference

MDS and DQS – Beyond the TLAs to Data Quality Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality. High data […]