Blog - Title

  • Conor vs. SQL

    Conor speaking at SQL Saturday Dublin on Sept. 20, 2014

    • 2 Comments
    I will be travelling to Ireland to speak at the SQL Saturday on Sept. 20th. I plan to give a talk on how the query processor works in SQL Server (including the new execution models used for in-memory OLTP and DW, which are separate from the traditional...
  • Conor vs. SQL

    Conor vs. PASS 2013

    • 1 Comments
    I’ll be speaking at PASS this year.  In fact, some folks at MS interviewed me about it and posted it here:   Interview with Conor Cunningham   I hope to see you there!   Conor
  • Conor vs. SQL

    Conor vs. Premium Edition in Windows Azure SQL Database (aka SQL Azure)

    • 0 Comments
    FYI, I helped write a white paper that got released this week.  It relates to a new edition of WA SQL Database that was released this week called the “Premium Edition”.  The primary benefit of the feature is the ability to reserve resources...
  • Conor vs. SQL

    Conor vs. SQL Azure Optimizer Hotfix Traceflag 4199

    • 0 Comments
    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...
  • Conor vs. SQL

    Conor vs. SQL Azure Parallel Query

    • 0 Comments
    (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...
  • Conor vs. SQL

    Conor vs. SQLBits Spring 2013 Nottingham

    • 0 Comments
    (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...
  • Conor vs. SQL

    Conor vs. SQL Injection

    • 0 Comments
    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
  • Conor vs. SQL

    Conor vs. Spring 2013 Conference Schedule

    • 0 Comments
    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...
  • Conor vs. SQL

    Conor vs. Azure Architecture

    • 0 Comments
      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...
  • Conor vs. SQL

    New SQL Azure Features

    • 0 Comments
    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
  • Conor vs. SQL

    Conor vs. SQLRally Nordic 2012

    • 0 Comments
    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...
  • Conor vs. SQL

    Conor vs. SQLBits X Slide Decks

    • 6 Comments
    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...
  • Conor vs. SQL

    Conor vs. Traceflags

    • 1 Comments
    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 ...
  • Conor vs. SQL

    Conor vs. SQL Azure Pricing

    • 0 Comments
    New Pricing for SQL Azure is out today (and it is cheaper on storage): http://www.windowsazure.com/en-us/pricing/details/
  • Conor vs. SQL

    Conor vs. window functions, sequence/ranking functions order-of-operations

    • 1 Comments
    We had a customer issue today that ended up being by-design but was confusing enough that I offered to write up a blog post so that people could reference it in the future.  It boils down to the question “when should ROW_NUMBER() be computed in a...
  • Conor vs. SQL

    Conor vs. SqlBits Spring 2012

    • 1 Comments
    For those interested, I will be speaking at the SqlBits conference in London, UK at the end of March.  I’ll be giving the Saturday keynote (on the new Batch processing engine in SQL 2012 used with Column Store indexes) and 2 other talks (one on Data...
  • Conor vs. SQL

    Conor vs. SQL Azure Resource Usage

    • 0 Comments
    For those of you watching SQL Azure, you probably have noticed that it releases more frequently than regular SQL Server.  There was a release in late November/early December (it is complicated since the installation of the new software is done largely...
  • Conor vs. SQL

    Conor vs. ColumnStore Index Stats

    • 0 Comments
      I haven’t posted much on the new SQL Server 2012 features yet, but I’m going to start doing so soon.  I’ll also be speaking about them at upcoming conferences.  We have an exciting new index type in SQL Server 2012 that is column-oriented...
  • Conor vs. SQL

    Conor vs. Distributed Query Provider Hints

    • 2 Comments
    (I promised I’d write more ) Today I will talk a bit about Distributed Query (DQ), a feature that lets you query across databases/servers.  I’ve previously posted an academic paper we wrote on the subject some time back ( http://citeseerx.ist.psu...
  • Conor vs. SQL

    Conor vs. SQL Azure/SQL Server 2012

    • 2 Comments
    I’m not one for New Year’s Resolutions, but I am going to try to blog a bit more.  It’s hard to describe working at Microsoft, especially as one gets more senior.  There are lots of really smart people.  There’s an ability to work on problems...
  • Conor vs. SQL

    Conor vs. Extended Events

    • 0 Comments
    I have been playing with the XEvent feature in SQL 2012 (RC0) and there are a few gotchas that I hit.  I figured I’d post them up here so that others could learn from my experiences.  I was trying to do something pretty simple – get the % Processor...
  • Conor vs. SQL

    Conor vs. Synergija Slide Decks

    • 0 Comments
    I had a great time visiting Belgrade last week.  I’d like to thank everyone who attended one of my talks and I wanted to post up the slide decks for those who would like to see them.  One talk was on the new SQL 2012 ColumnStore index feature...
  • Conor vs. SQL

    Conor vs. Sinergija 2011

    • 7 Comments
    As a professional announcement, I will not be speaking at PASS this year (nor will I be at the conference).  Instead, I will be in Belgrade, Serbia the following week to speak at the Sinergija 11 conference.  I’ll be doing a talk on the new...
  • Conor vs. SQL

    Conor vs. Max Server Memory

    • 1 Comments
      Question (paraphrased):  “Conor, does changing the max server memory settings always empty the plan cache on SQL 2005 and 2008?” Answer: yes, this is what happens and what is supposed to happen.  One of the inputs to the optimizer is...
  • Conor vs. SQL

    Conor vs. SQL Saturday Austin

    • 0 Comments
    I'll be talking about one of the new things our team has been develping this Saturday at the SQL Saturday event in Austin ( http://www.sqlsaturday.com/97/eventhome.aspx) on the new ColumnStore index being added in the upcoming release of SQL Server. It...
Page 1 of 4 (91 items) 1234