Windows Azure SQL Database

Overview of Azure SQL Database Networking

• by Additional Articles

• MSSQLTips.com

• Azure SQL
• Azure SQL database
• Windows Azure SQL Database

• Article

Learn about the range of connectivity options available for Azure SQL Database deployments.

2019-12-20

System Stored Procedures for SQL Azure Linked Servers

• by Additional Articles

• MSSQLTips.com

• Windows Azure SQL Database

• Article

Microsoft released the preview version of Azure SQL Database V12 in December of 2014. As a database administrator, you might wonder about the schema and security of these new data marts. Microsoft has supplied system stored procedures for the database developer to query the Linked Servers for this type of meta data, as John Miner explains.

2015-06-05

2,288 reads

Introduction to Azure SQL Database Scalability

• by Additional Articles

• Database Journal

• Windows Azure SQL Database

• Article

One of the primary advantages of Platform-as-a-Service solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.

2014-12-17

8,467 reads

Management of Windows Azure SQL Databases via PowerShell with REST APIs

• by Additional Articles

• Database Journal

• Windows Azure SQL Database

• Article

Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly.

2014-08-22

8,728 reads

Microsoft Azure SQL Database Security - Firewall Configuration

• by Additional Articles

• Database Journal

• Windows Azure SQL Database

• Article

Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.

2014-04-22

3,521 reads

Windows Azure SQL Database - Uploading Data by Using the bcp Utility

• by Additional Articles

• Database Journal

• Windows Azure SQL Database

• Article

Instead of using a custom SSIS-based project to upload content from an on-premise SQL Server database to Azure PaaS-based SQL Database, Marcin Policht presents an alternative approach. Using the bcp utility not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.

2014-03-17

3,582 reads

Windows Azure SQL Database - Uploading Data by using SQL Server Integration Services

• by Additional Articles

• Database Journal

• Windows Azure SQL Database

• Article

Recently we presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance. Today we will accomplish the same objective by employing a more traditional approach to data extraction, transformation, and loading (ETL) that relies on SQL Server Integration Services (SSIS).

2014-02-18

3,765 reads

Migrating SQL Server Database to Windows Azure - Deploying SQL Database

• by Additional Articles

• Database Journal

• Windows Azure SQL Database

• Article

There are a few challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database. In this article we turn our attention to an actual deployment and migration of locally stored data to SQL Database.

2013-12-30

3,822 reads

Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues

• by Additional Articles

• Database Journal

• Windows Azure SQL Database

• Article

In this series on implementing data services in Azure, Marcin Policht turns his attention to the remediation of incompatibilities resulting from of limitations inherent to Platform as a Service (PaaS) based deployments, which will need to be addressed as part of the migration process.

2013-11-21

3,052 reads