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 | 7,511 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,397 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,569 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,210 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,327 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,394 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,366 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,286 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,875 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,194 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,589 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)