Go Premium for a chance to win a PS4. Enter to Win



Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have azure database with list of data in table say called Table1
I have spreadsheet too
I want to populate spreadsheet with data in Table1.
However only certain users should be allowed to do this. I don't want everyone with the spreadsheet or everyone who knows database location to be able to get data obviously
I can use the excel import data however Azure firewall needs configured to allow access which isn't practical as user IPs change
I only want say my users A,B,C to get data not everyone...
I wonder if need to have web service or something instead of direct database call  if so how, or is there other method . Thanks
I have an environment where I cannot ssh at all due to security , I want my client to be able to access a command line instance of Ubuntu in the cloud with Digital ocean or some such way .

I need to have this very clean in that they will be working on this for hours and days at a time so it would have to look just like a ssh or putty terminal connection .

something like Guacamole but as a service that I can use just for a few days at at time , and it does not have to be free or anything I have a budget for this .

what I am doing does not take much bandwidth

any experiences or thoughts on this

thanks !!!!!!
We need to transfer VMDK and OVA files from Azure to AWS S3. Anybody has advice what to use besides PowerShell ?

Thank you !
I am new to Azure, I have an app which is on Azure & should be reached by port 8081
I have tired to make the inbound rule to allow traffic, however it is not able to reach....
Can someone please help???

I need step by step instructions as I am fairly new to this game..

Experts, I am super lost how to do this.. from this page I am trying to follow this tutorial
I tried to put each into its own class and I am not getting anywhere:

// Retrieve the storage account from the connection string.
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(

// Create the table client.
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

// Retrieve a reference to the table.
CloudTable table = tableClient.GetTableReference("people");

// Create the table if it doesn't exist.

Open in new window

These are my errors....just trying to get over this hump.

Csharp2.pngThank you
I have  Windows Azure Active Directory Sync Synchronizing to Azure AD. Due to deprecation of DirSync, I am planning the upgrade to Azure AD Connect using in-place upgrade approach (https://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnect-dirsync-upgrade-get-started/#in-place-upgrade). Nevertheless, this approach requires my entering the password for the account  currently use to connect to Azure AD. This must be the account currently used by DirSync tool. Unfortunately, the password information was not documented during DirSync deployment and I do not know how to go about resetting the account and updating DirSync to user the new credentials. I want to perform this step before performing in-place  upgrade to Azure AD Connect.  I was trying to follow instructions on this MS article: https://support.microsoft.com/en-us/kb/2882421 and was following instructions on  "Method 2: Manually verify that the service is started and that the admin account can sign in", however I am not sure how to run the Azure Active Directory Synchronization appliance configuration wizard listed on step 4 of this section so that after I reset the account password in o365, I can update the DirSync tool with the new password.
I will greatly appreciate help with this item.
Hi, one of our customers wants to move of their custom SQL Server DB into Azure DB. We're trying from a SQL Server developers point of view to identify pitfalls and limitations.

I'm finding it hard to find definitive answers on a number of question. the biggest issues are that MSs own "list of limitations" from this link:

does not elaborate at all on what "partially supported" means.

the second issue is a lot of articles are already out of date. For example I found one document from jan 2016 - only 4 months old, but this states triggers are not supported at all. this is already out of date and inaccurate.

Has anyone got a definitive list of Azure limitations, can expand on what "partially supported" means and any up to date do's/donts or case studies where you should NOT use Azure SQL?

I'm taking the mentality that Azure SQL is basically like classic shared database hosting - you can do stuff in your own DB and that's it. Am I correct to be thinking this way - I don't want to be telling the customer to move to Azure SQL if they cannot actually make the application work !

Specific interest to me is:
1) what is not supported, a full explanation of "partially supported". for example it's not overly comforting that CREATE TABLE is listed under "partially supported"!!
2) What should you do if there is a large reporting requirement? should you use 2 separate Azure …

I need to encrypt the connection string in my web.config file for my MVC5 project. The database is an Azure SQL database. I have never done encryption before and I am struggling.

First I followed instructions in this article - https://azure.microsoft.com/en-us/blog/securing-your-connection-string-in-windows-azure-part-1/ . But when it came to loading the files on to Azure, the link contained in the document was broken, and I couldn't find out where to upload them.

After some research, I found out that Azure Key Vault is the way forward, but I am struggling to find out how to use Key Vault as it is not in Azure Management Portal and to use it you need Powershell knowledge. I have tried to use Powershell as per this link https://channel9.msdn.com/Blogs/Windows-Azure/Azure-Key-Vault-Developer-Quick-Start only to find out that some of the commands are no longer in use.

Is there an easier method for me to follow? What other options do I have?

Hi folks -

I'm administering a small network in a Microsoft environment with a 2012R2 DC, a file server and a few VMs. I'm trying to build a DR plan and was hoping for some guidance.

We have Office 365 and some other cloud apps but we still have the file server on premise. Right now I'm debating if I should use a COLO facility where I could keep a second DC and potentially bring the file server in if something happens at our main location. Users would reach the file server over VPN. A second option would be to create a virtual network inside Azure and build a file server VM plus a DC in the cloud in case of an emergency. I'm actually worried about blind spots like authentication issues, performance, security and other details that I might miss in this scenario, hence this message. Is it even possible to run without an on-premise DC and just rely on Azure? Of course, that would be a temporary scenario but I want to make sure it is doable.

Sorry for the long message!

Any insight would be appreciated!
I have a database first model in MVC5 using Azure SQL database; it has been working ok and I have updated the model today (using Update Model From Database function in Visual Studio...) and have received the error message below:

SQL70015: Keyword or statement option 'ADD FILE' is not supported for the targeted platform.

I have no idea where to start to find what might have changed. Does anyone know what this message means?

Hello -

