Home >Common Problem >What software is microsoft sql server?

What software is microsoft sql server?

青灯夜游
青灯夜游Original
2023-02-28 15:00:294038browse

Microsoft SQL Server is a relational database management system launched by Microsoft. It is a comprehensive database platform that uses integrated business intelligence (BI) tools to provide enterprise-level data management and is easy to use and scalable. It has the advantages of high integration with related software. The SQL Server database engine provides more secure and reliable storage functions for relational data and structured data, allowing users to build and manage highly available and high-performance data applications for business.

What software is microsoft sql server?

The operating environment of this tutorial: windows7 system, microsoft sql server 2022, Dell G3 computer.

Microsoft SQL Server is a relational database management system launched by Microsoft. It has the advantages of ease of use, good scalability and a high degree of integration with related software.

Microsoft SQL Server is a comprehensive database platform that provides enterprise-class data management using integrated business intelligence (BI) tools. The Microsoft SQL Server database engine provides more secure and reliable storage capabilities for relational and structured data, allowing you to build and manage highly available and high-performance data applications for your business.

What software is microsoft sql server?

SQL Server is a relational database management system. It was originally developed by Microsoft, Sybase and Ashton-Tate, and the first OS/2 version was launched in 1988. After the launch of Windows NT, Microsoft and Sybase parted ways in the development of SQL Server. Microsoft transplanted SQL Server to Windows NT systems and focused on developing and promoting the Windows NT version of SQL Server. Sybase is more focused on the application of SQL Server on the UNIX operating system.

Microsoft SQL Server is usually a software used by software developers. It can store large amounts of text data to form a database. For example, data from websites, APPs and other applications can be stored in the SQL Server database of the network server. The functions of this software are similar to the MySQL database.

Features of SQL Server database:

1. True client/server architecture.

2. Graphical user interface makes system management and database management more intuitive and simple.

3. Rich programming interface tools provide users with greater choices in programming.

4. SQL Server is fully integrated with Windows NT, taking advantage of many functions of NT, such as sending and receiving messages, managing logins, security, etc. SQL Server also integrates well with Microsoft BackOffice products.

5. It has good scalability and can be used across multiple platforms from small computers running Windows 95/98 to large multi-processors running Windows 2000.

6. Support for Web technology allows users to easily publish data in the database to Web pages.

7. SQL Server provides data warehouse functionality, which is only available in Oracle and other more expensive DBMS.

SQL Server Features and Functions

##Temporary TableThere are many temporary tables, including all lookup style reference tables and major entities such as StockItems, Customers and Suppliers. The history of these entities can be easily tracked using temporary tables. AJAX Calls to JSONApplications often use AJAX calls to query the following tables: Persons, Customers, Suppliers, and StockItems. The call returns data in JSON format. For example, see stored procedure JSON Property/Value BagMany tables have columns that hold JSON data, used to extend the relational data in the table. For example, Row Level Security (RLS)Row Level Security (RLS) is used to restrict access to the Customers table based on role membership. Each sales area has a role and a user. To understand RLS access restrictions in action, use the corresponding script in sample-script.zip. Run analytics in real time (Full version of the database) Core transaction tables PolyBaseTo see this PolyBase in action, using external tables and public datasets hosted in Azure Blob storage, use sample-script.zip the corresponding script in . In-memory OLTP (full version of the database) table types are all memory-optimized, so table-valued parameters (TVPs) all benefit from memory optimization.
SQL Server Feature or Function Using in WideWorldImporters
Website.SearchForCustomers.
Application.SystemParameters has a column for application settings, and Application.People has a column for recording user preferences. These tables use nvarchar(max) columns to record JSON data and ensure that column values ​​are valid JSON through CHECK constraints using the built-in function ISJSON.
Sales.InvoiceLines and Sales.OrderLines both Features non-clustered columnstore indexes to support efficient execution of analytical queries in transactional databases with minimal impact on operational workloads. Running transactions and analytics in the same database is also called hybrid transaction/analytic processing (HTAP).

