SQLServerCentral.com Articles tagged Azure

Connecting to AdventureWorks on Azure

Mon, 20 May 2013 06:00:00 UT

A quick guide for connecting to our free copy of AdventureWorks on the Azure platform.

Azure SQL Database Maintenance

Mon, 20 May 2013 06:00:00 UT

It is increasingly likely that DBAs are now given responsibility for maintaining Azure SQL databases as well as conventional SQL Server databases. What is likely to be required by way of maintenence? What are the differences? Grant Fritchey covers what you need to know.

Community-driven free Azure tips eBook

Thu, 09 May 2013 06:00:00 UT

We’re putting together a free eBook of 50 tips for Azure Storage, if you’ve got tips that you’d like to share we’d love to hear from you.

BACPACs be gone: Managing real backups in Azure

Mon, 29 Apr 2013 06:00:00 UT

While backup to the Cloud may be useful in terms of optimizing storage across the enterprise, for DBAs it remains essential that they retain fast, easy, access to the backup files. Azure Explorer is a free tool that might help.

Deploying Databases to the Azure Cloud: an extended plea

Mon, 25 Feb 2013 07:00:00 UT

Is there a sound technical reason why SQL Azure can't support extended properties?

SSIS for Azure and Hybrid Data Movement

Tue, 19 Feb 2013 07:00:00 UT

SQL Server Integration Services (SSIS) can be used effectively as a tool for moving data to and from Windows Azure SQL Database, as part of the total extract, transform, and load (ETL) solution and as part of the data movement solution. SSIS can be used effectively to move data between sources and destinations in the cloud, and in a hybrid scenario between the cloud and on-premise. This paper outlines best practices for using SSIS for cloud sources and destinations and for project planning for SSIS projects to be used with Azure or hybrid data moves, and gives an example of maximizing performance on a hybrid move by scaling out the data movement.

Is it time to move from SQL Azure to Amazon RDS SQL Server?

Wed, 11 Jul 2012 06:00:00 UT

Amazon RDS SQL Server is the new kid on the block. Is it better than SQL Azure?

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Stop Food Waste - OS Open Data & SQL Azure

Thu, 14 Jun 2012 06:00:00 UT

An attempt to use Ordanance Survey OS Open Data, SQL Server and SharePoint in the construction of a system for supermarkets to supply expiring food to nearby homeless shelters.

Windows Azure from a Data Perspective

Tue, 22 May 2012 06:00:00 UT

Before creating a data application in Windows Azure, it is important to make choices based on the type of data you have, as well as the security and the business requirements. There are a wide range of options, because Windows Azure has intrinsic data storage, completely separate from SQL Azure, that is highly available and replicated. Your data requirements are likely to dictate the type of data storage options you choose.

How to Secure your SQL Azure Application

Mon, 12 Mar 2012 06:00:00 UT

Developers targeting the SQL Azure platform should make sure their applications are secure. This article walks through the considerations developers need to keep in mind when designing SQL Azure applications.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Buck Woody's Cloud Howlers

Tue, 14 Feb 2012 07:00:00 UT

We asked Buck Woody to come up with his favourite 'Cloud' Howlers. After 'Howler' monkeys, we are faced with Howler letters. Buck dreams of sending Howler letters to the folks who dreamed up the marketing hype around 'cloud' services, who misunderstand services, who don't prepares applications for distributed environments and so on.

Are you using Microsoft’s Azure platform?

Fri, 16 Sep 2011 06:00:00 UT

We are conducting new product research and are keen to speak to people who have any experience (good or bad!) using Microsoft's SQL or Windows Azure. If you're interested and would like to get involved--tell us your frustrations, shape a new product, test-drive betas etc

A Small Collection of SQL Azure Queries

Tue, 15 Mar 2011 06:00:00 UT

We have been doing some more work with SQL Azure lately, so I have put together a small collection of...

SQL Azure - Creating backups and copies of your databases

