SAVE 5% WITH MINIMUM ORDER OF $200 WITH COUPON CODE: TSS5OFF
What is SQL Server?
What is SQL Server?
- SQL Server is a software, implemented from the specification of a Relational Database Management System or RDBMS.
- An object-relational database management system (ORDBMS).
- Is platform dependent.
- Both GUI and command based.
- Supports SQL language, an IBM, non-procedural, shared database, that uses case insensitive language.
Uses of SQL Server
- Create databases
- Maintain databases
- To analyze data through SQL Server Analysis Services (SSAS)
- To generate reports through SQL Server Reporting Services (SSRS)
- To carry out ETL operations through SQL Server Integration Services (SSIS)
SQL Server Components
SQL Server operates in the client-server architecture; therefore it supports two types of components − (a) Workstation and (b) Server.
- Workstation components are installed in every device/SQL Server machine. These are interfaces that interact with Server components. Example: SSMS, SSCM, Profiler, BIDS, SQLEM, etc.
- Server components are installed on a centralized server. Example: SQL Server, SQL Server Agent, SSIS, SSAS, SSRS, SQL browser, SQL Server full text search etc.
Instance of SQL Server
- An instance is an installation of SQL Server
- An instance is an exact copy of the same software
- If we install 'n' times, then 'n' instances will be created
- There are two types of instances in SQL Server a) Default b) Named
- Only one default instance will be supported in one Server
- Multiple named instances will be supported in one Server
- The Default instance will take the server name as the Instance name
- The default instance service name is MSSQLSERVER
- 16 instances are supported in 2000 version
- 50 instances are supported in 2005 and later versions
Advantages of Instances
- To install different versions on one machine
- Reduce cost
- Maintain production, development, and test environments separately
- Reduce temporary database problems
- Separate security privileges
- Maintain standby serve.
SQL Server is available in several editions:
Enterprise − is the top-end edition with a full feature set.
Standard − has fewer features than Enterprise when there is no requirement of advanced features.
Workgroup − is fitting for remote offices of a larger company.
Web − is designed for web applications.
Developer − This is similar to Enterprise but licensed to only one user for development, testing, and demo. It can be easily upgraded to Enterprise without reinstallation.
Express − is the free entry-level database that can utilize only 1 CPU, and 1 GB memory, the maximum size of the database is 10 GB.
Compact − is the free embedded database for mobile application development. The maximum size of the database is 4 GB.
Datacenter − is the most significant change in the SQL Server 2008 R2 is the Datacenter Edition. The Datacenter edition has no memory limitation and offers support for more than 25 instances.
Business Intelligence Edition -is a newer introduction in SQL Server 2012. This version includes all of the features of the Standard edition and support for advanced BI features such as PowerView and PowerPivot; however, it lacks the support for advanced availability features like AlwaysOn Availability Groups and other online operations.
Enterprise Evaluation Edition- is an excellent way to get a fully functional instance of SQL Server for learning and developing solutions. This edition has a built-in expiry of 6 months from the time that you install it.