Part 3 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 3, i have discussed:

1. Provisioning model of SQL Azure

2. Billing Model of SQL Azure

read more: Getting started with SQL Azure – Part 3 << Paras Doshi

 

just to recap:

In part 2, i have discussed:

1) How to sign up for a Free trial of windows azure (to play with SQL Azure)!

2) How to create your very first SQL Azure database (and a table too!)

3) How to connect to SQL Azure server Via SQL server Management studio.

Read more: Getting started with SQL Azure – Part 2 << Paras Doshi

 

And in part 1, i have discussed

1) Where SQL Azure fits in the windows azure platform?

2) Defined SQL Azure

3) Advantages of SQL Azure

Read More: Getting started with SQL Azure – Part 1 << Paras Doshi

 

SQLServer Quiz 2011 – Which are the options available to a DBA to tune a SQL Azure database?

Standard

This question that I contributed is a part of the ongoing SQL server Quiz 2011. To take part, please go to: http://beyondrelational.com/quiz/sqlserver/dba/2011/questions/186/which-are-the-options-available-to-a-dba-to-tune-a-sql-azure-database.aspx

The idea behind this question is two-fold:

1) To spread awareness that with SQL Azure we do need to tune the databases – that part does not go away. Though many of the tasks are offloaded to cloud, the fact is, if you write a bad query – it’s going to run bad on the cloud too. yeah, It’s that simple!

2) To learn what “tools” do we have as a DBA to tune those bad running queries.

So yeah, go ahead and send what you think at http://beyondrelational.com/quiz/sqlserver/dba/2011/questions/186/which-are-the-options-available-to-a-dba-to-tune-a-sql-azure-database.aspx and ALL the best for the Quiz and it’s results! May you walk away with Apple iPad  given by Redgate – it’s an awesome prize!

And I would thank Jacob sir for inviting me as a Quizzer (Now I have a badge on my beyond relational profile!) for this wonderful Quiz he runs! Thanks sir.

And all the best for Quiz again. Have fun!

It’s my birthday! And hey – it’s the 100th post!

Standard

It’s my birthday!

And this is the 100th post on this blog!

And I am just 100 22 btw!

Any-who. This is what happened to me last time (In India):

And what’s on me: Toothpaste + Tomato Sauce + Wierd water + coke + sprite + I don’t know what else.

And that’s pretty much how birthdays are “celebrated” at 00:00 AM in India!

I know it sounds dirty but wait..it’s lot of fun! And you get to “return the favor” when it’s someone else’s Birthday.

Any-who I’ll be spared this time. Woohooo!

It’s birthday Time:

Has “Cloud Computing” replaced “Distributed computing”?

Standard

Have you heard about “Cloud Computing”? – of course you have, haven’t you? Have you heard about “Distributed Computing” – It’s great if you have. If you haven’t, no worries because that’s not your doing. you know why? because using this word is not in fashion anymore. yeah! [ I know I am talking fashion – how about that! ] Let’s put in differently, using the word “Distributed computing” is passé. want stats? Here they are:

image

Link: http://ngrams.googlelabs.com/graph?content=distributed+computing&year_start=1800&year_end=2011&corpus=0&smoothing=1

More info about the stats:

Google is crazy! And I like crazy. What they are doing is digitizing zillions of book out there. And this tiny little Google lab thingy called NGram Viewer graphs (outputs) the occurrence of the “inputted word” in millions of books with respect to time. Sweet! so I have used this tool to draw a conclusion – which is my very own crazy speculation. Actually, I came to know about this tool and I ran some crazy experiments by inputting ****, **, **, ***, *****, ********, ********, * **** ** **** ***,etc. Then I don’t know what got me inputting “distributed computing”, “cloud computing”, etc etc – And the result is in front of you.

Anyways. The result shows only up to year “2008”. And if you note, I have inputted 2011 as year-end in my query but it just does not work. But you do get the point don’t you?!

