Microsoft SQL Database @ eIT.in

This section of eIT.in provides web resources for MS SQL database. 

Add Links: If you have a web site that you wish to include in this database, do let us know the details by sending a note about your URL to narsi@esource.in. We’ll quickly review the web site, and if found relevant, add it to the database. We look forward to web site owners and link exchange partners to submit URL. Thanks!  

Looking for an outsourcing partner for MS SQL database programming, applications development and SQL administration? Have you talked to us?

Contents derived from Wikipedia article on MS SQL Server

Microsoft SQL Server

From Wikipedia, the free encyclopedia

Microsoft SQL Server 

Developer: Microsoft

Latest release: 2005 / November 7, 2005

OS: Microsoft Windows

Use: RDBMS

License: Microsoft EULA

Website: www.microsoft.com/sql/

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Microsoft and Sybase. SQL Server is commonly used by businesses for small- to medium-sized databases, but the past five years have seen greater adoption of the product for larger enterprise databases.

Contents

1 History

2 Versions for Microsoft Windows

2.1 Releases

2.2 Versions for SQL Server 2005

2.3 Versions for SQL Server 2000

2.4 Versions for SQL Server 7.0

3 Description

4 SQL Server Express Edition

5 The slammer worm

6 Competition

7 Future development

8 Companion products

9 See also

10 References

11 Further reading

12 External links

History

The code base for Microsoft SQL Server (prior to version 7.0) originated in Sybase SQL Server, and was Microsoft"'s entry to the enterprise-level database market, competing against Oracle, IBM, and, later, Sybase itself. Microsoft, Sybase and Ashton-Tate originally teamed up to create and market the first version named SQL Server 1.0 for OS/2 (about 1989) which was essentially the same as Sybase SQL Server 3.0 on Unix, VMS, etc. Microsoft SQL Server 4.2 was shipped around 1992 (available bundled with Microsoft OS/2 version 1.3). Later Microsoft SQL Server 4.21 for Windows NT was released at the same time as Windows NT 3.1. Microsoft SQL Server v6.0 was the first version of SQL Server that was architected for NT and did not include any direction from Sybase.

About the time Windows NT was released, Sybase and Microsoft parted ways and pursued their own design and marketing schemes. Microsoft negotiated exclusive rights to all versions of SQL Server written for Microsoft operating systems. Later, Sybase changed the name of its product to Adaptive Server Enterprise to avoid confusion with Microsoft SQL Server. Until 1994 Microsoft"'s SQL Server carried three Sybase copyright notices as an indication of its origin.

Since parting ways, several revisions have been done independently. SQL Server 7.0 was the first true GUI based database server and was a rewrite away from the legacy Sybase code. A variant of SQL Server 2000 was the first commercial database for the Intel IA64 architecture. During this time there was a rivalry between Microsoft and Oracle for winning over the enterprise market.

The current version, Microsoft SQL Server 2005, was released in November of 2005. The launch took place alongside Visual Studio 2005. The SQL Server 2005 Express Edition is currently available for free download.[1]

In the six years since release of Microsoft"'s previous SQL Server product (SQL Server 2000), advancements have been made in performance, the client IDE tools, and several complementary systems that are packaged with SQL Server 2005. These include: an ETL tool (SQL Server Integration Services or SSIS), a Reporting Server, an OLAP and data mining server (Analysis Services), and several messaging technologies, specifically Service Broker and Notification Services.

Versions for Microsoft Windows

Releases

1993 - SQL Server 4.21 for Windows NT

1995 - SQL Server 6.0, codenamed SQL95

1996 - SQL Server 6.5, codenamed Hydra

1999 - SQL Server 7.0, codenamed Sphinx

1999 - SQL Server 7.0 OLAP, codenamed Plato

2000 - SQL Server 2000 32-bit, codenamed Shiloh (version 8.0)

2003 - SQL Server 2000 64-bit, codenamed Liberty

2005 - SQL Server 2005, codenamed Yukon (version 9.0)

Next release - codenamed Katmai

Versions for SQL Server 2005

(compare features)

Enterprise Edition (x86, x64, and IA64)

Developer Edition (x86, x64, and IA64)

Standard Edition (x86, x64, and IA64)

Workgroup Edition (x86 only)

Express Edition (x86 only)

Mobile Edition

Versions for SQL Server 2000

Enterprise Edition

Desktop Edition (MSDE 2000)

Server CE

Versions for SQL Server 7.0

SQL Server 7.0 Enterprise Edition

SQL Server 7.0 Standard Edition

Description

