Tuesday, June 14, 2016

Stretch your database from Azure Cloud to On premises server

Data need not be something fixed and your hot and cold data can be kept anywhere that makes sense. Of course you need to find which is a less expensive option and which has the priority. Try to consider the pros and cons of putting data on the cloud (energy, bandwidth, server aging; security,etc).

Why do you need this?

Well you want to archive data (historical) but you do not want to store it locally as it is not frequently accessed and your resources are inadequate. However you do want to access. No problem, a query in SSMS can access that data (remotely stored in Azure) as easily as the on premises data. It is possible there may be a bit of latency from the remote site.

Source: MSFT Blog

Wizard takes care of Stretch database

SSMS 2016 has a very good wizard to take care of the Stretch Database.  The Wizard is accessible via the Object Explorer. You need to select the database you want to extend using the Stretch Database feature. It is not necessary that you choose an entire database to extend; you can use the filter to include what you need to go into the Stretch database. Of course, since the remote is on Azure, you should have an account and proper credentials. The Stretch database is always online and querying should have no problem.

How do you enable Stretch Database feature

You need to have an instance of SQL Server 2016. Then just right click the database you want to 'Stretch' and choose the enable option as shown. Just to enable you do not need to be connected to Azure Cloud.


Stretch database is compatible with the other features; Transparent Data Encryption and Always Encrypted and Row-Level Security features.

You do require a Azure account but a free trial is available. There is a price for everything including the new Stretch database feature.

More here:
https://blogs.technet.microsoft.com/dataplatforminsider/2016/04/13/keep-data-virtually-forever-with-stretch-database-in-sql-server-2016/

Monday, June 13, 2016

Need more parties in the political arena

Most things have changed in the recent past. Actually the list of things that have changed is endless; communications, transport, all sciences including medicine; medicines for new diseases; banking and finance; and you name it.

What has not changed is the two party rule. Both of them founded more than a century, or more ago (Democratic party founded: 1828, Republican party founded: 1854).

It is time for change, and we should welcome more parties; parties based on ideas that have surfaced in recent election primaries. Both the parties have large number of voters not interested in the most nominated candidates in each party, so why not increase the number of parties?

Existing Democratic Party
Followers of Bernie Sanders
Existing Republican Party
Followers of Donald trump
Libertarian Party

Although this will not work for the 2016 election, it can surely provide a framework for the future.

Microsoft's purchase of LinkedIn

Microsoft bought LinkedIn at a premium (the deal has not completed yet). The price appears very steep. I hope it does not get to the same fate as Nokia.

How does Microsoft integrate LinkedIn?

The most important is of course, integration of LinkedIn with Office commercial by way of channeling information from LinkedIn to Office 365 using feeds. Skype is already integrated. LinkedIn with Skype can lead to more ways of engaging with hires. Video interviews to directly link future employees with employers is perhpas the first of the features. Project collaboration via LinkediN/skype interfaces is also feasible.

The other benefit of getting LinkedIn is the use of LinkedIn's advertising.
It appears LinkedIn is making lots of money according to this article from which the below image was grabbed. Probably Microsoft has made a good deal.

Here is video of the acquisition.


I have been a member (free, of course) of LinkedIn for quite a long time and I am not active now. I did not find it very useful. It did not help me. It provided all kinds of information that I did not need. It is one person's experience and I am sure millions of others have found it useful
DMCA.com Protection Status