Conor vs. SQL
Conor Cunningham's blog on SQL Server, data-driven applications, and pretty much whatever other random stuff he decides to post.
Conor speaking at SQL Saturday Dublin on Sept. 20, 2014
I will be travelling to Ireland to speak at the SQL Saturday on Sept. 20th. I plan to give a talk on...
Date: 07/06/2014
Conor vs. PASS 2013
I’ll be speaking at PASS this year. In fact, some folks at MS interviewed me about it and...
Date: 09/12/2013
Conor vs. Premium Edition in Windows Azure SQL Database (aka SQL Azure)
FYI, I helped write a white paper that got released this week. It relates to a new edition of...
Date: 07/26/2013
Conor vs. SQL Azure Optimizer Hotfix Traceflag 4199
Another question: Does Windows Azure SQL Database (aka SQL Azure) run with or without the...
Date: 05/25/2013
Conor vs. SQL Azure Parallel Query
(The official name is Windows Azure SQL Database, but since SQL Database is hard to search for, I...
Date: 05/24/2013
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...
Date: 05/24/2013
Conor vs. SQL Injection
While I was at SQL Intersection yesterday, I was asked if Microsoft has any best practice guidance...
Date: 04/11/2013
Conor vs. Spring 2013 Conference Schedule
Hello all, I will be speaking at the following public conferences this Spring: 1. SQLIntersection...
Date: 02/10/2013
Conor vs. Azure Architecture
FYI – we just posted a white paper that covers some of the “how to think about Windows Azure...
Date: 01/15/2013
New SQL Azure Features
FYI, we announced new features on SQL Azure today, including SQL Azure as a distributed query target...
Date: 09/19/2012
Conor vs. SQLRally Nordic 2012
Hi all – FYI I will be speaking at SQL Rally in Copenhagen in early October along with a few of my...
Date: 08/23/2012
Conor vs. SQLBits X Slide Decks
Thanks for all who attended SQLBits last weekend and for those of you who attended my talks. I had...
Date: 04/03/2012
Conor vs. Traceflags
I got a question from a reader asking me to explain various cases for the use of one of our...
Date: 02/22/2012
Conor vs. SQL Azure Pricing
New Pricing for SQL Azure is out today (and it is cheaper on storage):...
Date: 02/14/2012
Conor vs. window functions, sequence/ranking functions order-of-operations
We had a customer issue today that ended up being by-design but was confusing enough that I offered...
Date: 02/02/2012
Conor vs. SqlBits Spring 2012
For those interested, I will be speaking at the SqlBits conference in London, UK at the end of...
Date: 01/30/2012
Conor vs. SQL Azure Resource Usage
For those of you watching SQL Azure, you probably have noticed that it releases more frequently than...
Date: 01/16/2012
Conor vs. ColumnStore Index Stats
I haven’t posted much on the new SQL Server 2012 features yet, but I’m going to start doing...
Date: 01/09/2012
Conor vs. Distributed Query Provider Hints
(I promised I’d write more ) Today I will talk a bit about Distributed Query (DQ), a feature that...
Date: 01/09/2012
Conor vs. SQL Azure/SQL Server 2012
I’m not one for New Year’s Resolutions, but I am going to try to blog a bit more. It’s hard to...
Date: 01/04/2012
Conor vs. Extended Events
I have been playing with the XEvent feature in SQL 2012 (RC0) and there are a few gotchas that I...
Date: 12/16/2011
Conor vs. Synergija Slide Decks
I had a great time visiting Belgrade last week. I’d like to thank everyone who attended one of...
Date: 10/24/2011
Conor vs. Sinergija 2011
As a professional announcement, I will not be speaking at PASS this year (nor will I be at the...
Date: 10/07/2011
Conor vs. Max Server Memory
Question (paraphrased): “Conor, does changing the max server memory settings always...
Date: 09/30/2011
Conor vs. SQL Saturday Austin
I'll be talking about one of the new things our team has been develping this Saturday at the SQL...
Date: 09/27/2011
Conor vs. Parallel Execution Plan Contexts/Runtime Instances
I’ve received a question about parallel execution plans from a customer....
Date: 06/28/2011
Conor vs. SQLBits 2011 Brighton
Here is the slide deck from my presentation at SQLBits Friday in Brighton file I had a great...
Date: 04/11/2011
Conor vs. SQLBits (United Kingdom)
I will be in Brighton, England this upcoming Friday where I will be speaking at the SQLBits...
Date: 04/03/2011
Conor vs. Map-Reduce vs. Databases
I found this paper interesting, so you might too. It covers some of the differences between...
Date: 02/11/2011
Conor vs. Views/Tables
I received an email from a reader this weekend that has a lot of different questions, but one of the...
Date: 01/31/2011
Conor vs. How I got into computers…
I thought I’d do a small post about some of the reasons I got into computers since I’ve randomly had...
Date: 01/01/2011
Conor vs. more SARGable predicates
I got another question in the mail this week from another reader: Hi Conor Thanks for an...
Date: 12/18/2010
Conor vs. Join Search Space
I received a question this week from a reader about how SQL Server determines the join order if...
Date: 12/18/2010
Conor vs. Row Growth in Read Committed Snapshot Isolation
At PASS last week, I was asked about fragmentation caused by RCSI when a row is first converted to...
Date: 11/16/2010
Conor vs. PASS (Slide Decks)
I had a great time at PASS last week and got to talk to a lot of wonderful customers- thank you! As...
Date: 11/15/2010
Conor vs. PASS
It’s one of the most exciting weeks of the year to be a SQL Server junkie – PASS is this week in...
Date: 11/08/2010
Conor vs. PASS (November in Seattle)
A note to let you know that I will be at PASS this year and plan to give two talks (one in...
Date: 09/28/2010
Conor vs. Optional Parameters Redux – LIKE %
A question from a reader (thank you, Price, for sending it in). This is a follow up to my...
Date: 09/28/2010
Conor vs. Updates – Talk (for those of you in Austin)
I am giving a talk tomorrow (Tuesday) night at the Austin PASS group on how Update Queries are...
Date: 08/16/2010
Conor vs. Misbehaving Parameterized Queries + OPTIMIZE FOR hints
In my previous post, I debugged a customer problem for you, including the various guesses I had to...
Date: 08/11/2010
Conor vs. Finding a Misbehaving Query
(well, one case of it – the topic is too large for a blog post, so I will focus) I will paraphrase a...
Date: 08/02/2010
Conor vs. UDFs in Joins
In my previous post, I reviewed the basic logic behind why the Optimizer chooses one join algorithm...
Date: 07/01/2010
Conor vs. Join Algorithms
I got a question from a customer today related to join algorithms. This is a good, general...
Date: 07/01/2010
Conor vs. Anti-Semi-Join Reordering
I was asked to comment on a post about the order of WHERE NOT EXISTS (<subquery>) in a query...
Date: 05/14/2010
Conor vs. Index Fragmentation in Plan Selection
(more SQL Bits questions) Does the SQL Server Query Optimizer consider index fragmentation in plan...
Date: 04/23/2010
Conor vs. Left Outer Join Reordering
A question from two of the MVPs: Are these two queries conceptually the same? select a.id, b.id,...
Date: 04/23/2010
Conor vs. Index SARGability with complex scalar expressions
In my prior post, I introduced the concept of runtime constants. Now let’s take this and apply...
Date: 04/23/2010
Conor vs. Runtime Constant Functions
(more questions resulting from SQL Bits – some of these answers will be a bit more terse than my...
Date: 04/23/2010
Conor vs. the Search Framework in SQL Server’s Optimizer
I got a few requests for additional topics where one can read about the SQL Server query optimizer’s...
Date: 04/22/2010
Conor vs. Optional Parameters
One question I received at SQL Bits had to do with a reasonable programming practice that has an...
Date: 04/22/2010