Join Gerry O'Brien for an in-depth discussion in this video SQL Server components, part of Installing SQL Server 2012.
SQL Server contains many features that you can choose from during the installation. Understanding what each feature provides will help you make an educated choice on the features to install that meet your needs. Most times, I watched a lot of folks install SQL Server and they simply choose all features, click the Next button and move on. But let's make sure we understand what we're installing. So at the end of this lesson, you will have gained an understanding of the components available to install with your SQL sever. One of the first things we need to consider is the database engine and the features it provides to core database services.
Under the database engine, you'll see that we have the Database Engine Services. Our SQL Server replication services. Full text and semantic extractions for Search, Data Quality services as well as Analysis services and Reporting services. Note that these are check boxes and you'll find them on the installation screen. And we'll see an example of that when we do the installation. And these are optional components but some of them in order to make SQL function such as the Database Engine Services will be required. The Database Engine component provides the core service for storing, processing and securing the data on your SQL Server installation.
SQL Server Replication service is used for copying and distributing your data. As well as database objects where you might want to move them from one database to another. Or synchronizing between databases to provide consistency in your data. The Full Text Search functionality is actually a search engine, and it supports full text extraction for fast tech search within your data. As well as semantic extraction for key phrases that might exist within your data. The optional Analysis Services provides tools that are used to support what are known as online analytical processing.
Or OLAP in the data mining features that are available in SQL Server. Reporting Services is a Server based application that allows you to create, manage and deliver reports of the data that exists in your SQL database. These can be delivered to email, they support multiple file formats. And they also provide interactive web based formats. SQL Server also provides a list of shared features. When you install SQL Server on a computer, you have the ability to install multiple instances.
Each of these instances can utilize these shared features. Let's took a look at what each one these shared features are. To give you a better understanding whether you need to install them or not. Some of the core shared features evolve around Reporting services. There are two components that interact with SharePoint. These are reporting services for SharePoint installation. And there is the reporting services add in for SharePoint products. This allows SQL Server to intergrade with the SharePoint installation that you might have on the same server.
Data Quality services is a knowledge driven solution that provides both computer assisted. And interactive ways to manage the integrity and the quality of your data sources. Data Quality services enable you to discover, build and manage knowledge about your data. The Data tools are the development tools in environment as well as the business intelligence tools that you will use to create BI components of your SQL installation. The Client Tools provide the components for client and server communication.
Client and server communication essentially allows the SQL server to perform the role of a client in connecting to other data sources. As well as to perform the role of a server allowing clients to connect to it for serving up the data needs. Integration services includes things such as the Designer, the Run time, as well as Utilities. That enable the integration services to move, integrate and transform data between data stores. Consider integration services as a tool that will allows to bring in data from discrete data sources.
The Client Tools SDK is your software development kit. This contains resources for your developers as they decide to build applications to support the needs of the business. Your Documentation Components essentially consist of your books online. This is the documentation that you will use to understand all the different components, features and functionality of SQL Server. Your management tools for SQL Server include items such as SQL Server Management Studio, the Command Line Utility and Power Show.
There are also advanced tools that you can use for managing SQL Server Reporting Services. SQL Server Analysis Services and the other components of SQL Server. The distributed replay controller orchestrates the actions of the distributed replay clients. This includes the distributed replay client and multiple distributed replay clients work together to simulate workloads against an instance of SQL Server. Your client connectivity SDK is the SQL native ODBC SDK for app development against the database.
ODBC simply stands for the Open Database Connectivity. Of course this software development kit allows you to program against the database using that ODBC framework. The Feature Selection dialog is where you can choose to Select All for a complete installation of all the features. Or to go through and select the individual feature sets that you want to choose for your SQL instance. You'll also notice at the bottom of this dialog box, the shared feature directory. You can elect to choose the Default that SQL Server provides or you can choose your own default installation directory.
So in summary The many features of SQL Server are chosen during the feature selection portion of the installation wizard. Now this is assuming that you're using the graphical installation tool. The command line installation tool will be covered later. And you'll see the ability to install different features from the command line. Each feature contains a description of what it is if you select it in the installation wizard. So even though we've covered some of it here. If you select the individual feature during that setup wizard, you'll see a description in the right pane that will help you identify what that feature will do.
Evaluate each of the features to ensure that you install only what you need. This will optimize your installation for disk space.
- Choosing the right SQL Server edition for your organization
- Installing SQL Server
- Testing the installation and connectivity
- Configuring SQL Server services
- Connecting to the network
- Creating and connecting to databases
- Backing up and restoring a database