Showing posts with label Android Source code and tutorials. Show all posts

Differences between SQL Server 2000, 2005 and 2008

Differences between SQL Server 2000, 2005 and 2008

The main differences among SQL Server 2000, 2005 and 2008 are shown in the following table.

S.NO	SQL SERVER 2000	SQL SERVER 2005	SQL SERVER 2008
1	Query Analyzer and Enterprise manager are separate.	Both are combined as SQL Server management Studio (SSMS).	Both are combined as SQL Server management Studio (SSMS).
2	No XML datatype is used.	XML datatype is introduced.	XML datatype is used.
3	We can create a maximum of 65,535 databases.	We can create 2(pow(20))-1 databases.	We can create 2(pow(20))-1 databases.
4	Nill	Exception Handling	Exception Handling
5	Nill	Varchar(Max) data type	Varchar (Max) data type
6	Nill	DDL Triggers	DDL Triggers
7	Nill	DataBase Mirroring	DataBase Mirroring
8	Nill	RowNumber function for paging	RowNumber function for paging
9	Nill	Table fragmentation	Table fragmentation
10	Nill	Nill	Nill
11	Nill	Bulk Copy Update	Bulk Copy
12	Nill	Can't encrypt	Encrypt the entire database introduced in 2008.
13	Can't compress the tables and indexes.	Can compress tables and indexes (introduced in 2005 SP2).	Compress indexes.
14	Datetime datatype is used for both date and time.	Datetime is used for both date and time.	Date and time are separately used for date and time datatype.
15	No table datatype is included.	No table datatype is included.	Table datatype introduced.
16	No SSIS is included.	SSIS is started using.	SSIS avails in this version.
17	CMS is not available.	CMS is not available.	Central Management Server (CMS) was introduced.
18	PBM is not available.	PBM is not available.	Policy based management (PBM) server was introduced.
19	PIVOT and UNPIVOT functions are not used.	PIVOT and UNPIVOT functions are used.	PIVOT and UNPIVOT functions are used.

Overview and advantages of SQL Server 2008 depending on our need

SQL Server 2008 can be a data storage backend for various varieties of data: XML, time/calendar, file, document, spatial, and so on as well as perform search, query, analysis, sharing, and synchronization across all data types.

Other new data types include specialized date and time types and a Spatial data type for location-dependent data. Better support for unstructured and semi-structured data is provided using the new FILESTREAM data type, that can be used to reference any file stored on the file system. Structured data and metadata about the file is stored in SQL Server database, whereas the unstructured component is stored in the file system. Such files can be accessed both via Win32 file handling APIs as well as via SQL Server using T-SQL.

SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data, such as query, search, synchronize, report, and analyze.

SQL Server 2008 provides the highest levels of security, reliability, and scalability for your business-critical applications.

SQL Server 2008 also natively supports hierarchical data, and includes T-SQL constructs to directly deal with them, without using recursive queries.

Android application tutorials

This example shows how create ImageGallery in android.

Algorithm:
1.) Create a new project by File-> New -> Android Project name it ImageGalleryExample.
2.) Add some sample .png image files to res/drawables folder.

3.) Write following into main.xml file:

Hello world first Android application

Following is a step by step guide in creating your first "Hello World" Android application.It was created with the following setup:

Windows (I happen to be using Windows 7, but any flavor of windows will do)
Eclipse IDE for Java Developers (v3.5 Galileo)
Java Platform (JDK 6 Update 18)
Android SDK Tools, Revision 4

Let's get started...

Getting started with Android A step by step installation guide

Step 1:Preparing Your Development Computer

First You need to install JDK (Java Development Kit) in your computer.
You should check your hardware configuration as given check here.
If you need eclipse then you can download it from here.
http://www.eclipse.org/
The "Eclipse Classic" version is recommended. Otherwise, a Java or RCP version of Eclipse is recommended.

Step 2:Downloading SDK starter package.

SDK(Standard Development Kit)-It includes only the core SDK Tools, which you can use to download the rest of the SDK components (such as the latest Android platform).
Download from this link.
http://dl.google.com/android/android-sdk_r16-windows.zip http://dl.google.com/android/android-sdk_r16-windows.zip
Unzip that file in your Drive. ex: d:\android\
You will get folder like this android-sdk-<machine-platform>.

ex: android-sdk-windows

Now run eclipse.exe

Step 3. Installing the ADT Plugin for Eclipse

Android offers a custom plugin for the Eclipse IDE, called Android Development Tools (ADT), that is designed to give you a powerful, integrated environment in which to build Android applications.
For that you need to download ADT plugins.
http://dl.google.com/android/ADT-16.0.1.zip
For step-by-step installation instructions, then return here to continue the last step in setting up your Android SDK.
If you prefer to work in a otherIDE, you do not need to install Eclipse or ADT. But i personally suggest you to use Eclipse. (Eclipse Indigo)
The Introduction to Android application development outlines the major steps that you need to complete when developing in Eclipse or other IDEs.

Step 4. Adding Platforms and Other Components

The last step in setting up your SDK is using the Android SDK and AVD Manager (a tool included in the SDK starter package) to download essential SDK components into your development environment.
The SDK uses a modular structure that separates the major parts of the SDK Android platform versions, add-ons, tools, samples, and documentation into a set of separately installable components.
The SDK starter package, which you've already downloaded, includes only a single component: the latest version of the SDK Tools. To develop an Android application, you also need to download at least one Android platform and the associated platform tools. You can add other components and platforms as well, which is highly recommended.
If you used the Windows installer, when you complete the installation wizard, it will launch the Android SDK and AVD Manager with a default set of platforms and other components selected for you to install.
Simply click Install to accept the recommended set of components and install them. You can then skip to Step 5, but we recommend you first read the section about the Available Components to better understand the components available from the Android SDK and AVD Manager.
You can launch the Android SDK and AVD Manager in one of the following ways:

From within Eclipse, select Window > Android SDK and AVD Manager.
On Windows, double-click the SDK Manager.exe file at the root of the Android SDK directory.
On Mac or Linux, open a terminal and navigate to the tools/ directory in the Android SDK, then execute.

To download components, use the graphical UI of the Android SDK and AVD Manager to browse the SDK repository and select new or updated components (see figure 1). The Android SDK and AVD Manager installs the selected components in your SDK environment. For information about which components you should download, see Recommended Components.