The code base for MS 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 designed for NT, and did not include any direction from Sybase.
About the time Windows NT was released, Sybase and Microsoft parted ways and each 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 a rewrite from the legacy Sybase code. It was succeeded by SQL Server 2000, which was the first edition to be launched in a variant for the IA-64 architecture.
In the eight 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.
Our experiences with this technology
Mobile questionnaires
It is a complex mobile solution forfilling of questionnaires and synchronizing them with a remotedatabase. Actual questionnaires schemas and data are taken from a webservice with a specific API.
Using tools: MS Visual Studio 2008, Windows Mobile 6.1
Using technologies: C#, .Net CF 3.5
Using database: MS SQL CE 3.5
Corporative bank site
The project is a corporate site for one of the largest bank in Belarus.This is the full-scale banking site with front-end and back-endfunctionalities.
Using tools: MS Visual Studio 2008
Using technologies: C#, ASP.NET, Ajax
Using database: MS SQL 2005
Get a job or employee
It is a web application for advanced smart search of jobs andemployees. Notifications about newly registered companies andapplicants with a corresponded search criterion were a part offunctionality.
Using tools: MS Visual Studio 2008
Using technologies: C#, ASP.NET, Ajax
Using database: MS SQL 2005
WSS builder
It is a web application for flexible building of WSSsolution package structure based on different VS projects that storedunder SVN Repository server and integration with CruiseControl.Netservice.
Using tools: MS Visual Studio 2008, CruiseControl.NET, MSBuild
Using technologies: C#, ASP.NET, Ajax
Using database: MS SQL 2005
E-learn
A web system that allows users to register on the site as volunteers and help children to study
Using tools: MS Visual Studio 2008, Idea, Adobe Flash, Red5
Using technologies: C#, ASP.NET, Ajax, Flash, Action script, Java
Using database: MS SQL 2005
Professor
E-learning system that allows students and instructors to contact with each other and arrange online sessions.
Using tools: MS Visual Studio 2008, Virtual PC
Using technologies: WSS 3.0, C#, ASP.NET
Using database: MS SQL 2005
Contract monitor
This system is a collaborative contract monitoringtool for clients who wish to attain higher quality contracts andachieve sustainable savings. It combines quality control andquality assurance in a single software application accessible by boththe client and its service providers and automates inspectionscheduling, performance monitoring, and all other back office functions.
Using technologies: MS Visual Studio 2008
Using technologies: C#, ASP.NET, AjaxToolKit
Using database: MS SQL 2005
Lender portal
Developing of a Web portal for Great Britain Lender Company. Thisportal provides functionalities that cover a lender’s main businessflows.
Using tools: MS Visual Studio 2008
Using technologies: C#, ASP.NET, NHibernate, AjaxToolKit
Using database: MS SQL 2005
Online Banking
Online banking provides standard solutions for internet clients for suchoperations like managing accounts, getting settlements records from abank, checking payments status, and request for a money borrowing,requesting a formal document, managing correspondence between bankclerk and a client.
Using technologies: MS Visual Studio 2008
Using technologies: C#, ASP.NET, AjaxToolKit
Using database: MS SQL 2005
Procurements system
Developing of an intranet solution for Russiangovernment organization. This solution was based on MS SharePoint 2.0and represented procurements system based on tenders.
Using tools: MS Visual studio 2005, Virtual PC
Using technologies: C#, ASP.NET, WebParts, SharePoint 2.0
Using database: MS SQL 2000
Internet trade project
Internet trade project. Themain aim of this project lies in the creation andimplementation of an internet portal through which participants wouldhave an opportunity of executing online remote tenders, auctions andother kinds of contests and purchases with the strong rules of theoffline common tenders (comission, chairman and others should watch theprogress of the auction online) Besides, very complex logic was in thebase of the business flow (dumpings, ratings and so on).
Using tools: MS Visual Studio 2008
Using technologies: C#, ASP.NET, NHibernate, AjaxToolKit
Using database: MS SQL 2005
News portal
Developing of a famous Belarus newsportal, and full developing of an administration partof this site.
Using tools: MS Visual studio 2005
Using technologies: C#, ASP.NET 2.0
Using database: MS SQL 2000
Credits registrator system
Developing of Web solution for credits registration for one of the banks in Belarus. This solution was based on a third part component. Developing ofweb part and integrating it with existing component using XMLand SWIFT messages was the main responsibility.
Using tools: MS Visual studio 2005
Using technologies: C#, ASP.NET 2.0
Using database: MS SQL 2000
