part 8 of “Getting started with SQL Azure” series is live!

Standard

Aim of “Getting started with SQL Azure” series is to offer you a set of brief articles that could act as a Launchpad for your to-be wonderful journey of exploring Microsoft’s cloud based database solution i.e. SQL Azure.

 

In part 8, I have discussed following administrative tasks:

1. Managing firewall rules

2. Managing SQL Azure servers, databases and Logins

3. Troubleshoot connection issues

4. Monitoring database size and costs

5. Monitoring SQL Azure availability

6. Migrating to SQL Azure

 

URL: http://beyondrelational.com/blogs/parasdoshi/archive/2011/11/28/getting-started-with-sql-azure-part-8-sql-azure-administration-ii-lt-lt-paras-doshi.aspx

 

Summary:

Part 1: We defined SQL Azure and discussed advantages of SQL Azure

Part 2: We created an Azure account and created our very first SQL Azure database

Part 3: We discussed about the provisioning and the billing model of SQL Azure

part4: We discussed the SQL Azure architecture

part 5: we discussed the SQL Azure security model

part 6: We discussed how to migrate databases to SQL Azure.

Part 7: We discussed how to improve performance and backup options in SQL Azure

part 7 of “Getting started with SQL Azure” series is live!

Standard

Aim of “Getting started with SQL Azure” series is to offer you a set of brief articles that could act as a Launchpad for your to-be wonderful journey of exploring Microsoft’s cloud based database solution i.e. SQL Azure.

In part 7, I have discussed following administrative tasks:

1. How to improve performance

2. Backup and restore Strategies

 

URL: http://beyondrelational.com/blogs/parasdoshi/archive/2011/11/27/getting-started-with-sql-azure-part-7-sql-azure-administration-i-lt-lt-paras-doshi.aspx

 

Summary:

Part 1: We defined SQL Azure and discussed advantages of SQL Azure

Part 2: We created an Azure account and created our very first SQL Azure database

Part 3: We discussed about the provisioning and the billing model of SQL Azure

part4: We discussed the SQL Azure architecture

part 5: we discussed the SQL Azure security model

part 6: We discussed how to migrate databases to SQL Azure.

Part 7: We discussed how to improve performance and backup options in SQL Azure

Book Review: SQL server Interview Questions and Answers by Pinal Dave and Vinod Kumar.

Standard

Though SQL server is an huge ocean – this book does justice to touch-base on every different aspect of the product. Starting from the basic concepts and then discussing Tricky questions, authors Pinal Dave and Vinod Kumar lucidly explains each aspect in a Question Answer Format.

Personally, i liked the Tricky question section because it made me think about the topic at hand. And i believe, this exercise of thinking on my feet after reading the question will help me tackle questions during interviews that require quick thinking. And for questions which i knew, i learned the perfect way of answering them.

And every chapter, ends with a summary (called points to ponder) which is an excellent place to reflect upon and test one’s knowledge. And even if you are not planning to go for interview’s in near future – this book is a handy reference for all FAQ’s you may have on a day-to-day basis.

It’s an excellent book to master the SQL server Basics and Gain confidence before a SQL server based Interview. And perfect for any who is a SQL server Database Developer or a SQL server DBA or planning to be one!

 

Review cross-posted from: http://www.amazon.com/review/R2R7QM1NFVI8RE/ref=cm_cr_pr_perm?ie=UTF8&ASIN=1466405643&nodeID=&tag=&linkCode=

part 6 of “Getting started with SQL Azure” is live!

Standard

Aim of “Getting started with SQL Azure” series is to offer you a set of brief articles that could act as a Launchpad for your to-be wonderful journey of exploring Microsoft’s cloud based database solution i.e. SQL Azure.

In part 6, I have discussed the SQL Azure security model:

http://beyondrelational.com/blogs/parasdoshi/archive/2011/11/21/getting-started-with-sql-azure-part-6-lt-lt-paras-doshi.aspx

Summary:

Part 1: We defined SQL Azure and discussed advantages of SQL Azure

Part 2: We created an Azure account and created our very first SQL Azure database

Part 3: We discussed about the provisioning and the billing model of SQL Azure

part4: We discussed the SQL Azure architecture

part 5: we discussed the SQL Azure security model

part 6: We discussed how to migrate databases to SQL Azure.

[Link] 2011 Testing latency between client and SQL Azure via client statistics in SSMS

Standard

As I write this blog post, There are six location options while provisioning a SQL Azure server. And so while provisioning a SQL Azure server, who may have to decide the optimal location of the SQL Azure server based on the criteria that the latency between your application and the SQL Azure server is the minimum. And as you may know, we get better performance – if we are able to minimize the latency between client and SQL Azure. So let’s get into action.

read more

yay! I passed Exam 70 583 PRO: Designing and Developing Windows Azure Applications

Standard

I passed the exam 70 583: ‘Designing and Developing Windows Azure Applications’

And I have listed the resources that helped me prepare for 70 583 here:

Top Five resources to help you prepare for “70 583 Designing and Developing Windows Azure Applications”

Forum Q&A: Best method to Migrate on premise to SQL Azure

Standard

Question:

What is the best method to use for copying an “On Premise SQL DB” to SQL Azure. I’ve used the generate script wizard method but it takes quite awhile to get everything setup.  I was looking a DAC Pack but I’m a little nervous using a command utility that you could easily use to wipe out a database on accident.  Looks like a great tool though. What do you recommend? Or, is the Generate Script method the best way to go? I noticed that SQL Azure requires Clustered indexes on all tables. I would imagine that this might be a hindrance to automated migration tools.

My Answer:

Generate script wizard is a great tool for smaller databases.

For bigger databases, You should consider using a combination of Generate script wizard for migrating schema and then BCP for data.

And http://blogs.msdn.com/b/sqlcat/archive/2010/07/30/loading-data-to-sql-azure-the-fast-way.aspx  has some great info.

And as far as i know, the SQL Azure Migration wizard creates scripts that does clustered index creation (if it does not exist) – so yes, that is taken care of.

And for more information on various options for schema migration and data migration that you have – I would suggest an article from solidq Journal: http://www.solidq.com/sqj/Pages/2011-May-Issue/Migrating-Data-into-Microsofts-Data-Platform-SQL-Azure.aspx. It also covers best practices while migrating data to SQL Azure.

Link:

http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/ebb9f077-2a89-4044-bf57-212d29b48a01/