Blog - Title

  • Conor vs. SQL

    Conor vs. Windows 7

    • 0 Comments
    (Not a SQL Server post) I have been meaning to install Windows 7, and I got around to doing it last night.  I usually run Windows 2003/8 Server for work, so my interest in the consumer side is perhaps not as high as some others.  Nevertheless...
  • Conor vs. SQL

    Conor vs. Stats NORECOMPUTE

    • 0 Comments
    It’s been a busy summer.  I got back from vacation and have been hard at work on new features for a future version of SQL Server.  You can always still send me questions about the existing product, of course, and I will answer them here (conorc...
  • Conor vs. SQL

    Server Cursors

    • 0 Comments
    My coworker Marc posted up a good introduction into the different server cursor models and you can see it here: http://blogs.msdn.com/sqlqueryprocessing/archive/2009/08/12/understanding-sql-server-fast-forward-server-cursors.aspx
  • Conor vs. SQL

    Conor vs. Statement Offsets

    • 0 Comments
    As most of you have figured out by now, I work mostly on queries :).  One of the things that I often need to do is to get a statement out of a batch so that I can go look more closely at a query plan (and, in my case, the code that generates it)...
  • 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. 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. 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. 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

    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. 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

    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. 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. 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 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. 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. 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...
Page 4 of 4 (91 items) 1234