The new SQL Data warehouse in Azure
March 8, 2016Introduction In previous chapters, we taught how to create SQL Databases in Azure. In this new chapter, we will show you the new SQL Data Warehouse Service in Azure.
Search Results for: azure
Azure SQL Database vs SQL Server on Azure Virtual Machines
February 22, 2016Introduction There are two main options in Azure to handle SQL databases: Azure SQL Database. SQL Server on Azure VM. In this chapter, we will talk about the advantages and disadvantages of each option.
How to run a local SQL Report from an Azure VM Database
January 28, 2016Introduction In this new article, we will create a SQL Server Report using SQL Server Reporting Services from a SQL Server machine installed in an Azure Virtual Machine. We will show step by step how to connect from a local machine to a VM Azure Database and generate a SQL report.
Using SQL Server 2016 CTP3 in Azure
November 6, 2015As the time of the release of the next version of SQL Server is closing in, the cycle of Community Technical Preview (CTP) releases is shorter and shorter – we are now at CTP3 and the product seems very much mature for release. There is a handful of features not yet implemented, that was on […]
How to connect our C# application in Azure
October 30, 2015Azure is a simple and cheap way to have a Database. You can rent your Azure Database of 2 GB per 5 USD per month. That is a very cheap price. You can also administer your Database from your Android or your iPhone, which is very interesting. It is also possible to create your Windows […]
How to work with Visual Studio and VM databases in Azure
September 24, 2015Introduction In this new article, we will use Visual Studio to connect to a SQL Server Database Installed in a Virtual Machine in Azure. Visual Studio is one of the most popular development tools in the world and connecting to Azure with Visual Studio is a very common need. We will modify an existing SQL […]
Working with Visual Studio and SQL Azure databases
September 21, 2015Introduction In this chapter, we will work with Visual Studio to connect to SQL Databases in Azure. The first part of this chapter will be to create a Database in the Azure Portal and the second part will be to connect in Visual Studio and create some Database Objects.
Using the Azure Portal to monitor your Azure Machines with SQL Server installed
September 17, 2015Introduction In this new chapter, we will show how to use the Microsoft Portal to monitor the Virtual Machines with SQL Server Installed. We will show how to do it with the current Portal and the New Microsoft Azure Portal. We will check how to monitor performance, watch the logs, review the settings and change […]
Low cost disaster recovery solution using Azure
August 31, 2015We already talked a lot about Azure and hybrid deployments on this. In order to better understand this article I suggest the reading of the article “Azure Blob Storage – Placing database files in the cloud”, as the presented solution will be based on the same approach.
Using MS Excel to access to a relational SQL Database in Azure
August 14, 2015Introduction There are great Microsoft tools to access to SQL Server in Azure. However, as a Database Developers and Administrators we need to help the end user to access to the information using a familiar and intuitive interface. Most of the end users have a good knowledge in MS Excel. That is why it is […]
Azure Blob Storage – Literally a Hybrid database deployment
August 4, 2015In continuation to our hybrid deployment series, we will check few more options in order to integrate on-premises and Azure, using of course SQL Server. In the last article we talked about Azure Blob Storage and how to use this service to store a SQL Server database entirely there. Meaning that we can have our […]
Azure Blob Storage – Placing database files in the cloud
July 31, 2015Do you know that since SQL Server 2012 you can have your entire database stored in Azure, even if you have your server on-premises? This article will introduce you to this capability, showing the basic steps to allow your instance to be in contact with your Azure Blob Storage Account.
Using PowerShell to monitor your Azure Machine
July 17, 2015Introduction In earlier chapters, I show you how to create your Virtual Machine in Azure using Power Shell. In this new chapter, I will show you how to get information about your VM machine already created. We will use PowerShell cmdlet commands to retrieve the information.
Bcp and linked servers to Azure
July 13, 2015Introduction Sometimes, we need to use the command line to copy tables using the command line. In this new chapter, we will use the BCP command to copy tables from a local machine to the SQL Server in Azure. The BCP is a very fast bulk copy tools used for this purpose. We will also […]
Backups to Azure – How can I do this?
July 3, 2015With the evolution of the Cloud, specifically talking about Azure, SQL Server team started to take advantage of the new opened horizon. We already discussed pros and cons of send backups to Azure, now let’s check how to do this! Following the “Hybrid Scenarios series”, we already discussed about the connectivity options, and pros and […]
Backups to Azure – Why I would do this?
July 2, 2015With the evolution of the Cloud, specifically talking about Azure, SQL Server team started to take advantage of the new opened horizon. In this article we will discuss about backups. What are the pros and cons of store your backup files in Azure?
SQL Server + Azure: Introduction to Hybrid scenarios
July 1, 2015We hear a lot about hybrid SQL Server environments, but how to integrate my datacenter with Azure? Check this article and you will have a simple and effective explanation about the connectivity option!
How to use PowerShell to create a SQL Virtual Machine in Azure
June 4, 2015Introduction The first time that you create your VM in Azure manually using the UI is a very pleasant experience. However, when you have hundred and sometimes thousands of computers it is extremely exhausting and boring to create and configure it. With PowerShell, it is possible to automate several administrative tasks and create scripts to […]
How to work handle SQL Azure Databases with PowerShell
May 5, 2015Introduction PowerShell is a shell used specially to automate administrative tasks. It is an incredible tool used to programmatically automate tasks like SQL Server tasks, Exchange tasks, Windows tasks, etc. It is very useful to integrate different Microsoft and sometimes non-Microsoft programs. In this new tutorial, we will show how to install PowerShell for Azure […]
How to work with the command line and Azure to automate tasks
April 20, 2015Introduction The sqlcmd is a very powerful tool to run SQL Server scripts, T-SQL commands. It is also very useful in disaster recovery situations like restoring the master database. The sqlcmd can also be used in the Cloud, specifically with SQL Server Azure. In this new article, we will describe how to connect from a […]
How to export a local table to an Azure VM
March 31, 2015Introduction In my last chapter, How to migrate your database to an Azure Virtual Machine I showed you the steps to connect to a SQL Server in an Azure VM by using SQL Server Management Studio (SSMS). In this new chapter, we will show you how to work with SQL Server Integration Services (SSIS) to […]
How to migrate your database to an Azure Virtual Machine
March 31, 2015In one of my articles about Microsoft Azure, I show how to create credentials and how to connect to an Azure Database using SQL Server Management Studio (SSMS). In this new article, we will talk about the Azure Virtual Machines and we will learn how to connect to them using our local SSMS. You will […]
Integrate On-Premises and Azure using a site-to-site VPN with RRAS (step-by-step)
March 3, 2015In order to connect on- premise and Azure we have two options, a point-to-site and a site-to-site VPN. On this article I will be showing how to configure a site-to-site VPN using a routing and remote access, step-by-step.
Creating Azure automation to start Azure VMs
February 2, 2015When you have created a series of Azure VMs – for example for doing demos – you might want to be able to start it and shut it down easily. For convenience purposes but also for keeping the cost down while you’re not using the Azure VMs. In this case Azure Automation comes handy.
How to backup SQL Server databases to Microsoft Azure
January 22, 2015In the last chapter, we explained how to create a Microsoft Azure Account and how to have a Microsoft Azure Portal. This time, we will show how to backup our SQL Server Databases to a Microsoft Azure. We are assuming that you already have an Azure account.