MS SQL Server is a database administration system from a well-known Microsoft corporation. The product has high competitiveness and is used by both large industrial enterprises and private individuals. Currently, databases are widely used, respectively, the demand for this program is constantly growing. The development of this product began in 1985, and since then new versions of the program have been released every year, developers introduce new useful functions and remove old unnecessary ones.
Development History, 90s
1989 - the first version of the software was developed, a joint development of Microsoft and Ashton-Tate. The project did not gain the expected popularity. First, product users would have to switch to a different operating system. Secondly, by then, competitors were able to create an SMS with wider functionality.
1990 - release of MS SQL Server 1.1. In terms of functionality, the new version did not differ much from the previous one (working with data, support for the SQL language), but many errors and shortcomings were fixed.
1993 - almost simultaneously with the release of the new operating system, SQL Server for Windows NT appears, significantly surpassing its competitors in performance.
1995 - Microsoft SQL Server 6.0, the first product released separately from Sybase (the company with which Microsoft has been developing software since 1987), was released. The announcement was very successful.
1998 - A new version of SQL Server 7.0 is introduced in Las Vegas. Many bugs were fixed, performance was improved. This version of the program was designed for large corporations working with a large amount of data.
Development History, 2000
1999 - the version of MS SQL Server 2000 was developed, developed for the operating system of the same name. The version had much more functionality than the previous one. Among them, a new method of accessing data, recovery algorithms, a new engine (opening up new possibilities for development).
2003 - the creation of MS SQL Server 2005. This version greatly simplified the creation of databases, accelerated work with a large amount of information and came out with the corrected errors that were in the previous version.
2008 - the appearance of a new version of the program. In fact, it is a more functional version of MS SQL Server 2005. There are no fundamental changes in this version.
Present
In 2010, the mobile version of Compact 4.0 was announced. The version does not require installation and is compatible with such platforms as API, NET and Framework, Visual Studio 2010. In 2014, a new version became available to users. Much attention is paid to increasing the possible volume of databases (up to hundreds of terabytes), business intelligence. There are also developments on the representation of the database in space. The next version of the product will be called SQL Server 2016, and is currently under active development.
Installation
Before starting the installation, we recommend that you familiarize yourself with the system requirements. The minimum ones are:
- Processor - Intel (or compatible) Pentium III 1000 MHz or higher.
- RAM - 512 MB or more.
- Hard disk capacity is 20 GB or more.
Recommended system requirements:
- Processor - Intel Core i7 3000 MHz or higher.
- RAM from 4 GB or more;
- Hard disk space must be between 100 GB or more.
If the computer on which the program is installed meets the above requirements, then you can proceed with the installation. Installing MS SQL Server is not too complicated and is no different from installing regular programs for Windows. There are only some distinctive features that will be described in this article.
- First you need to run the installation file with administrator rights (for this you need to right-click on the file and select "run as administrator").
- The Installation Center window opens. In it, select the "Planning" section, where the computer configuration will be checked.
- If everything went well, in the same window we select the "Installation" item, in the proposed list we select the first item where we are offered to install the program or add new components to it.
- Enter the required key (usually it is written on the box with the software).
- Accept the conditions described in the license and check the appropriate box.
- Next, click the "Install" button.
- Select the components to install.
- Select "Default Instance."
For optimal operation of the software, it is worth setting up before installation. The next chapter will cover how to do this.
Customization
Setup of MS SQL Server is performed before installation. Therefore, when setting up, you should be especially careful, because some configuration parameters will not be possible to change after installation.
- In the "Server Configuration" window, we are prompted to select the type of service start (automatically or manually). On all services except Full Text Filter Daemon Launcher, select "Auto". Click Next.
- In the section titled "Server Configuration" there is no need to change anything, so click "Next" again.
- In the "Configure Database Engine" window, select "Mixed mode" and set the administrator username and password. In the same window, go to the "Data directories" tab. We set the path where the files with the databases will be stored. Click next.
- Select the default setting (first item).
- In the error report settings window, select whether the program will automatically send an error report to Microsoft to improve this software.
This completes the installation and configuration, the program is ready to work.
Configure Remote Access
Consider a way to configure the program for remote access. This function will be useful if the organization has installed the program on more than one computer. After installing the MS SQL Server software, you must do the following:
- From the Start menu, select "All Programs"> MS SQL Server> Configuration Settings.
- Select Protocols for SQLEXPRESS, then TCP / IP.
- Switch TCP / IP to Enable.
- Select "Properties", then the IP Addresses tab.
- Next, select SQL Server Services.
- Restart SQL Server Services by selecting restart.
Next, you must enable the operating system firewall to receive incoming messages. To do this, do the following:
- We can find access to the firewall functions in the Start menu> Administrative Tools.
- In the firewall window that opens, select Inbound Rules.
- Next, select Port.
- Then you will need to specify TCP and its corresponding number, in our case it is 1433.
- The next step is to select Allow the connection.
- In the next step, Profile, check the boxes everywhere.
- Choose a suitable name.
If everything is done correctly, then the MS SQL Server database can be started remotely.
Useful Tips
The software in question is a fairly complex software. Here are some useful tips to make working with MS SQL Server easier:
- Restrictions when working with 1C apply to some versions, so before implementing this system, you should clarify the issue of software compatibility.
- If you started the database on a later version, then you cannot run it on an earlier version.
- If you need to send several tasks to the server within the same transaction , you must correctly indicate the type of transaction. For this, it is most convenient to set the automatic transaction detection mode: SET IMPLICIT_TRANSACTIONS OFF.
- If the program generates an error with several databases, this means that the database files have incompatible versions. In this case, the older database should be converted to a later version.
- To determine the path of the database , right-click on it and select "Properties".
Instead of a conclusion
Currently, relational databases are used in almost all organizations where large and not-so-large repositories are required. The wide distribution of this software gives developers a big impetus for development, as a result of which they each year present to the world more and more improved versions of their software. The joint use of MS SQL Server and 1C greatly simplifies the work cycle of many enterprises, saving them from unnecessary paperwork. The software itself is not too difficult to use and allows users to quickly learn all the basic steps necessary to work with this program.