MS SQL Server uses a variant of SQL called T-SQL, or Transact-SQL, an implementation of SQL-92 (the ISO standard for SQL, certified in 1992) with some extensions. T-SQL mainly adds additional syntax for use in stored procedures, and affects the syntax of transaction support. (Note that SQL standards require Atomic, Consistent, Isolated, Durable or "ACID" transactions.) MS SQL Server and Sybase/ASE both communicate over networks using an application-level protocol called Tabular Data Stream (TDS). The TDS protocol has also been implemented by the FreeTDS project [2] in order to allow more kinds of client applications to communicate with MS SQL Server and Sybase databases. MS SQL Server also supports Open Database Connectivity (ODBC). The latest release SQL Server 2005 [3] also supports the ability to deliver client connectivity via the Web Services SOAP[4] protocol. This allows non-Windows Clients to communicate cross platform with SQL Server. Microsoft has also released a certified JDBC[5]> driver to let JAVA [6] Applications like BEA[7] and IBM WebSphere[8] communicate with Microsoft SQL Server 2000 and 2005.

SQL Server Express Edition

Formerly known as MSDE, Microsoft SQL Server Express is Microsoft"'s freely-downloadable and distributable version of its database engine that offers a database solution specifically targeted for embedded and smaller-scale applications. Though, unlike its predecessor MSDE, there is no concurrent workload governor, which limited "performance if the database engine receives more work than is typical of a small number of users." [9], it has some technical restrictions that make it unsuited for large-scale or production deployments, including:

Maximum database size of 4 GB per database (compared to 2 GB in the former MSDE). The 4 GB limit is per database (log files excluded) and can be extended in some scenarios through the use of multiple interconnected databases.

Hardware utilization limits:

Single CPU

1 GB of RAM.

Absence of SQL Server Agent Service

Although its predecessor, MSDE, was virtually devoid of basic GUI management tools, the 2005 Express version now includes several GUI tools for database management. Among these tools are:

SQL Server Configuration Manager

SQL Server Management Studio Express

SQL Server Surface Area Configuration tool

SQL Server Business Intelligence Development Studio.

A relatively late addition to the SQL Server Express product line is a reduced functionality version of SQL Server Reporting Services, but features such as Analysis Services, Integration Services, and Notification Services are only available in the "Standard" version and better.

The slammer worm

A computer worm, named the SQL slammer worm, which exploited a previously patched security vulnerability in MS SQL 2000 was discovered in January 2003, and caused a large Internet slowdown on January 24.

Competition

Some information in this article or section has not been verified and may not be reliable.

Please check for any inaccuracies, and modify and cite sources as needed.

Microsoft"'s primary competition includes Oracle and IBM DB2. Microsoft is currently ranked third in revenue marketshare among these major database vendors considering all platforms, though it sells more than its competitors considering only the Windows market.[10]

A major competitive differentiator is that SQL Server runs solely on Microsoft Windows-based operating systems. As a result, the relative strength and viability of SQL Server is directly affected by the relative strengths and weaknesses of the Microsoft platform, unlike Oracle and DB2 which both run on numerous platforms, including Windows and Linux. IBM tends to fare decently in the mid-range market and dominates the high-end market, particularly with its z/OS version of the DB2 database, which is preeminent for enterprise OLTP[citation needed]. However, many large organizations run two or even all three of these vendors"' products in some combination. Other commercial competitors include Teradata, Sybase, IBM Informix, and Adabas.

Recently, open source cross-platform databases such as MySQL, PostgreSQL and Firebird have further increased the competition among database vendors. These databases offer no-cost and low-cost licensing and, for many clients, offer enough functionality for their database needs, often also including commercial offerings directed at business users such as MySQL Enterprise. Microsoft has offered a free version of its database (SQL Server Express Edition in version 2005, MSDE in prior versions). Both Oracle and IBM now also offer free versions of their databases — 10g Express Edition and DB2 Express-C, respectively.

Future development

According to Microsoft[11], future versions of SQL Server aim to make data management self-tuning, self organizing, and self maintaining with the introduction of SQL Server Always On technologies, to provide near-zero downtime. Microsoft also aims to intrinsically support many digital data formats, including pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams. Intrinsic awareness of multimedia data will allow specialized functions to be performed on them. Better support for unstructured and semi-structured data is planned as well.

Companion products

SQL Server Integration Services

SQL Server Analysis Services

SQL Server Reporting Services

SQL Server Notification Services

SQL Server Management Studio

See also

Windows Server System

References

^ Microsoft SQL Server Express Edition download site

^ FreeTDS Project

^ [1]

^ [2]

^ [3]

^ [4]

^ [5]

^ [6]

^ MSDE limits on MSDN

^ "Gartner Says Database Market Continued Its Recovery in 2004", itjungle.com retrieved 26 July, 2006

