Archive

Archive for April, 2014

MSDN Azure Subscriber benefits

April 24, 2014 Leave a comment

In my last post , I spoke about the free Azure credits that every MSDN subscriber gets , and detailed the steps to activate them.

Well , the Azure channel on Youtube now has a video which talks about this.

Azure MSDN Subscriber benefits

Windows 8 – How to open all links in Desktop Internet Explorer

April 16, 2014 Leave a comment

I thought I’d share a Windows 8 tip with you guys. When you’re using a Modern Application ( like Windows Mail ) , and you click on a Hyperlink , it normally opens it up with Modern Internet Explorer ( like in the image below ).

Modern

This is fine when you’re on a tablet ( or in touch mode ). It’s not so great if you’re using a mouse and keyboard. However, there is a setting to change this behaviour.

1) Launch the Desktop Internet Explorer

2) Go to [Tools] , [Internet Options] and then [Programs]

3) Under [Choose how you open links], select [Always in Internet Explorer on the Desktop]

IE Setting

When you go back into a Modern Application and click on a link , it will take you to the Desktop Internet Explorer.

SQL 2014 launched

April 8, 2014 Leave a comment

This is the big one !! SQL 2014 , with the in-memory OLTP capability, has officially launched as of 1 April 2014. You’ll find everything that you need to know at the link below :

Microsoft Official SQL Page

So far , I’ve been experimenting with the in-memory tables , and I’ve definitely seen some big performance improvements. I’ll do an upcoming post detailing how you create these tables.

Before that , I want to talk about dev and test environments. Many of you will be wanting to try out SQL 2014 , but perhaps don’t have the space available to spin up a VM. What you can do in this situation, if you have an MSDN subscription, is spin up a VM in Azure at no cost, and try out SQL 2014 there. To do so :

1) Log into the main MSDN page ( http://www.MSDN.com )
2) Click on “Cloud”
3) Under “Start your free trial” click on sign up
4) Scroll down to the bottom of that page. You’ll see a heading called “MSDN Subscriber?”. Click on “Activate Now”
5) You are basically entitled to $150 per month of free Azure services.

Once you have sorted that out , you’ll see that SQL 2014 is already available in Azure. There are preconfigured VM templates with various options.

SQL2014Azure

It takes about 5 minutes to spin up a new Virtual Machine , with the OS and SQL 2014 already installed !! Once that’s done, you can remote desktop into that and work on it as normal.

Categories: SQL Server