Click here to monitor SSC
Mike Wood

Automating the Retrieval of SQL Backups from Windows Azure BLOB Storage

If your database server is in Azure, then it makes sense to do backups into Azure too. SQL Server 2014 supports backups to the cloud, and particularly well with Managed Backup. Once your backups are safely in an Azure BLOB, then what? Mike Wood takes up the story. Read more...

Mike Wood

An Introduction to Windows Azure Service Bus Brokered Messaging

As applications grow, a message queue system soon becomes the best way of achieving scalability. It is an obvious candidate for a cloud-based service, and Azure's Service Bus Brokered Messaging service is a robust and well-tried product. Mike Wood provides enough in this article to get you started. Read more...

Buck Woody

Data Science Laboratory System – Graph Databases

Graph database are an intriguing alternative to the relational model. They apply graph theory to record the relationships between entries more naturally, and are a good fit for a range of data tasks that are difficult in SQL. Buck Woody gives an introduction to Graph databases and shows how to get Neo4J up and running to get familiar with the technology. Read more...

Mike Wood

An Introduction to Windows Azure Table Storage

Windows Azure Tables are intended for the storage of large amounts of schemaless data. Tables are just containers of rows of data. Mike Wood describes the practicalities of getting started with using the system. Read more...

Tony Davis

Backup to the Cloud: The Silver Lining

Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery. Read more...

Mike Wood

An Introduction to Windows Azure BLOB Storage

Azure BLOB storage is persistent Cloud data storage that serves a variety of purposes. Mike Wood shows the basics of how to use it, from start through to snapshots and metadata; both from .NET, and by using the free tool, Cerebrata Azure Explorer. Read more...

David Poole

Big Data: Are We Looking at the Wrong "V"s?

For once, business people are excited about the importance of data and are interested in the business benefits of extracting insights from the data. Perhaps this is more of a cultural rather a technical initiative, and so we in the data industry should participate by redefining the concept of the three Vs to reflect business values rather than technical challenges. Read more...

Feodor Georgiev

Backups as a Cloud Service - an Alternative View

In most databases, very small percentage of data changes between SQL Server backups. We tolerate this because it keeps things simple, and we have grown used to cheap storage and fast networks. To exploit the value of Cloud services, should we be rethinking this in favour of backup strategies that optimise resilience and minimise downtime? Read more...

Feodor Georgiev

Uploading Data to Windows Azure SQL Database

One way of getting the advantages of the Cloud without having to migrate the entire database is to just maintain a copy of the data that needs to be accessible to internet-based users in Windows Azure SQL Database. There are various ways of keeping the two in sync, and Feodor describes a solution based in using SSIS Read more...

Grant Fritchey

Azure SQL Database Maintenance

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? Read more...

William Brewer

Database Cloud Backup Cribsheet

A secure cloud-based file system that can provide offsite backup is better than no offsite backup, but is there a beter way? Are there more opportunities in offsite backup for improving disaster recovery, or providing a scalable archive? Read more...

Richard Mitchell

3 tips for SQL Azure connection perfection

SQL Azure can come up with intermittent connection problems in production. To avoid these, make sure you use the correct connection string and use ReliableSqlConnection rather than SqlConnection Read more...

Bud Aaron

Writing a small application to manipulate the SQL Database firewall

How can you getting through the Azure firewall to allow remote access to SQL Azure, er Windows Azure SQL Database (formerly SQL Server Data Services, then SQL Services and SQL Azure)? The easy way is to use the Windows Azure Portal but you can also script the process to access the RESTful service Read more...

Roger Jennings

Free Private Data from Silos for Internal Use with Microsoft CodeName “Data Hub”

Both Amazon and Microsoft are hosting large datasets such as those used for healthcare. Windows Azure Marketplace DataMarket now gives enterprises a way of publishing or buying large datasets. This principle is now being extended to allow organizations to provide their knowledge workers with a central Self-Service private DataMarket. Read more...

Craig Box

Dial in the scale: Amazon’s new DynamoDB

Dynamo is a fast and scalable proprietary key-value structured storage system that gives the features of both simple databases and distributed hash tables (DHTs), running on SSD storage to provide other Amazon services such as S3. It it not ACID-compliant ore relational but is great for doing analysis on large amounts of simple data Read more...

Roger Jennings

Upload Big Data to SQL Azure Federated Databases with BCP Automatically

As long as you use TSQL DDL to do it, creating a federated SQL Azure database is simple. What, then, of populating it with data? It is surprisingly straightforward to upload data from a BCP file via secure TDS in parallel multiple connections, even when things go slightly wrong Read more...

Roger Jennings

Use OData to Execute RESTful CRUD Operations on Big Data in the Cloud

Microsoft's OData, the Open Data Protocol, allows consumers of data to get the metadata of data sources, to perform queries and, if necessary, to create, change or delete data items. It now provides the API for many of the available services on the internet, including the Open Government Data Initiative Read more...

Most Viewed

Windows Azure Virtual Machine: A look at Windows Azure IaaS Offerings (Part 2)
 We continue our introduction of the Azure IaaS by discussing how images and disks are used in the Azure... Read more...

PHPFog and Pagoda Box: A Look at PHP Platforms
 Cloud platforms such as Heroku, AppEngine, PHPFog and Pagoda Box are ideal for companies who just want... Read more...

An Introduction to Windows Azure BLOB Storage
 Azure BLOB storage is persistent Cloud data storage that serves a variety of purposes. Mike Wood shows... Read more...

Managing session state in Windows Azure: What are the options?
 Because you can't maintain session state for ASP.NET applications in Azure using the default in-process... Read more...

Creating a custom Login page for federated authentication with Windows Azure ACS
 Windows Azure Acess Control Service (ACS) provides a way of authenticating users who need to access web... Read more...