SQL Server
IDENTITY SQL - The table property in Microsoft SQL Server is IDENTITY_INSERT. Using this property, we can insert an explicit value into the autoincrement column with IDENTITY that was previously...
Microsoft SQL Server 2012 - a fully ready-to-use information platform in the cloud, which provides confidence in the reliability of business-critical systems when working with data and...
SQL server ports - The subsystems and components that Microsoft continues to complement SQL Server have significantly increased the number of network connections used by the platform....
SQL Server Connection String - method of determining the database connection string. Using this line the application (program) can access the database elements (tables, views, charts,...
Microsoft Exchange server is an email forwarding service. It supports client protocols such as POP3, SMTP, MAPI and IMAP. It integrates with Outlook.This program is used if you want to allow...
Microsoft Windows Server 2012 - After four years of development, on September 4, 2012, Microsoft announced the availability of a new version of Windows Server.Historically, the operating...
Windows server 2019 - About 10 years ago, Microsoft adjusted its operating system release ideology so that the latest Windows Server operating system would always be structurally similar to its...
Microsoft SQL Server 2017 - the new version of SQL Server is released in the same editions as the previous Microsoft SQL Server 2016.Enterprise - the most comprehensive release, includes all...
Microsoft SQL Server 2016 - is a relational database management system developed by Microsoft. As you know, support for SQL Server 2005 ended in April 2016 and currently there are the following...
SQL Server 2014 - Microsoft SQL Server is a database management system, or in short DBMS, which was developed by Microsoft and Sybase. It allows you to effectively manage databases of different...
Microsoft SQL Server Analysis Services (SSAS) provides interactive analytics processing (OLAP) and intelligent data analysis functions for business intelligence applications. Analysis Services...
SSIS: Microsoft SQL Server includes the SQL Server Integration Services component, and today we will learn what this component is for and take a look at its main features.As you probably know,...
SSRS - Report Builder: The first version of Report Builder was released by Microsoft in 2005. The product was advertised as a development and management tool with which end users and database...
SQL Server Event Service - Quite often, developers of client-server applications need to organize a mechanism that allows the event on the sql-server to notify one or another client. Even more often...
Database Design - Widely known methods of designing databases (DB) have appeared in the course of development of more and more complex Information Systems (IS) which should consider requirements...
In this material I will tell you about DDL, DML, DCL and TCL in SQL language. If you do not know what these incomprehensible letter sets mean and you work with SQL language, you should read this...