moncler abercrombie outlets pandora bracelet woolrich arctic parka abercrombie hoodies cuffie beats

www.databasecorner.comwww.databasecorner.comwww.databasecorner.com

Microsoft SQL Server Portal and Microsoft SQL Server Directory: Microsoft SQL Server Software, Microsoft SQL Server Tools, Microsoft SQL Server Articles, Microsoft SQL Server Tutorials, Microsoft SQL Server white papers, Microsoft SQL Server scripts, Microsoft SQL Server consultants, Microsoft SQL Server Developers, Microsoft SQL Server Forums and more.
Add Resources      Login      Logout

SQL Server Corner : SQL Server 2000 and 2005 tools, drivers, companies, consultants, services, articles, news, events, faqs, documentation, reference, help, support.

Microsoft SQL Server

Advertisements
 

SQL Server is a relational database management system produced by Microsoft. It supports a superset of Structured Query Language SQL, the most common database language. It is commonly used by businesses for small to medium sized databases, and in the past 5 years large enterprise databases, and competes with other relational database products for this market segment.
SQL Server is easy to manage and provides a separate OLAP engine. It is the ideal database for web applications written in Asp/Asp.Net as well. SQL Server currently runs only on the Windows operating systems, no plans for porting it to other platforms has been disclosed.

The code base for Microsoft SQL Server originated in Sybase SQL Server, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM, and Sybase. Microsoft, Sybase and Ashton-Tate teamed up to create and market the first version named SQL Server 4.2 for OS/2 (about 1989) which was essentially the same as Sybase SQL Server 4.0 on Unix, VMS, etc. Microsoft SQL Server for NT v4.2 was shipped around 1992 (available bundled with Microsoft OS/2 version 1.3) and was a simple port from OS/2 to NT. Microsoft SQL Server v6.5 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 coming out, 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.

Several revisions have been done independently since with improvements for SQL Server. SQL Server 7.0 was the first true GUI based database server, and 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's servers for winning the market over enterprise customers.

The current version, Microsoft SQL Server 2000, was released in August of 2000. Microsoft is beta testing its successor, SQL Server 2005. This is scheduled to launch during the week of 7th November 2005, alongside Visual Studio 2005 and BizTalk Server 2006. The June CTP (Community Technology Preview) release is currently available for free download.

Latest News about Microsoft SQL Server
  • UniDAC First Version Released!

    The Core Lab team is glad to announce the final release of Universal Data Access Components. UniDAC is an incredible solution for providing unified access to the popular database servers such as Oracle, Microsoft SQL Server, MySQL, InterBase, and Firebird. UniDAC is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, and C++Builder. It supplies a transparent server-independent interface for working with different database servers so that you can easily switch between different database servers in your cross-database UniDAC-based application.

  • Universal SQL Editor 1.0.7 Released

    SQL editor or query tool for Oracle, DB2, SQL Server, Sybase that featured intellisense-like code completion and parameter hinting.

  • AnySQL Maestro 8.2

    SQL Maestro Group is happy to announce first public release of AnySQL Maestro, a universal powerful solution for administering any database engine (SQL Server, Oracle, MySQL, MS Access, etc.) which is accessible via ODBC driver or OLE DB provider.

  • .com Solutions Inc. Updates its Perl CGI Generating Software CGIScripter 2.38 as a MacOS X Universal Binary - Now Available Free via TrialPay

    .com Solutions Inc. is making its Perl CGI generating software CGIScripter available Free with TrialPay in order to facilitate its use by students, non-profit organizations and small businesses who might not otherwise be able to afford to pay for software at retail prices.

  • SQL Manager for SQL Server version 3.1 released

    Support of server objects in Extract Database, Print Metadata, Duplicate Object and other tools; possibility to interrupt report generation, a great number of improvements and bug-fixes…