^ Microsoft Senior Vice President comment

Further reading

Kalen Delaney (2001). "Inside SQL Server 2000". Microsoft Press. ISBN 0-7356-0998-5.

Scalability Experts (2005) "SQL Server 2005 : Changing the Paradigm". Sams ISBN 0-6723-2778-3

Thomas Rizzo, Adam Machanic, et al (2005) "Pro SQL Server 2005". Apress ISBN 1-59059-477-0

Fernando Guerrero, Carlos Eduardo Rojas (2001). "Sql Server Programming By Example", QUE ISBN 0-7897-2449-9

Tony Bain, et al (2004) "Beginning SQL Server 2000 DBA From Novice to Professional", aPress ISBN 1-59059-293-X

External links

SQL Server Official Site

High Performance SQL Server

MS SQL Security Documentation

Longer version of the history from a dev team member

Topics in database management systems (DBMS) ( view • talk • edit )

Concepts

Database | Database model | Relational database | Relational model | Relational algebra | Primary key - Foreign key - Surrogate key - Superkey

Database normalization | Referential integrity | Relational DBMS | Distributed DBMS | ACID

Objects

Trigger | View | Table | Cursor | Log | Transaction | Index | Stored procedure | Partition

 Topics in SQL

Select | Insert | Update | Merge | Delete | Join | Union | Create | Drop

Comparison of syntax

Implementations of database management systems

Types of implementations

Flat file | Deductive | Dimensional | Hierarchical | Object oriented | Temporal

Products

db4o | dBASE | Oracle | Caché | OpenLink Virtuoso | Sybase | Ingres | MySQL | SQLite | Microsoft SQL Server | PostgreSQL | InterBase | Firebird | DB2 | Informix | Helix database | Teradata | Comparison - relational | Comparison - object-relational

 Components

Query language | Query optimizer | Query plan | ODBC | JDBC

Lists

List of object-oriented database management systems

List of relational database management systems

List of truly relational database management systems

Retrieved from "http://en.wikipedia.org/wiki/Microsoft_SQL_Server"

End of Wikipedia content, http://en.wikipedia.org/wiki/Microsoft_SQL_Server

Other IT Web Sites from eIT.in

Web Resources for Microsoft SQL Server

  • MS SQL

About eIT.in

eIT.in is a comprehensive directory for everything IT & Software. It contains over 500 categories, and well over 10,000 web resources

eIT.in provides directory and web links resources for the IT, software, programming & software development domains. It is intended to be useful for application, applications programmers & developers, software technology programmer & developer, databases software development, administrators & DBAs, application developers, strategy architect, design specialists and architects, migration, integration, customization consultants and customisation analysts, administration, maintenance & support professionals, outsourcing consultant, bespoke solutions programming developers & coders, project management & functional analyst, and for system administrators, testing & quality control engineers. It will make an effort to provide resources on tutorial/tutorials, guide, guides, tips, faq, faqs on these topics.

eIT.in content is available under GPL: All directory content at mainframe.in is under the General Public License (GPL). Under this license, anyone is free to copy & use any amount of directory content @ eIT.in, make changes to it and use it in any way they wish, as long as they also allow the same rights to anyone else for this content. The concept of GPL has been adapted from the GNU GPL of the Free Software Movement. To those who wish to use content from eIT.in, our only request is that they acknowledge the source and provide a link back to eIT.in. This is only a request!

Countries & Cities Where eIT.in Provides Assistance

eIT Cities: Bangalore, Chennai, Mumbai, Bhubaneswar, Mysore, Kolkaka, Delhi, Pune, Trivandrum, Hyderabad

You are the $$$ Section of eIT.in

Reference

GeoDig – Get Local!

Have you checked out the GeoDig directories for over 30 countries? GeoDig provides useful local and regional web resources for over 200 cities around the world. See the list of cities and countries for which GeoDig provides locality-specific web resources.

North America