Now how about “cloud computing” – BOOM! BOOM! BOOM! uncanny rise:

image

So a logical speculation is that “cloud computing” is replacing the use of “distributed computing”. Isn’t it?!

Any-who. whatever it is – it is pretty interesting. Let’s have some fun:

How about: Cloud computing vs Distributed computing vs Microsoft vs Google vs Facebook:

image

Facebook and cloud computing are recent trends. And as the graph shows they did not appear as many times as we might have guessed. But remember that it’s just until 2008. I wish we had data up to 2011!

That’s about it. Have fun with this tool!

About Google NGram Viewer: http://ngrams.googlelabs.com/info

How did I came to know about it? http://www.ted.com/talks/what_we_learned_from_5_million_books.html

Did I tell my friends about it? of course, I did:

image

And what about facebook? I would have done that if facebook had hastags (Alas it does not have it). And why did i shared it *ONLY* twitter because *ONLY* “hashtags” care for what I have to say. I know, it’s sad. But of course, you do – I can say because you read my entire post! if you liked it connect with me on twitter: Paras_Doshi!

How to avoid Men in Middle attack when you try establishing a new connection to SQL Azure via SSMS

Standard

Fact: All connections with SQL Azure are SSL encrypted. No exception.

Then what am I talking about? Why do I need to worry about Men in Middle attack now?

Turns out there’s a way, Men in Middle attack can happen – Not on your established connection But when the client first tries to establish a new connection. And in this blog post, we are going to see how to avoid Men in Middle attack when you first try establishing a new connection via SSMS.

BTW: I have not researched on how to do it from developers perspective, but if any developer is reading this and has figured it out – it would be great if you can share it with us via any communication means of your choice. (Thanks a lot – if you do so).

[Update: See Bottom of the post]

Any-who. Back to SSMS.

All you got to do to avoid this improbable situation to happen is just check the “Encrypt connection”in the connection property when you try establishing a *new* connection to SQL Azure.

That’s it.

if the client requests encryption from the beginning then our connection is not susceptible to Men in Middle attach while the client is negotiating with the server for encryption.

Categorize under “Best practice” if  you wish to.

 

Update: Developers, When you connect to SQL Azure using ADO.Net – please do not forget to set 1. Encrypt = TRUE and 2. TrustServerCertificate = False  to avoid man in middle attack.

 

And Thanks to Herve Roggero for his response on my (poorly framed) question on StackOverflow. I am glad, he understood what I meant!  Thanks sir 🙂

[Link] Tuning SQL Azure Databases << My SolidQ Journal articles

Standard

“Even if cloud computing hides some back-end complexity from us, databases still need to be properly designed and queries properly written. To this end, Paras Doshi explains how to tune SQL Azure databases” – Excerpt from Editorial by Fernando G. Guerrero, Global CEO, SolidQ

Read:

Part 1: http://www.solidq.com/sqj/Pages/2011-July-Issue/Tuning-SQL-Azure-Databases-Part-1.aspx
Part 2: http://www.solidq.com/sqj/Pages/2011-September-Issue/Tuning-SQL-Azure-Databases-Part-2.aspx

Read SolidQ Journal: www.solidq.com/sqj

My article on “Tuning SQL Azure databases – Part 2/2” got published in SolidQ Journal’s september edition

Standard

Part 2/2 of “Tuning SQL Azure Databases” got published. The aim of the series was to show you the options that are available to tune a SQL Azure database. In part two, I  discuss on how to use information made available through dynamic management views (DMV’s) available in SQL Azure; while the first part focused on examining execution plans and tuning the database based on that information. Here are the links to download the magazine:

Part 2: http://www.solidq.com/sqj/Pages/2011-September-Issue/The-SolidQ-Journal-September-2011.aspx

Part 1: http://www.solidq.com/sqj/Pages/2011-July-Issue/The-SolidQ-Journal-July-2011.aspx