Conor vs. SQL Azure Optimizer Hotfix Traceflag 4199

Another question:  Does Windows Azure SQL Database (aka SQL Azure) run with or without the optimizer hotfix traceflag (4199) from normal SQL Server? Answer:  It currently does NOT run with 4199 enabled.  In the future, we may be able to expose something more specific and advanced here.  Customers needing to have this level of control…


Conor vs. SQL Azure Parallel Query

(The official name is Windows Azure SQL Database, but since SQL Database is hard to search for, I included SQL Azure up in the title). One question I got from my recent trip was around query parallelism in WASD/SQL Azure.  Currently WASD does not support parallel queries for user operations.  That’s not a “never” statement,…


Conor vs. SQLBits Spring 2013 Nottingham

(finally done with travel and work stuff long enough to post up my slide deck :)) I could safely say that I have never been introduced by Robin Hood at one of my talks.  I always have so much fun at SQL Bits because they just get how to throw a fun, fun conference.  Thanks…