Tag: SQL

database

Migrate Between Azure SQL Database and SQL Server

For years it’s been difficult to migrate a database that was built in SQL Server to Microsoft Azure SQL Database. Originally, the T-SQL support in Azure SQL wasn’t the same as SQL Server, which caused a lot of pain over the years. The T-SQL support in Azure SQL has been greatly updated / enhanced over the years, but at times a migration is still necessary. Fortunately, SQL Server Management Studio includes the “Deploy Database to Microsoft Azure Database Wizard” which has built-in support to migrate a database from SQL Server to Azure SQL Database. This tool actually works BOTH ways, from Azure to SQL Server and SQL Server to Azure! Read More

ArchitectureBookCertificationDevelopmentInfrastructure

35 Azure and Cloud eBooks for Amazon Kindle

Blog articles and Technical documentation are nice for learning technologies, but there are times when a good book just can’t be replaced. This is especially true when getting information from blogs that may have a snippet of “found code” that might or might not work as expected. At least properly technically reviewed book will have working code snippets and other directions / information.

So, here’s a bunch of eBooks on Azure topics that are available for the Amazon Kindle. After all, what better to read about the Cloud than with a “Virtual” book! Read More

database

Azure Infographic: SQL Server 2016

The SQL Server 2016 infographic provides a visual overview of SQL Server 2016 features: on-premises, in the cloud, and in between. How can your current skills and knowledge of SQL Server help you transition to SQL Server within a Virtual Machine in Microsoft Azure, or to an Azure SQL Database?

AzureInfographic_SQL2016

You can download the full infographic PDF at the following URL:

https://azure.microsoft.com/en-us/documentation/infographics/sql-server/

BookdatabaseInfrastructure

Free eBook: Migrating SQL Server Databases to Azure

eBookAzureMigratingSqlServerThe “Microsoft Azure Essentials: Migrating SQL Server Databases to Azure” book written by Carl Rabeler has been made a free eBook by Microsoft Press. This book is part of the “Microsoft Azure Essentials” books series. With this book you will learn how SQL Server in Azure is similar to SQL Server in an on-premises environment. You will also learn how they are different. The author, Carl Rabeler, is a content lead for Azure.com and will walk you through the steps of getting started with SQL Server in an Azure Virtual Machine as well as Azure SQL Databases. Read More

Storage

Azure SQL or SQL Server Database?

AzureSQLLogoBlackThere are many things to look at when either migrating an existing application or just building a new application to host on Microsoft Azure. Data storage is definitely a top concern, and along with that is the ability to use SQL Server in many cases. Fortunately, Microsoft Azure provides a couple options for using a SQL Database. Read More