SQL-based distributed Cloud Relational databases aren't new, but Amazon's Aurora offers an alternative to SQL Azure, and, being MySQL-compatible, provides the obvious route to the cloud for hosted LAMP web applications. Is this of interest to the rest of us? Rob Sheldon investigates.… Read more
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
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
One of my main annoyances when dealing with SQL Azure is of course the occasional connection problems that communicating to a cloud database entails. If you’re used to programming against a locally hosted SQL Server box this can be quite a change and annoying like you wouldn’t believe. So after hitting the problem again in … Read more
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 servic… Read more
There are some essential tasks to be done in move existing applications to the cloud, because of the differences between the on-premise and cloud architecture, though the move from SQL Server 2008 to SQL Azure is generally straightforward. … Read more
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.… Read more
Because you can't maintain session state for ASP.NET applications in Azure using the default in-process method, you will need to opt for one of the other available methods, of which the most popular are Table storage, SQL Azure, or Windows Azure Caching.… Read more
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
The sale of a favourite software company can be disheartening for users, creating concern that the tools and team you love will vanish. Red Gate's Luke Jefferson and Matt Dickens, and Cerebrata's Gaurav Mantri, discuss how they plan to avoid acquisition pitfalls.… Read more
SQL Azure can take away a great deal of the maintenance work from a hosted database-driven website. It isn't perfect, however, in that it doesn't support the archiving of data by the users. Mike Mooney explains how he customised the solution with SQL Compare and SQL Data Compare to solve the problem of getting local backup copies of database schema and data.
… Read more
How you log in to Simple Talk has changed
We now use Redgate ID (RGID). If you already have an RGID, we’ll try to match it to your account. If not, we’ll create one for you and connect it.