About Me

Hi!  Glad you could make it. This blog is going to be all about the cloud and the data on it.    A quick intro on me… I was born on the cloud so if we start talking about on-prem and my eyes glaze over, I’m sorry.  It’s me not you.  I was an analytics consultant for about 3 years, mostly helping customers figure out how to wrangle up petabytes of data, and have recently become a full-time evangelist!  I’m originally from the gravel capital of the world, a small town in Michigan(Go Blue!), but have been in the bay for a few years now.

When not working ,there is a good chance I’m lost in a new book, backpacking to remote campsites, or working on building something thrilling!  Some of my favorite non-tech discussion topics include: picking the next million dollar stock, the current snow conditions in Tahoe (yes, even in the summer), and finding the best coffee and food in the bay!



Suited uo

3 thoughts on “About Me

  1. Jim Hocker

    Hi Andrew,
    My name is Jim Hocker. I was referred to you by the MSDN Tech Advisors page:


    I have question about SQL Replication that I am researching. I’d like to change


    Specifically, this step in changing security settings for the Distribution Agent for a pull subscription, is there any way this can be done through programmatically so it can be handled automatically in code?

    To change security settings for the Distribution Agent for a pull subscription
    In the Subscription Properties – dialog box at the Subscriber, you can make the following changes:
    To change the account under which the Distribution Agent runs and makes connections to the Subscriber, click the Agent process account row, and then click the properties (…) button in the row. Specify an account and password in the Distribution Agent Security dialog box.
    If you use queued updating subscriptions, the Queue Reader Agent also uses the context specified here for connections to the Subscriber.
    To change the context under which the Distribution Agent connects to the Distributor, click the Distributor Connection row, and then click the properties (…) button in the row. Specify the context in the Enter Connection Information dialog box.

    I’m really looking forward to your reply. Thank you so much.



  2. Akshay

    Hello Andrew,

    I am working on a powershell script for Managing the Azure portal. I wanted to know whether it is possible to check if the session created using “Add-AzureAccount -credentials $cred” has expired or not?

    I was using Get-AzureVM to check if the session is valid or not, but it gives me the following error and is not throwing an exception which I could have handled with try…catch. Also the use of variable didn’t help.

    Get-AzureVM : Your Azure credentials have not been set up or have expired, please run Add-AzureAccount to set up your
    Azure credentials.
    At line:1 char:1
    + Get-AzureVM
    + ~~~~~~~~~~~
    + CategoryInfo : CloseError: (:) [Get-AzureVM], ArgumentException
    + FullyQualifiedErrorId : Microsoft.WindowsAzure.Commands.ServiceManagement.IaaS.GetAzureVMCommand

    Can you please help me on this? Even if you can help me in a way to catch the error.

    1. AskTheData Post author

      Can you use Import-AzurePublishSettingsFile instead of the Add-AzureAccount -credentials? It is much more robust. You could also add a try catch around the Get-AzureVM code and if this error is caught run Add-AzureAccount again… Tweet at me @AskTheData and I’ll be faster to respond 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *