Features of Sql server in 2017
Microsoft SQL Server
- Microsoft SQL Server is a relational database management system established by Microsoft.
- SQL Server a platform that gives selections of development languages, data types, cloud, and operating systems by fetching the power of SQL Server to Linux, Linux-based Docker containers, and Windows.
![.Net Architecture](https://cdn.wikitechy.com/final-year-project/dotnet/sql-server-architecture.jpg)
Sql Server Architecture
SQL Server 2017 Features
The features are,
- SQL Server Machine Learning Services - R and Python
- Improved SELECT INTO statement
- Resumable online index rebuild operation
- New dynamic management views (DMVs)
SQL Server Machine Learning Services - R and Python
- SQL Server 2016 integrated with the R programming which may be run within the database server and can be embedded into T-SQL script.
- In SQL Server 2017, we will execute the Python script within the database server itself.
- Both, R and Python are most popular programming language which provides general support for data analytics along with language processing capability.
- R and Python programming languages are used by data scientists.
- Adding Python to the SQL Server 2017 can give a lot of power to SQL Server for advanced analytics, data transformations capabilities and statistical computing.
Improved SELECT INTO statement
- we weren't able to give the filegroup name on which we need to create the new table using ON keyword with SELECT INTO statement.
- The table gets created on the default filegroup of the user by default.
- But, in SQL Server 2017, we will give the name of the filegroup on which we need to create the new table using SELECT INTO statement.
Resumable online index rebuild operation
- An online Index rebuild operation can be started from the point of failure now which can be occurred due to the insufficient disk space.
New dynamic management views (DMVs)
sys.dm_db_log_stats
- This view exposes summary level attributes and information on transaction log files.
sys.dm_tran_version_store_space_usage
- This view tracks version store usage per database
sys.dm_db_log_info
- This view exposes VLF information to monitor, alert, and prevent potential transaction log issues.
sys.dm_db_stats_histogram
- This is a new dynamic management view for examining statistics
sys.dm_os_host_info
- This view provides operating system information for both Windows and Linux
Features of SQL-SERVER
- The OLAP Services feature available in SQL Server version 7.0 is now called SQL Server 2000 Analysis Services.
- The term OLAP Services has been replaced with the term Analysis Services.
- Analysis Services also includes a new data mining component.
- The Repository component available in SQL Server version 7.0 is now called Microsoft SQL Server 2000 Meta Data Services.
- References to the component now use the term Meta Data Services.
- The term repository is used only in reference to the repository engine within Meta Data Services
SQL-SERVER database consist of six type of objects,
They are,
- TABLE
- QUERY
- FORM
- REPORT
- MACRO
TABLE:
- A database is a collection of data about a specific topic.
Views of Table:
We can work with a table in two types,
- Design View
- Datasheet View
Design View
- To build or modify the structure of a table we work in the table design view. We can specify what kind of data will be hold.
Datasheet View
- To add, edit or analyses the data itself we work in tables datasheet view mode.
QUERY:
- A query is a question that has to be asked the data. Access gathers data that answers the question from one or more table.
- The data that make up the answer is either dynaset (if you edit it) or a snapshot(it cannot be edited).
- Each time we run query, we get latest information in the dynaset.
- Access either displays the dynaset or snapshot for us to view or perform an action on it ,such as deleting or updating.
FORMS:
- A form is used to view and edit information in the database record by record .
- A form displays only the information we want to see in the way we want to see it.
- Forms use the familiar controls such as textboxes and checkboxes.
- This makes viewing and entering data easy.
Views of Form:
We can work with forms in several primarily there are two views, They are,
- Design View
- Form View
Design View
- To build or modify the structure of a form, we work in forms design view.
- We can add control to the form that are bound to fields in a table or query, includes textboxes, option buttons, graphs and pictures.
Form View
- The form view which display the whole design of the form.
REPORT:
- A report is used to vies and print information from the database.
- The report can ground records into many levels and compute totals and average by checking values from many records at once.
- Also the report is attractive and distinctive because we have control over the size and appearance of it.
MACRO:
- A macro is a set of actions. Each action in macros does something.
- Such as opening a form or printing a report .We write macros to automate the common tasks the work easy and save the time.
MODULE:
- Modules are units of code written in access basic language.
- We can write and use module to automate and customize the database in very sophisticated ways.