Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

Azure First

Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on a massively accelerated schedule. Because of this, they’re doing lots of code on lots of things that may, one day, end up in your full blown SQL Server instance, but are currently only available in Windows Azure SQL Database. This is because of that accelerated schedule. It frees Microsoft developers up to experiment a little. I saw some evidence of it the other day.

I had been working on a series of queries for the pre-conference seminar that I helped put on at TechEd (and one that I’m doing for the PASS Summit). When I write queries, I use SQL Prompt. Sorry to be plugging Red Gate products on the blog, but I happened to love Red Gate products even before I started working for the company. Prompt is one of the best. Prompt works with Azure, although you can sometimes hit errors. Anyway, I was typing up a query when I noticed a system view being offered to me that I’d never seen before, sys.database_query_store_options. I ran a SELECT against it and got this result set:

querystore

I immediately checked my SQL Server instances and did a search against the internet to see if this was just something I had simply missed. It wasn’t on SQL Server and I didn’t find a single reference to this system view in Boogle (or Ging).

What’s it mean? What do I do with it? I don’t have a clue. Heck, it could just be some obscure bit of output from Federation or something. I really don’t know. I was just excited to find evidence of ongoing development within WASD. And you see it first in Azure.

Comments

Leave a comment on the original post [www.scarydba.com, opens in a new window]

Loading comments...