Floating FB popout byF5debug

Windows Phone development explained step by step with a 31 days series with source code and example in detal!!!
Detailed interview question and answers on .Net Framework, ASP.Net, C#, SQL Server, OOPS and WCF!!!
A free download to the community, which has the step by step tutorial on Learning SQL Server Integration Services!!!
A free download to the community, which has the step by step tutorial on Learning Windows Phone Development!!!

SQL Server Integration Services (SSIS) – Part 55 – Connection Managers in SSIS

  This is part 55 of the series of article on SSIS Introduction: In this article we are going to see on the different connection managers available in SSIS packaging and the purpose of each transformation. We have 17 different connection managers across the SSIS packaging in order to use it for different purposes. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx [more] List of Connection Managers: S No Name Short Description 1 ... [更多...]

SQL Server Integration Services (SSIS) – Part 54 – Transformation Categorized in SSIS

  This is part 54 of the series of article on SSIS Introduction: In this article we are going to see on the different transformation on how they are categorized to use it across the package. This categorization is based on the usage of the transformation and the process on how it can be used across. The brief description of each of the transformations are available in my previous articles. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx [more] We can partition the transformation into 7 types as shown below Row Transformations ... [更多...]

SQL Server Integration Services (SSIS) – Part 53 – Multi Cast Transformation in SSIS

  This is part 53 of the series of article on SSIS Introduction: In this article we are going to see on how to use the Multicast transformation in SSIS packaging. Multi cast transformation is used when a portion of the data needs to be transferred to some other flow which is something similar to Conditional task which do the same process. The difference between the Multicast and the conditional split transformations are multicast direct each row of the source to the every output where as in the conditional split it directs a row to a single output. So using the multicast we can create... [更多...]

SQL Server Integration Services (SSIS) – Part 52 – Merge Join Transformation in SSIS

  This is part 52 of the series of article on SSIS Introduction: In this article we are going to see on how to use the Merge Join Transformation in SSIS packaging. Merge Join Transformation is similar to merge transformation is it handles multiple data from different source and merges into one process and handles it as if it came from a single source. Also Merge simply recombines portions of the data flow without changing the shape of the buffer, much like a UNION but which maintains the sort order.  Merge Join add elements to the buffer which will change its shape, similar to an ... [更多...]

SQL Server Integration Services (SSIS) – Part 51 – Merge Transformation (Setting Sorting) in SSIS

  This is part 51 of the series of article on SSIS Introduction: In this article we are going to see on how to set the sorting properties of the merge transformation. In my previous article you can see the steps on how to use the merge transformation. To set the transformation merge we need to follow some setting which should be taken in the Source data source. [more] Let’s jump start to see this sample on how to set the properties of the sorting. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx Steps: Follow steps 1 to 3 on my firs... [更多...]

SQL Server Integration Services (SSIS) – Part 50 – Merge Transformation in SSIS

  This is part 50 of the series of article on SSIS Introduction: In this article we are going to see on how to use Merge transformation in SSIS Packaging. Merge transformation is used in cases where we need to get data from 2 different data source and merge in order specified and send the result to the destination. Merge transformation can be very effective when we need to do manipulation across the data sets or the data source. [more] Let’s jump start on how to use this task in real time and see the steps to do the configurations. You can look into my series of article on SSIS at t... [更多...]

SQL Server Integration Services (SSIS) – Part 49 – Real time Examples of Data Flow Transformations in SSIS

  This is part 49 of the series of article on SSIS Introduction: In my series of articles there are few scenarios where we need to take care of some real time samples and examples to explain the task to reach it to the end users. So I can up with this article on to show some real time scenarios for each and every transformation. There are 28 data flow transformations and I grouped them below to give some real time idea on my working experience with those controls. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx [more] List of 28 Tran... [更多...]

SQL Server Integration Services (SSIS) – Part 48 – Lookup Transformation in SSIS

  This is part 48 of the series of article on SSIS Introduction: In this article we are going to see on how to use Lookup Transformation in SSIS Packaging. Lookup transformations are mainly used to provide a join with some other source with the current source and fetch the result in a much needed format. Joining source can be any one of the following: cached objects, a table, a destination file source, a result from a query etc. Lookup transformations are available for the below data sources only SQL, Oracle and DB2.  [more] Let’s jump start on how to use this task in real time... [更多...]

SQL Server Integration Services (SSIS) – Part 47 – Import Column Transformation in SSIS

  This is part 47 of the series of article on SSIS Introduction: In this article we are going to see on how to use Import Column transformation in SSIS. Import column is used in order to import some data from a file to the data flow and do some manipulations and then forward the data to the destination, here the data includes a binary file, an image, a media, or any sort of document which is huge to handle across. If we want to move a huge file from one location to the other using the package we can use this to import them using this transformation. [more] A practical exposure to thi... [更多...]