Latest entries about Microsoft SQL Server
  • UniDAC First Version Released!

    The Core Lab team is glad to announce the final release of Universal Data Access Components. UniDAC is an incredible solution for providing unified access to the popular database servers such as Oracle, Microsoft SQL Server, MySQL, InterBase, and Firebird. UniDAC is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, and C++Builder. It supplies a transparent server-independent interface for working with different database servers so that you can easily switch between different database servers in your cross-database UniDAC-based application.

  • FmPro Migrator

    FmPro Migrator quickly and accurately migrates FileMaker databases to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase,PostgreSQL and FrontBase. Microsoft Access and SQL Server to FileMaker 9, FileMaker Table Consolidation conversions are included.

  • Secure Auditor

    Secure Auditor is a unified risk management solution which enables user to perform enumeration, scanning, auditing, penetration testing and forensics on different operational systems from single console with 30 embedded utilities like Cisco Configuration Manager, Oracle Password Auditor, Windows Password Auditor, Oracle Event Log Viewer, Windows Event Log Viewer, Oracle Access Rights Auditor, MSSQL Access Rights Auditor, System and Software Inventory Manager, Trace Route etc. Secure Auditor Version performs audit on Oracle, MSSQL, Windows and Cisco Routers, presents vulnerability specification, prioritizes risk levels, and provides step by step methods of mitigation.

  • Free SQL workflow management software for Database Corner readers

    Free software from a leader in the SQL management and monitoring software space.

  • Microsoft SQL Server 2008 - Installation Made Easy

    SQL 2008 server is the latest in the line of Microsoft database servers and this article by Dr. Jayaram Krishnaswamy discusses the challenges one may face in installing the Developer version of this product which was released in November 2007. On a virgin machine the software probably installs without a hitch but with a history of installs, especially of the earlier versions it is anything but a joy ride. "It is almost always true for most of the software I have installed, not necessarily limited to Microsoft. However, most of Microsoft products need entry in the Window's registry and it is almost certain that one has to follow a certain protocol if one wishes to have a successful install. In fact the unsuccessful install flags out what went wrong while the initial steps do verify the requirements during installation. Despite this help and warnings one may face problems simply because it is not possible to foresee all possible combinations of hardware, software, user created error issues at launch time of the product. Again this article does not guarantee a successful install if one were to follow the steps delineated but gives you some guidance based on the author's experience."

  • Universal SQL Editor 1.0.7 Released

    SQL editor or query tool for Oracle, DB2, SQL Server, Sybase that featured intellisense-like code completion and parameter hinting.

  • AnySQL Maestro 8.2

    SQL Maestro Group is happy to announce first public release of AnySQL Maestro, a universal powerful solution for administering any database engine (SQL Server, Oracle, MySQL, MS Access, etc.) which is accessible via ODBC driver or OLE DB provider.

  • .com Solutions Inc. Updates its Perl CGI Generating Software CGIScripter 2.38 as a MacOS X Universal Binary - Now Available Free via TrialPay

    .com Solutions Inc. is making its Perl CGI generating software CGIScripter available Free with TrialPay in order to facilitate its use by students, non-profit organizations and small businesses who might not otherwise be able to afford to pay for software at retail prices.

  • Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps

    There are several options if one wishes to move a database from a SQL Server 2005 to SQL 2008 Server. First of all there is a 'Copy Database Wizard' in SQL 2008 Server which is meant for transferring a database from any version of SQL Server 2000 and above to 2008 version. In the other option the database will be copied using the SQL Server Management Program for which the source database need not be stopped. However this is slower than the previous method and would also require the SQL Server Agent since a package has to be run. An option which works without too much hassles is manually detaching and attaching the database/log files. In this step-by-step (really two steps) tutorial by Jayaram Krishnaswamy, this simple procedure is described. If you are just interested in taking a small database from 2005 to 2008 server the author strongly recommends this procedure.

  • Universal SQL Editor 1.0.7 released

    Universal SQL Editor is a powerful, yet easy-to-use graphical query tool for all database developers. It allows you connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, etc., and edit SQL queries and scripts with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.

All content Copyright© 2004-2006. databasecorner.com . All Rights Reserved.

Reproduction in whole or in part in any form or medium without express written permission is prohibited.

Use of this site, content or service of databasecorner.com constitutes acceptance of our Terms of Use and Privacy Policy

All product names and designated trademarks and brands are the property of their respective owners.

databasecorner.com is not affiliated with or endorsed by any company listed at this site.


Page rendered on:11/23/2014 11:44:00 PM