In SQL Azure you have 3 copies of your databases in 3 different geographical locations in case of harware failure etc. But how do you handle human failures, like deleting or updating wrong records? The best soluti…

This is day 8 of my series, and I had to go back to the blog from day 3 to complain about the connection problem, please revisit day three and get back here.

Is the SQL Azure platform Enterprise or Standard edition? We alr…

As I mentioned in an earlier blog post, In SQL Azure you can’t set the Fill factor of the indexes and you get the server default for every index in all your databases. Let’s take a look by executing the follo…

In SQL Azure you have to define the max size of your database and you pay for that size. When you reach that limit, your database will set to read only and connections trying to modify the data will be terminated. You now h…

Is there a tempdb database in SQL Azure? Well, if you try to find tempdb, you’ll fail. You can’t find the tempdb databas anywhere in management portal or in SQL Server Management Studio. But is there a tem…

Vi har just nu stor efterfrågan på BI konsulter och därför söker vi ännu en erfaren SQL Server BI konsult. Vi vill att du har minst 5 års praktisk erfarenhet som dedikerad SQL Server BI Konsult, gärna i stora, kritisk…

When you design your database tables there are some important things to think of. Some of them are important in a normal database also, but they are much more important in SQL Azure, like:

• Normalize to remove redundan…

First of all, you have to open the firewall for your IP addresses in Windows Azure Plattform portal to be able to connect to a SQL Azure database. Do you want to know whats annoying with that? Well, I write my blog posts on…