Step by Step Windows Azure account creation trail-account

What is Windows Azure?

Windows Azure is a cloud services operating system that serves as the development, service hosting and service management environment for the Windows Azure platform. Windows Azure provides developers with on-demand compute and storage to host, scale, and manage web applications on the internet through Microsoft datacenters.

Windows Azure is a flexible platform that supports multiple languages and integrates with your existing on-premises environment. To build applications and services on Windows Azure, developers can use their existing Microsoft Visual Studio expertise. In addition, Windows Azure supports popular standards, protocols and languages including SOAP, REST, XML, Java, PHP and Ruby. Windows Azure is now commercially available in 40 countries.

Now look at the screen shots and you will know how to create Azure trail version account to introduce yourself with Cloud.

When you try to connect to Windows azure you will get this message

Trail version registration starts here

You need to have Microsoft live account to get Azure registration

You need to give your Master visa card or Credit card Information, You will not charged anything on this information during trail version and without your notification

Verify your account using your Mobile phone information

Now you have registered your account, This update will take 5 to 10 minutes to implement

Here you start configuring your Azure VM account to use Cloud services

Main menu configuration

If you find any notification and error message you can use right bottom of your screen

We have successfully created and configured our Windows Azure trail version account. In next post we will see how can we create SQL Azure database and use simple SQL Queries through Azure Management Studio and SQL Server Management Studio

Step by step installation SQL Server 2012 Express (The Cloud-Ready Information Platform).

SQL Server 2012 is on the go and there are many beneficial features are available now.

Most beneficial feature to use in SQL Server 2012 is Cloud ready platform. It means if you want to use SQL Azure through SSMS on your machine you need sql server 2012 on your machine first.

Another beneficial feature for me is to use SQL Azure Express with Advance features through which you can use most of the new features and reporting services as well.

All SQL Server service packs are cumulative, meaning that each new service pack contains all the fixes that are included with previous service packs and any new fixes.

Microsoft SQL Server 2012 Builds

Build	File version	KB / Description	Date Updated	Availability
11.00.3000	2011.110.3000.0	SQL Server 2012 Service Pack 1 (SP1)	November 6, 2012	Downloadable
11.00.2100	2011.110.2100.60	SQL Server 2012 RTM	March 6, 2012	Downloadable (MSDN/TechNet subscribers only)

A complete list of updates available on this link
sql server builds

Lets see how can we install SQL Server 2012 Express with Images (Step by step).

Prerequisites

Start Planning Installation

Starting New Stand alone SQL Server setup

Check for updates

Installing setup files

Features selection

Services settings

Set security mode

SSRS configuration options

Distribution directories 

Installation summery

Installation successful. Ready to use

Finding Deadlock with Query

Problem: I have faced many times from support team that they are facing timeouts from database server and database team needs to look at it and resolve the issue as soon as possible.

I have list of blogs available on net and on my blog site that can detect deadlocks from Profiler but I need to find blocking processes from Query and kill that process if it is not critical.

To do that I got following Queries.

=============================================


select top 5 cmd,* from sys.sysprocesses
where blocked > 0

select * from sys.dm_tran_locks

exec sp_lock

Once decided use this command to kill process

Kill (Process ID)
==============================================

Blocked column shows data "1" or "True" in case of blocking process. Once you find blocked process look at the "cmd" column values and decide if you need to kill that process. 2nd and 3rd query also shows locking queries. Following are the result set of queries.