Microsoft continues hybrid cloud push with stretchable SQL Server
-
Quote:
When a table is set up to use SQL Stretch Database, administrators can specify a length of time after which data is automatically moved from their on-premises SQL Server instance to Azure. Applications querying that database table will be able to see both the data stored on-premises and the data stored in Azure. That functionality is key because it means that application developers shouldn't have to modify their work in order to take advantage of the feature -- administrators just need to enable it.
Really...
var GetTransaction(int id)
{
var allTheThings = RunMeSomeSql("SELECT * FROM AllCustomerTransactions");
var theOneIWant;
var foundIt = false;foreach (var transaction in allTheThings) { if (transaction.id == id) { foundIt = true; theOneIWant = transaction; } if (foundIt) return theOneIWant; else return new Transaction(); //if I return null here it crashes }I can't wait to see how much faster my code'll run after this gets turned on. :doh:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
-
Quote:
When a table is set up to use SQL Stretch Database, administrators can specify a length of time after which data is automatically moved from their on-premises SQL Server instance to Azure. Applications querying that database table will be able to see both the data stored on-premises and the data stored in Azure. That functionality is key because it means that application developers shouldn't have to modify their work in order to take advantage of the feature -- administrators just need to enable it.
Really...
var GetTransaction(int id)
{
var allTheThings = RunMeSomeSql("SELECT * FROM AllCustomerTransactions");
var theOneIWant;
var foundIt = false;foreach (var transaction in allTheThings) { if (transaction.id == id) { foundIt = true; theOneIWant = transaction; } if (foundIt) return theOneIWant; else return new Transaction(); //if I return null here it crashes }I can't wait to see how much faster my code'll run after this gets turned on. :doh:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
Well, if you will insist on doing all your filtering on the client side ;P
This space for rent