Posts Tagged ‘Performance’

Productivity Minutes: Compare two tables October 2nd, 2014

Vinod Kumar

I remember writing a three part series on how to compare two lists before in this blog. This can be read from Excel Tip: Compare two lists (Method 3). This video is not about that, here I am going to show you the 4th method that will is super cool in my opinion.

So you could see how easy it is to compare two tables inside of Excel and how one can become efficient learning from Excel. Let this journey continue and let me know your feedbacks.

Do feel free to subscribe to my Youtube channel to get updates in the future.

Continue reading...


 

Productivity Minutes: AutoSum Trick with Excel September 16th, 2014

Vinod Kumar

As the productivity series catches heat, I have got a number of you ask more tips around Excel and other tools. So here is next in series of using AutoSum capability with Excel and how you can quickly calculate the SUM across the range which has sub-total already calculated.

Though I showed you four different way to achieve the same, I am sure you will have many more innovative ways of doing it. Please feel free to share alternate options if I have missed them in the above video. Will be a great learning for me too.

Do feel free to subscribe to my Youtube channel to get updates in the future.

Continue reading...


 

Productivity Minutes: Moving rows in Excel September 8th, 2014

Vinod Kumar

This is in series to our Productivity Minutes videos. I have started to get a hang of these videos and I am loving doing these short videos for you. In this blog, I would like to share the tip around how to move data presented in Excel from one position to another.

Yes, I understand we all are very comfortable in using CTRL+C and CTRL+V. But this tip is NOT about this technique. It is about how we can efficiently use mouse and achieve the movement of a row from one location to another in a Excel Table.

I plan to do these short videos and your feedback and encouragement will do a world of good. So let me know and do feel free to subscribe to my Youtube channel to get updates in the future.

Continue reading...


 

Productivity Minutes: Sharing Outlook Calendar September 4th, 2014

Vinod Kumar

I have had the opportunity to write a number of blog posts around Excel and other productivity tools in the past. Since I started the video blog series, now I will try to bring some of these tips in a quick Video series.

In this short video, we will look at how we can quickly share our Outlook Calendar with our external contacts without sharing our actual meeting details? Wish you wanted to reduce and eliminate multiple rounds of email to lock on a date and time? Well, this video is just for you – trust me.

Hope you enjoyed this quick “productivity minutes” video. Send me your comments filled with feedback and we will have many more in the future too.

Continue reading...


 

Getting started with PowerShell and Azure August 21st, 2014

Vinod Kumar

I am a big time supporter of PowerShell and automation when it comes to working with Azure. In the recent past, I have seen SQL Developer ask me – how I can start playing with PowerShell for Azure. Though the concepts of powershell are awesome and I use them inside SQL Server, it is always difficult to get them ready on their machines. Often, the question is – where do I start? This blog will get you started with installing and configuring your machine with PS and Azure.

We can install Azure PowerShell modules by running the Microsoft Web Platform Installer. I have initiated the same and go through the initial wizard.

We can see the installation progress and once done, we will be presented with information to various components that get installed as part of this.

Now to use PowerShell with out Azure subscription, we need to link our account. If you are using an organizational account, then use the Add-AzureAccount command from the Windows Azure PowerShell command. This is useful ONLY when we are using Azure AD for our account. If you are not using Azure AD, then move to the next step.

In most cases, we are going to have standard Live Account associated with our Subscription. In this case, we need to download the certificate. To do this,  invoke the command Get-AzurePublishSettingsFile command from the PowerShell command prompt.

We will be prompted with a save dialog and save this certificate file in a secure location. The next step is to Import the same so that we can start using PowerShell from our local machine to work with our subscription remotely.

For this we will invoke the – Import-AzurePublishSettingsFile “Path of certificate file”

Once this is done, we are connected and we will get an confirmation of our current subscription. being used.

We can quickly get details about our current subscription using the command Get-AzureSubscription as it outlines some of the information.

Now we are all set with are getting started with PowerShell and Azure. In future posts we will use this configuration as starting point to play around creating new VMs, Stopping VMs, Deleting VMs, Creating other services and much more. Stay tuned !!!

Continue reading...