Conor vs. SQL

Conor vs. SQL Azure Parallel Query

2013-05-24T15:27:53Z

(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, more of a “right now” statement. The initial model for databases in WASD focuses primarily on OLTP queries (which rarely if ever need to be parallel unless something...(read more)

Conor vs. SQLBits Spring 2013 Nottingham

2013-05-24T15:19:13Z

(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 to the crew who run it, as always, for being such wonderful hosts and allowing me to speak there. For those who are interested, the slide deck from my talk is here: Architecting Large Scale Services on SQL Azure...(read more)

Conor vs. SQL Injection

2013-04-11T21:14:51Z

While I was at SQL Intersection yesterday, I was asked if Microsoft has any best practice guidance on avoiding SQL Injection attacks. I asked around a bit and, sure enough, yes we do. Best Practice Guidance on SQL Injection Proections...(read more)

Conor vs. Spring 2013 Conference Schedule

2013-02-10T14:36:03Z

Hello all, I will be speaking at the following public conferences this Spring: 1. SQLIntersection 2013, Las Vegas – week of April 7th. ( http://www.sqlintersection.com/ ) 2. SQLBits Spring 2013, Nottingham, UK – week of May 2nd ( http://sqlbits.com/ ) For those interested in hearing about some of the new technologies coming from Microsoft, please feel free to register for one of those events. I hope to see you there! Conor...(read more)

Conor vs. Azure Architecture

2013-01-15T23:16:46Z

FYI – we just posted a white paper that covers some of the “how to think about Windows Azure SQL Database architecture” learning we have had while working with customers making transitions to the cloud from existing, on-premise SQL Server solutions. http://msdn.microsoft.com/en-us/library/windowsazure/jj879332.aspx Enjoy! Conor...(read more)

New SQL Azure Features

2012-09-19T22:34:57Z

FYI, we announced new features on SQL Azure today, including SQL Azure as a distributed query target for SQL Server: http://blogs.msdn.com/b/windowsazure/archive/2012/09/19/announcing-updates-to-windows-azure-sql-database.aspx...(read more)

Conor vs. SQLRally Nordic 2012

2012-08-23T22:06:16Z

Hi all – FYI I will be speaking at SQL Rally in Copenhagen in early October along with a few of my coworkers from the SQL team (I am giving my own talk). I’ll be speaking about the Query Optimizer in SQL 2012. More information here ( http://www.sqlpass.org/sqlrally/2012/nordic/ ) Also, I was interviewed by one of our MVPs about Windows Azure SQL Databases (SQL Azure) earlier this week. You can find the podcast through this link: http://sqlblog.com/blogs/greg_low/archive/2012/08...(read more)

Conor vs. SQLBits X Slide Decks

2012-04-04T01:11:13Z

Thanks for all who attended SQLBits last weekend and for those of you who attended my talks. I had three talks this time at SQLBits, including the technical keynote on Saturday. I’ve attached these decks for your reference here: Making DW Easy ppt deck SQL Server 2012 ColumnStore Keynote ppt deck Distributed Query Deep Dive ppt deck...(read more)

Conor vs. Traceflags

2012-02-22T16:20:21Z

I got a question from a reader asking me to explain various cases for the use of one of our traceflags. The flag in question doesn’t matter per se (the only official documentation on the flag, 2301, is at http://support.microsoft.com/kb/920093 ). I am going to talk a bit about some of the things we do when developing new features and why such a traceflag might exist and might be off by default. Optimizers are hard to build. Well, after awhile you can figure out how to optimize well...(read more)

Conor vs. SQL Azure Pricing

2012-02-14T16:47:30Z

New Pricing for SQL Azure is out today (and it is cheaper on storage): http://www.windowsazure.com/en-us/pricing/details/...(read more)