USA - Alabama (AL) > Birmingham; Alaska; Arkansas (AR) > Little Rock; Arizona (AZ) > Phoenix, Las Vegas, Tucson; California (CA) > Los Angeles, San Francisco, Sacramento, Fresno, Bakersfield; Colorado, CO > Denver; Connecticut, CT > Hartford; District of Columbia, DC > Washington DC; Delaware (DE) > Wilmington; Florida > Miami, Orlando, Tampa, Orlando, Sarasota, West Palm Beach, Jacksonville; Georgia > Atlanta; Hawaii > Honolulu; Idaho; Illinois > Chicago; Indiana > Indianapolis; Iowa; Kansas (KS); Kentucky (KY) > Louisville; Louisiana (LA) > New Orleans, Baton Rouge; Maine; Maryland (MD) > Baltimore; Massachusetts > Boston, Springfield; Michigan > Detroit, Grand Rapids; Minnesota > Minneapolis-St. Paul; Mississippi (MS); Missouri (MO) > Kansas City, St. Louis; Montana; Nebraska (NE) > Omaha; Nevada (NV) > Las Vegas; New Hampshire; New Jersey (NJ) > Jersey City, Newark; New Mexico (NM) > Albuquerque; New York > New York, Buffalo, Rochester, Albany, Syracuse; North Carolina (NC) > Raleigh-Durham, Charlotte, Greensboro; North Dakota; Ohio> Columbus, Cincinnati, Cleveland, Toledo, Youngstown, Dayton; Oklahoma (OK) > Oklahoma City, Tulsa; Oregon > Portland; Pennsylvania > Philadelphia, Allentown, Pittsburgh, Harrisburg, Scranton, ; Rhode Island (RI) > Providence; South Carolina (SC) > Greenville; South Dakota; Tennessee (TN) > Knoxville, Memphis, Nashville; Texas > Austin, Dallas, Houston, San Antonio, El Paso, Austin, McAllen; Utah (UT) > Salt Lake City; Vermont; Virginia (VA) > Norfolk, Richmond; Washington > Seattle; West Virginia; Wisconsin (WI) > Milwaukee; Wyoming

Canada - Vancouver, Montreal, Toronto, Calgary, Ottawa-Gatineau, Edmonton, Quebec City, Winnipeg, Hamilton, London

You are the $$$ Section of eIT.in

Europe - UK - London, Glasgow, Manchester, Birmingham, Liverpool, Sheffield, Leeds, Bristol, Edinburgh, Leicester; France - Paris, Marseille, Lyon, Toulouse, Nice, Nantes, Strasbourg, Montpellier, Bordeaux; Germany - Frankfurt (Frankfurt am Main), Munich (München), Berlin, Düsseldorf, Hamburg, Cologne (Köln), Essen, Dortmund, Stuttgart, Bremen, Duisburg, Hannover, Nürnberg (Nuremberg), Dresden, Leipzig; Italy - Milan (Milano), Rome (Roma), Napoli (Naples), Torino (Turin), Palermo, Bologna, Firenze (Florence), Genova (Genoa); Spain - Madrid, Barcelona, Valencia, Sevilla, Zaragoza, Malaga, Murcia, Las Palmas, Bilbao; Scandinavia - Finland - Helsinki (Helsingin), Espoo, Tampere (Tampereen), Vantaa, Turku, Oulu, Sweden - Stockholm, Goteborg (Göteborg), Malmo (Malmö), Uppsala, Vasteras (Västerås), Denmark - Copenhagen (Københavns), Aarhus (Århus), Odense, Aalborg (Ålborg), Norway - Oslo, Bergen, Stavanger, Trondheim; Benelux - Belgium - Brussels (Brussel), Antwerp (Antwerpen), Ghent (Gent, Gand), Charleroi, Liège (Liege), Netherlands - Amsterdam, Rotterdam, Utrecht, Eindhoven, Tilburg, ‘s-Gravenhage (sGravenhage), Groningen, Luxembourg - Luxembourg City; Portugal – Lisbon; Greece – Athens; Hungary – Budapest; Poland – Warsaw; Switzerland - Zürich (Zurich), Geneva (Geneve, Genève), Basel, Bern (Berne), Lausanne; Austria - Linz, Vienna (Wien), Graz, Linz, Salzburg, Innsbruck; Ireland – Dublin

Asia - India - Mumbai, New Delhi, Bangalore; China & Hong Kong - Hong Kong, Beijing, Shanghai, Tianjin, Wuhan, Shenyang, Guangzhou, Harbin, Xian; Japan - Tokyo, Osaka, Yokohama, Nagoya, Sapporo, Kyoto, Kobe, Fukuoka, Kawasaki, Hiroshima; South Korea - Seoul, Pusa, Taegu, Incheon, Taejeon, Taiwan - Taipei; Malaysia - Kuala Lumpur; Singapore; Russia - Moscow, St Petersburg

You are the $$$ Section of eIT.in

Middle East - Turkey - Istanbul, Israel - Tel Aviv

Oceania - Australia - Sydney, Melbourne, Brisbane, Perth, Adelaide

Africa - South Africa - Johannesburg, Cape Town, Durban

 

 
  In the beginning, there were algae,
but there was no oil Then, from algae came oil.
Now, the algae are still there, but oil is fast depleting
In future, there will be no oil, but there will still be algae  
So, doesn’t it make sense to explore if we can again get oil from algae?
This is what we try to do at Oilgae.com – explore the potential of getting oil from algae