The two monitoring tables
Warehouse.VehicleTemperatures and Warehouse.ColdRoomTemperatures are memory-optimized tables. Memory optimization allows the ColdRoomTemperatures table to be populated at a higher speed than traditional disk-based tables. The VehicleTemperatures table holds JSON payloads and is suitable for scaling to IoT scenarios. The VehicleTemperatures table is further suitable for scenarios involving EventHubs, Streaming Analytics, and Power BI.
Stored Procedure
Website.RecordColdRoomTemperatures Compile natively to further improve the performance of recording cold room temperatures.
To see an example of in-memory OLTP in action, see the Vehicle Location workload driver in workload-drivers.zip.
Clustered Column Storage Index (Full version of database) table Warehouse.StockItemTransactions Use clustered column storage index. In anticipation of the increase in the number of rows in this table, a clustered columnstore index will significantly reduce the table's on-disk size and improve query performance. Modifications to this table are insert only (no updates/delete to this table in online workload), and the clustered columnstore index works well for insert workloads.
Dynamic Data Masking In the database schema, data masking has been applied to the banks reserved for suppliers in the Purchasing.Suppliers table details. Non-administrator employees will not have access to this information.
Always Encrypted A demo of Always Encrypted is included in the downloadable samples.zip. This demonstration creates an encryption key, a table that uses encryption for sensitive data, and a small sample application that inserts data into the table.
Stretch Database Warehouse.ColdRoomTemperatures The table has been implemented as a temporary table and is memory optimized in the full version of the sample database. Archive tables are disk-based and can be stretched to Azure.
Full-text index Full-text index improves searching for People, Customers, and StockItems. The index is applied to the query only if a full-text index is installed on the SQL Server instance. Non-persistent calculated columns are used to create full-text indexed data in the StockItems table.

CONCAT Used to concatenate fields to create a full-text indexed SearchData.
To enable full-text indexing in the example, execute the following statement in the database:

EXECUTE [Application].[Configuration_ConfigureFullTextIndexing]

If it does not already exist Full-text catalog, which creates a default full-text catalog and then replaces search views with full-text versions of those views.

Please note that using full-text indexing in SQL Server requires selecting the "Full-text" option during installation. Azure SQL Database requires no specific configuration to enable full-text indexing.
Indexed persistent computed column Indexed persistent computed column used in SupplierTransactions and CustomerTransactions.
Check constraints The relatively complex check constraints are located in Sales.SpecialDeals. This ensures that one and only one of DiscountAmount, DiscountPercentage and UnitPrice is configured.
Unique Constraints Set up the many-to-many construct (and unique constraint) for Warehouse.StockItemStockGroups.
Table Partitioning (full version of the database) Tables Sales.CustomerTransactions and Purchasing.SupplierTransactions both use partitioning functions PF_TransactionDate and partitioning schema PS_TransactionDate are partitioned by year. Partitioning is used to improve the manageability of large tables.
List handling An example table type Website.OrderIDList is provided. It is used by the sample procedure Website.InvoiceCustomerOrders. This procedure uses Common Table Expressions (CTE), TRY/CATCH, JSON_MODIFY, XACT_ABORT, NOCOUNT, THROW, and Engine round trip.
GZip Compression In the Warehouse.VehicleTemperature view, its table contains the complete sensor data. However, when this data is retained for longer than a few months, it is compressed to save space. The COMPRESS function uses GZip compression.

View Website.VehicleTemperatures Use the DECOMPRESS function when retrieving previously compressed data.
Query Storage Query storage is enabled on the database. After running some queries, follow these steps:

1. Open the database in Management Studio.
2. Open the "Query Storage" node under the database.
3. Open the Top Resource Usage Queries report. View query execution and view the plan for the query you just ran.
STRING_SPLIT Sales.Invoices The DeliveryInstructions column in the table has comma-separated values ​​that can be used to demonstrate STRING_SPLIT.
Audit SQL Server auditing can be enabled for this sample database by running the following statement in the database:

EXECUTE [Application] .[Configuration_ApplyAuditing]

In Azure SQL Database, enable auditing through the Azure portal.

Security operations involving logins, roles, and permissions are logged on all systems with auditing enabled (including Standard Edition systems). Direct auditing to the application log, as this is available on all systems and requires no additional permissions. Warning: For increased security, this should be redirected to the security log or to a file in a secure folder. A link is provided describing the additional configuration required.

For Evaluation/Developer/Enterprise Edition systems, access to all financial transaction data is audited.

Related tutorial recommendations: "Database Video Tutorial", "PHP Tutorial"

The above is the detailed content of What software is microsoft sql server?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn