What is a Database Engine?
A database engine (or “storage engine”) is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise. Most database management systems include their own Application Programming Interface (API) that allows the user to interact with their underlying engine without going through the user interface of the DBMS. (Source: Wikipedia)
You can use the Database Engine to create relational databases for online transaction processing or online analytical processing data. This includes creating tables for storing data, and database objects such as indexes, views, and stored procedures for viewing, managing, and securing data. You can use SQL Server Management Studio to manage the database objects, and SQL Server Profiler for capturing server events. (Source: Microsoft)
Tutorial: Getting Started with the Database Engine
This tutorial shows you how to connect to the Database Engine using SQL Server Management Studio or Management Studio Express, on both the local computer and from another computer.
This tutorial is divided into two lessons:
- Lesson 1: Connecting to the Database Engine
- In this lesson, you will learn how to connect to the Database Engine and enable additional people to connect.
- Lesson 2: Connecting from Another Computer
- In this lesson, you will learn how to connect to the Database Engine from a second computer, including enabling protocols, configuring ports, and configuring firewall settings. (Source: Microsoft)
Connecting to the SQL Server Database Engine
Connecting to the SQL Server Database Engine includes five elements:
- Installing network protocols on the server and client computers.Network protocols are a feature of the operating system and are installed and configured using Microsoft Windows tools. For information about installing and configuring network protocols, see your Windows documentation, or contact your network administrator.
- Enabling and configuring the Database Engine to listen on one or more network protocols.Use the SQL Server Configuration Manager, to enable the protocols you wish to use. When enabled, the Database Engine receives database communication from client computers formatted by the SQL Server Native Client. The SQL Server Native Client is normally installed on the server as well, for use by the local SQL Server tools.
- Installing the SQL Server Native Client on each client computer.SQL Server Native Client (SQLNCLI10) is a data access technology that is new to Microsoft SQL Server, and it is a stand-alone data access Application Programming Interface (API) that is used for both OLE DB and ODBC. It combines the SQL OLE DB Provider and the SQL ODBC Driver into one native dynamic link library (DLL) while also providing new functionality that is separate and distinct from the Microsoft Data Access Components (MDAC). Use SQL Server Setup to install SQLCLI as part of the SQL Server Tools.
- Enabling and configuring each client computer to connect using the desired protocol.After installation, use SQL Server Configuration Manager to enable protocols, and designate the order in which protocols are used when attempting a connection.
- Opening ports in the firewall to permit database communication.
- Use a firewall system to isolate the network containing the instance of SQL Server from the rest of the Internet.
- Use a proxy server to connect to an instance of SQL Server. (Source: SQLServer BooksOnline)
Joshua is working to become a Data Scientist with focus on Analytics, Big Data, Machine Learning, and Statistics. His passion for Data and Information are second to none. He is a certified IBM Cognos Expert with more than 10 years experience in Business Intelligence & Data Warehousing, Analtyics, IT Management, Software Engineering and Supply Chain Performance Management with Fortune 500 companies. He has specializations in Analytics, Mobile Reporting, Performance Management, and Business Analysis.
- 2,087 feed subscribers
Tags2008 Analysis Analytics Article Big Data Book Business Intelligence Charts Cognos Dashboards Data Data Warehouse Design Dimensional Flow Elements Fusion Tables Google Humor IBM Install Learning Logical Market Microsoft Model Modeling Operational Predictive Programming Python Ralph Kimball Reporting Science Server SQL SSIS Statistics TED Tools Tutorial Unstructured Video Visualization Warehousing Windows