I have a 2012R2 file server  with around .075Tb of data that needs to be backed up into the cloud as a second layer beside the local disk backup. As of now, it is backup up with Carbonite but I'm not sure this is the best/cheapest option I have. I also looked into Azure since now it's not necessary to have DPM installed(as far as I know) locally for it to work.

Anyone out there have experience with both and be kind enough to share the experience?

Thank you!
I am trying to get my feet wet and learn Azure and signed up for a free trial account. I see now to deploy a VM which I have done but find it a bit over whelming as well.

1) How can I monitor now may credits I have used and can I place a cap so I do not exceed a credit amount per month?

2) When you connect to a VM using RDP or SSH, it is over the internet of course does this mean all IP are public in Azure or are they private with in your portal session only>

I have been looking for a video that has a tutorial on basic navigation in Azure and ideas?
We are trying to get the above working and MS cannot help at all, whereas and mimecast believe the tenant account is wrong as per https://community.mimecast.com/docs/DOC-1011 
i have configured the tenant account domain.onmicrosoft.com but it still fails.

Anyone else using this?


I have successfully setup Azure AD Connect and accounts are synchronising from my local AD to Azure. However this is only working if the account doesn't already exist in Office 365/Azure. If the account already exists in Azure then no change seems to happen.

I cant delete the accounts in Azure so is there a way to merge them? So that the accounts that were only in Azure are now synced with my local AD?

Hi, we've backed up some data (it's marked as 1tb but should only be about 50mb) as a blob onto our one of our containers and now we'd like to delete it but we cannot. the full error is "There is currently a lease on the blob and no lease ID was specified in the request.". What is the most straight forward way to delete this. I've found other answers but they refer to vm's and this is a .bak file.
I currently have a split database.  FE is local access app (except for linked data source), be is sql azure.

The database is driven from the data on a .csv file which is generated daily from a scheduled task.  Before I migrated the be to SQL it was a linked text table from a local network drive.  

Now that the be database lives in the Azure cloud I want to:

1)  export the csv thru a daily scheduled task to the Azure Cloud  (instead of the local network drive)
2) create a linked text table to the csv in the Azure cloud (instead of the local network drive)
we signed up for a 30 day trial for 365 encrypted email - Azure.  I have assigned the license to a user and activated rights management.  When she sends a test message to me with encrypt in the subject, I just receive it as a normal email not encrypted.  What am I missing.
What is the procedure to have a split access database where the front end is access and the back end is Azure hosted SQL?
I have just found out that my SQL Azure database time is different to the time on my application code, due to Azure system time being set in a different time zone to my own.

I have a stored procedure on SQL that regularly looks at a table and performs actions on records that are 5 minutes older than the current time - (there is a date time field set during the initial transaction.) The Azure time issue obviously throws this out.

I could manually add a few hours on to my code to change the stored procedure to account for the time difference but this seems messy. I am also in GMT zone which changes to BST during the summer. Any suggestions about how I should account for the difference in time zones??

i was looking at various articles as how to set up Active directory federation, Microsoft federation gateway  works when there is ADFS and MFG installed between on premise exchange 2010 server and office 365 exchange online. i am looking for hybrid migration between exchange 2010 and office 365 for mailbox migration.

what has confused me: is which one to go first, i mean set
ADFS server first, then set up MFG through exchange 2010 through organization configuration console in exchange 2010 and then run
hybrid configuration wizard?
can some body clear this one for me, in one article it said wetting up hybrid configuration creates organization relationship?

i dont know the steps to go for.
I have an  Azure SQL Database and want to run a stored procedure on a linked server to transfer data from the remote (on site) SQL server to my Azure SQL database.

I have just found out that Linked Servers are not supported in Azure SQL database. I know that you can add "External Tables" to Azure but I not able to find much information on the subject.

Can I use the external tables feature to connect to another server like the Linked Server function does?

If so, can anyone provide me with the appropriate syntax to do this?

I haven't seen this one before and since the user is remote, I thought I put it out there to see if anyone can provide a solution.  I have a user with a Surface Pro 4 running Windows 10.  The company has no local domain, so each computer logs in using their Office 365 / Azure AD account:  <username>@<companydomain>.com.  Has worked fine for months, but all of the sudden, the user could no longer login to the Surface Pro.  He is prompted with his full name for login, which looks like a local userid (not the Azure AD login), but none of his passwords work.  There are no other user accounts appearing on the screen to the lower-left, and no option for "other user" logins.  Only the wireless, accessibility and shutdown icons on the bottom-right of the screen.

So, what happened?  Did he lose domain affiliation with the Microsoft Office 365 or Azure AD?  If he has no active accounts other than the Azure account he first connected with, how is he able to login?  I can't really just wipe him out and restart factory fresh, as he has programs and data on the Surface Pro he needs.  Is there a way to activate the Administrator account to get in and fix the problem, and if so, how do you fix the problem?  Thanks ahead for your assistance!
I have a SQL database on Azure; I am using the built in tools option to run Visual Studio 2015 to use the database. It's been a while since I've done any SQL work. I am coding all my queries manually because I cannot see a query builder; whilst this gets me by, it certainly slows me down.

Is there a builder that I cannot see? Alternatively, any suggestions?

I have Azure but am a newbie. I am also not a regular DB administrator.

Is it possible to create a user with permission ONLY to run stored procedures (generally)? Or even particular stored procedures?

I'd like to do that by simply connecting with SQL Server Management Studio 2014.

Is that possible?

Greetings. We just set up Azure Backup Server.  Under Azure Recovery Services, on the right side of the dashboard, I see a certificate that expires in 3 days. Do I need to worry about this ?  We're only using Azure vaults for backup. Is a cert actually necessary ?  (See graphic below).

Azure Recovery - Cert ?


Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.