Thu, 10 Feb 2011 07:00:00 UT

As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you use a backup of your database and restore it in the respective environment. If you are moving to SQL Azure, what would you do in these cases as backup / restore and database snapshots are not supported as of now?

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Connect to a SQL Azure Database Using SSMS or SQLCMD

Thu, 27 Jan 2011 07:00:00 UT

Learn how you can connect to a SQL Azure database.

Getting Started with SQL Azure Development

Fri, 14 Jan 2011 07:00:00 UT

SQL Azure provides features similar to a relational database for your cloud apps. We’ll show you how to start developing for SQL Azure today.

Migrating Your SQL Server Database Applications to SQL Azure

Mon, 27 Sep 2010 06:00:00 UT

Most business applications you write probably utilize some kind of relational database. And, as a .NET developer, the chances are that database is Microsoft SQL Server. This article walks you through migrating your SQL Server database applications to the cloud with SQL Azure.

Synchronizing SQL Server and SQL Azure

Tue, 14 Sep 2010 06:00:00 UT

SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.

Connecting Your Zend Framework Application to Microsoft Azure

Tue, 20 Apr 2010 06:00:00 UT

After years of using PHP content management systems and a variety of custom-built PHP content management solutions, PHP Guru Jason Gilmore concluded that no solution effectively offered both the fundamental features of a content management system (CMS) and the flexibility of a web framework.

Azure Tutorial - Building a'Hello Word' app in Visual Studio

Fri, 12 Feb 2010 07:00:00 UT

This article demonstrates how to build a simple Azure app using Visual Studio

Introduction to SQL Azure

Thu, 24 Dec 2009 07:00:00 UT

Learn how to get started working with SQL Azure and migrating SQL Server databases to SQL Azure.

SQL Azure with ASP Dot Net

Fri, 11 Dec 2009 07:00:00 UT

Don Schlichting demonstrates the development of a SQL Azure ASP Dot Net application, leveraging our existing TSQL and Dot Net skills.

SQL Server Management Studio and SQL Azure

Wed, 09 Dec 2009 07:00:00 UT

A new article from Steve Moore shows us how to use SQL Server Management Studio with your SQL Azure databases in the cloud.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Building Windows Azure Cloud Service Applications with Azure Storage and the Azure SDK

Mon, 23 Nov 2009 07:00:00 UT

Windows Azure and Azure Storage offers a new scalable and robust architecture that borrows much from the common feel of ASP.NET applications but brings plenty of new features as well. This paradigm shift from what has become traditional client-server architecture will offer new options to developers and headaches alike. While "the cloud" is not intended to be the answer for all applications and situations, it can only be a potential answer (another "tool" in the proverbial "tool belt") if you have at minimum a general understanding.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

SQL Azure TSQL

Thu, 12 Nov 2009 07:00:00 UT

SQL Azure is very similar to traditional SQL Server and now supports many standard TSQL commands. This article demonstrates the use of TSQL commands to create SQL Azure objects.

Getting started with SQL Azure

Thu, 22 Oct 2009 06:00:00 UT

The cloud services from Microsoft for SQL Server are known as SQL Azure. MVP Jacob Sebastian brings us a introductory article about how to work with this service.

Cloud Computing with Microsoft Azure SDS

Tue, 21 Jul 2009 06:00:00 UT

Don Schlichting introduces the Microsoft Azure service and explores the SQL Data Services (SDS).

Patterns For High Availability, Scalability, And Computing Power With Windows Azure

Thu, 07 May 2009 06:00:00 UT

Now, Internet-hosted distributed applications with connectivity to internal applications—often referred as Software plus Services (S+S)—are gaining popularity. Organizations are leveraging datacenters hosted by third parties to alleviate concerns about hardware, software, reliability, and scalability. These are just some of the new architecture trends that help you build interoperable applications that scale, reduce capital expenditure, and improve reliability. Cloud computing offers many of these benefits.