SQL Server Integration Services (SSIS) – Part 45 – Fuzzy Grouping Transformation in SSIS

  This is part 45 of the series of article on SSIS Introduction: In this article we are going to see on how to use the Fuzzy Grouping task. This task is mainly used to group some similar data in a row and cleaning the duplicates to maintain a standard of the table. This task requires a connection to the SQL database that the transformation algorithm requires to. Let’s jump start to the section on how to do that using a sample package. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx [more] Steps: Follow steps 1 to 3 on my first artic... [更多...]

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter
F5debug | SQL Azure – What’s new in SQL Azure Q2 2011 Service Update – Part II

Floating FB popout byF5debug

SQL Azure – What’s new in SQL Azure Q2 2011 Service Update – Part II

 

Introduction:

In this article we are going to see some of the new enhancement from the SQL Azure Q2 2011 release. In our earlier article we have seen on the replacement of the Database Manage Tool to the new SQL Azure Management Portal with rich user interface and enhanced options for the developers and the administrators as well.

Overview:

Previous article provides the overview of the new SQL Azure Management Portal with the different options to manage the database from the administrator level and also from the developer level. In this article we will see how exactly we can use the Manage Portal interface to administer the database. In our next article we will see for the developers on how to use the portal.

[more]

From Administrator perspective we can see that similar to the Windows Azure Management Portal, Microsoft Azure team has provided the Tabbed Menu to switch over from the Database Administration Mode to the Developer Mode(Handling Schema and Data).

Let us see the step by step process on how to use the SQL Azure Administration portal to Create, Deploy, Extract and Drop database.

Steps:

Login to the Windows Azure Management Portal using the below link(Need to have valid subscription)

www.microsoft.com/windowsazure/

clip_image002
We need to provide our login credentials by clicking on the Sign in to management portal as highlighted in the above screen, after successful login we will redirected to a nice interface as shown in the screen below.

clip_image004
Now click on the Database tab in the left side menu of the Management portal and we can see a nice interface as shown in the screen below.

clip_image006

Now we can see a nice interface with a Ribbon Menu at the top with different options to manage the database server and the database. Now click on the Manage Button of the Server Configuration tab as highlighted in the screen below.

clip_image008

Clicking on Manage Database server button will launch a new SQL Azure Management Portal. We need to provide the Administrator credentials(Which we have given while creating a server) to get authenticated and login to the server. The SQL Azure Management Portal will look as shown in the screen below.

clip_image010

After successful authentication, we can see the SQL Azure Management Portal with the different options(Administrators & Developers) similar to the Windows Azure Management Portal tabs as shown in the screen below.

clip_image012

We can see there are 3 set of workspaces available (Overview, Database Life Cycle, Database Schema and Data) with the Q2 2011 release, in future Microsoft has planned to put on more workspaces to provide much user accessibility to manage tasks with SQL Azure.

Note: In order to get the Database Life Cycle tab we should not provide the Database Name in the Logon Screen.

Now let us see the different tasks available for administrating the database one by one.

Create Database: This option is straight forward used to create a database. Click on the Create Ribbon button as shown in the screen below.

clip_image014

We can see a user input screen requesting for the Database Name and the Edition to be selected based on the requirement as shown in the screen below.

clip_image016

Once provided the valid database name and edition click on Submit to complete creating the database. On successful database creation we can see that the portal redirects to the Developer workspace showing the details of the database and options to do the development tasks as shown in the screen below.

clip_image018

Now we are done with the Creation of Database, Let us see the option of dropping the database from the Management Portal. Now go back to the Database Life Cycle by clicking on the left menu tab as shown in the screen below.

clip_image020

Now click on the Drop Database ribbon button to delete the database from the server as shown in the screen below.

clip_image022

We can see a user request, requesting a confirmation of the action to proceed further and delete the database from the server as shown in the screen below.

clip_image024

Now to confirm deleting the database click on OK button. we can see the deletion action gets started and in progress as shown in the screen below.

clip_image026

Once the action gets completed(Delete Database) we can see the database removed from the list as shown in the screen below.

clip_image028

We can see the details of the deleted database by clicking on the Details link as shown in the screen below.

clip_image030

In Our Next  article we will see the Import and Export options used with the database administrator tasks.

Conclusion:

So in this article we have seen the enhanced options with the SQL Azure Management Portal specific to database administrators like Creating and Dropping a database. In our next article we will see the other options of Import and Export the Data Tier application objects.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter