Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Windows Azure SQL Database Rss

   Items 1 to 11 of 11   
 

Introduction to Azure SQL Database Scalability

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,268 reads

Management of Windows Azure SQL Databases via PowerShell with REST APIs

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 8,340 reads

Using PowerShell to Manage Windows Azure SQL Databases

Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).  Read more...
By Additional Articles 2014/07/18 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 2,483 reads

Microsoft Azure SQL Database Security - Firewall Configuration

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,173 reads

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

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,301 reads

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

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).  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,343 reads

Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files

Marcin Policht shows you how to migrate on-premise data that is already cloud-compliant to Windows Azure SQL Databases by converting it into a BACPAC formatted file.  Read more...
By Additional Articles 2014/01/21 | Source: Database Journal | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 3,301 reads

Stop & Start Your VM’s on Azure with Powershell

This is a very simple script can be used as a framework for you to stop and start your VM’s on Azure with Powershell.  Read more...
By Additional Articles 2014/01/10 | Source: TechNet Blogs | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,154 reads

SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines

This article describes how to use the new wizards in SQL Server Management studio to get access to Windows Azure and then create and configure your VM.   Read more...
By Additional Articles 2014/01/08 | Source: TechNet Blogs | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 1,802 reads

Migrating SQL Server Database to Windows Azure - Deploying SQL Database

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,129 reads

Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,529 reads
   Items 1 to 11 of 11   
 
Tags
azure (5)    
migration (4)    
powershell (2)    
vm (2)    
bacpac (1)    
bcp utility (1)    
integration services (ssis) (1)    
paas (1)    
sql azure (1)