Microsoft SQL Server (MS SQL) to system zarządzania bazą danych, wspierany i rozpowszechniany przez korporację Microsoft. Jest to główny produkt bazodanowy tej firmy, który charakteryzuje się tym, iż jako język zapytań używany jest przede wszystkim Transact-SQL, który stanowi rozwinięcie standardu ANSI/ISO.
MS SQL Server jest platformą bazodanową typu klient-serwer. W stosunku do Microsoft Jet, który stosowany jest w programie MS Access, odznacza się lepszą wydajnością, niezawodnością i skalowalnością. Przede wszystkim są tu zaimplementowane wszelkie mechanizmy wpływające na bezpieczeństwo operacji (m.in. procedury wyzwalane).
Darmowe edycje
Poza edycjami czysto komercyjnymi Microsoft udostępnia również edycje darmowe do dowolnego zastosowania (w tym komercyjnego). Edycje te mają różnorodne ograniczenia i tak np. do wersji 2000 (8.0) włącznie nie były m.in. udostępniane graficzne narzędzia do zarządzania bazami danych oraz były ograniczenia co do możliwej ilości połączeń do bazy.
Począwszy od wersji 2005 (9.0) można pobrać wersję z graficznymi narzędziami i nie ma już limitu połączeń. Narzędzia posiadają jednak ograniczone możliwości w stosunku do pełnej wersji, a nawet jedna z istotnych usług dostępnych wcześniej w darmowych wersjach, nie jest już dostępna. Nie można już przez to wykonywać zautomatyzowanych zadań np. archiwizacji baz danych o zadanej godzinie. Dodatkowo ograniczona została również wydajność samego serwera SQL (ograniczono wykorzystywaną pamięć RAM).
Prawnik
czwartek, 12 marca 2009
Overview
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.
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 coming out, however, 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. The Microsoft SQL Server product is not just a database; it also contains (as part of the product) an enterprise ETL tool (SQL Server Integration Services or SSIS), a Reporting Server, an OLAP implementation, and several messaging technologies, specifically Service Broker and Notification Services.
Stomatologia
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 coming out, however, 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. The Microsoft SQL Server product is not just a database; it also contains (as part of the product) an enterprise ETL tool (SQL Server Integration Services or SSIS), a Reporting Server, an OLAP implementation, and several messaging technologies, specifically Service Broker and Notification Services.
Stomatologia
Versions for SQL Server 2005
# 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
Przedsiebiorstwo
# Developer Edition (x86, x64, and IA64)
# Standard Edition (x86, x64, and IA64)
# Workgroup Edition (x86 only)
# Express Edition (x86 only)
# Mobile Edition
Przedsiebiorstwo
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
Zakładanie spółek
# 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
Zakładanie spółek
Optional ADD-ONS MS SQL 2000 Reporting Services
SQL Reporting Services
SQL Server 2000 Reporting Services (RS) is a powerful solution that enables the authoring, management, and delivery of both paper-oriented reports and interactive Web-based reports. With SQL Reporting Services, organizations can create reports to be published to the Report Server using Microsoft or third-party design tools that use Report Definition Language (RDL), an XML-based industry standard. Report definitions and resources are published and managed as Web services and users can view reports in Web-based formats or via email.
orzech włoski
SQL Server 2000 Reporting Services (RS) is a powerful solution that enables the authoring, management, and delivery of both paper-oriented reports and interactive Web-based reports. With SQL Reporting Services, organizations can create reports to be published to the Report Server using Microsoft or third-party design tools that use Report Definition Language (RDL), an XML-based industry standard. Report definitions and resources are published and managed as Web services and users can view reports in Web-based formats or via email.
orzech włoski
MS SQL 2000
WebHostForASP.NET support MS SQL 2000 Web Hosting. All Web hosting plans can request for MS SQL 2000 addon at anytime and we have made MS SQL hosting at a very affordable prices and yet maintain the performance and reliability. We do not overload Our Database Server to ensure performance and reliability for your website.
We have our own certified DBA to monitor SQL Server everyday and continuously enhance the performance on our SQL Server by regularly running the maintenance plan.
Below is all the MS SQL Server version that we supports
Our MS SQL 2000 Database Hosting comes with full remote access from anywhere. You Query Analyzer, MS SQL Management Studio or any third party database connectivity software. You have full rights for your database, you can run any script as you like including the ASP.NET Membership Software
Today, SQL Server 2000 can claim to be the fastest database in the world with groundbreaking TPC-C (Transaction Processing Performance Councils) benchmarks (www.tpc.org). These benchmarks have demonstrated that "SQL Server 2000 offers the industry's best price-to-price performance ratio on clustered hardware". A SAP endorsement for SQL says, "SAP is convinced that SQL Server 2000 on Windows 2000 would now meet the needs of every R/3 customer around the world."
With a maximum database size of roughly 1,000,000 terabytes, and up to 16 simultaneous instances of the Server that can be run on a single computer, SQL Server 2000 is ready to sweep the depths of enterprise-level database management.
rolnictwo
We have our own certified DBA to monitor SQL Server everyday and continuously enhance the performance on our SQL Server by regularly running the maintenance plan.
Below is all the MS SQL Server version that we supports
Our MS SQL 2000 Database Hosting comes with full remote access from anywhere. You Query Analyzer, MS SQL Management Studio or any third party database connectivity software. You have full rights for your database, you can run any script as you like including the ASP.NET Membership Software
Today, SQL Server 2000 can claim to be the fastest database in the world with groundbreaking TPC-C (Transaction Processing Performance Councils) benchmarks (www.tpc.org). These benchmarks have demonstrated that "SQL Server 2000 offers the industry's best price-to-price performance ratio on clustered hardware". A SAP endorsement for SQL says, "SAP is convinced that SQL Server 2000 on Windows 2000 would now meet the needs of every R/3 customer around the world."
With a maximum database size of roughly 1,000,000 terabytes, and up to 16 simultaneous instances of the Server that can be run on a single computer, SQL Server 2000 is ready to sweep the depths of enterprise-level database management.
rolnictwo
Subskrybuj:
Posty (Atom)