Article on the subject of "ms sql server"
-
AND conditions in SQL Server
in sql server, the and condition (or and operator) is used to test two or more conditions.
-
The ORDER BY clause in SQL Server
the order by clause is used to filter records in the result set.
-
WHERE clause in SQL Server
in sql server) t-sql), the where clause is used to filter results from select, insert, update, or delete statements.
-
Comparison operators in SQL Server
this article will show the comparison operators that are used to check for equilibrium along with more advanced operators in sql server.
-
The FROM clause in SQL Server
the sql server from clause (t-sql) is used to list the necessary tables in the sql server query.
-
Analysis services in MS SQL Server
this service is used to analyze a large amount of data and for businesses to make decisions.
-
Integrated services in MS SQL Server
integrated services are used to implement etl (extraction, transform and load data) and administrator jobs.
-
Execution Plans - Execution plan in MS SQL Server
the execution plan is created using the query optimizer with the help of statistics, the algebrizer / process tree.
-
Reporting service in MS SQL Server
the report is a presentationable component.
-
High Availability - Availability of MS SQL Server
basically, there are 5 options to set up database availability in ms sql server.
-
How to start and stop services in MS SQL Server
ms sql server brings two main services for creating and maintaining databases (csdl). there are also additional services for other purposes.
-
Database monitoring in MS SQL Server
monitoring refers to checking the database status (database), setting the owner name, file name, file size, backup schedule ...
-
How to create users in MS SQL Server
the user here is an account on ms sql server to access the database (database).
-
How to recover the database in MS SQL Server
simply put, this is the process of retrieving the backup file and returning it to the database.
-
How to create a copy of data in MS SQL Server
this is the guide to create backup for database in ms sql server.
-
How to delete the database in MS SQL Server
to delete the database in ms sql server, we use the drop command.
-
How to choose a database in MS SQL Server
you can select the database to manipulate in one of the ways below.
-
How to create a database in MS SQL Server
ways to create user databases on ms sql server.
-
Manage MS SQL Server with Management Studio
sql server management studio is a tool in sql server if you choose when installing.
-
Instructions for installing MS SQL Server
this is a step by step guide to installing ms sql server.
-
The difference between web server and app server
you have probably seen that the terms web server and app server are often used interchangeably as if they are related to the same thing and also facilitate the website to function properly. but in reality, they are not the same.
-
Network basics: Part 3 - DNS Server
a dns server is a server that contains a database of public ip addresses and hostnames associated with them. in most cases, the dns server is used to resolve or translate those common names into ip addresses as required.
-
How to set up your own Git server on Linux
while you can count on globally renowned git hosting services like github, in some cases it is better to host a personal git server for enhanced privacy, customizability, and security.
-
Use IIS to set up FTP Server on Windows
set up an ftp server (file transfer protocol server) to share and convert large files with unlimited traffic.
-
How to change DNS server on the most popular routers
changing the dns server settings on your router is not difficult, but every manufacturer uses their own custom interface, which means the process can be very different depending on which router you are owned.
-
What is VPS? VPS used to do? What is VPS different from Server?
what is vps? vps used to do? what is vps different from server ?. when you intend to learn about network data or open the website, you will definitely be introduced to many different server and server services. but server hosting has a lot of tricks
-
7 great ideas using Raspberry Pi as a server
raspberry pi is a great solution for many computer projects, from learning programming to remote control a car to building a basic stop-motion animation studio. but do you know that raspberry pi can also be used as a server? here are some ideas for using raspberry pi as a server.
-
New points in SQL Server 2017
the sql server 2017 version is primarily connected to linux, bringing the power of sql to linux. in short, you can install sql server 2017 on linux, using sql server 2017 on linux-based docker containers. sql server 2017 also allows you to choose development languages, develop it on-premise or
-
Instructions for setting up and managing FTP Server on Windows 10
if you want to create a private cloud for sharing and converting large files without restrictions, you can create an ftp server (file transfer protocol server) on your windows 10 computer.
-
Create VPN Server on Windows 8
no need to install any additional applications, you can easily 'turn' your computer into a vpn server if you're using windows 8. in this way, you can share data from the computer. as a simple lan system in the form of remote access. & a
-
What is the future of server virtualization?
server virtualization can help combat poor server performance, make better use of computing capabilities, limit energy consumption and improve data center flexibility.
-
Learn about the architecture of MS SQL Server
in the previous articles, you already know briefly about sql server, how to install sql server on the computer. in this section we will learn about the architecture of sql server.
-
Instructions for installing MS SQL Server
this is a step by step guide to installing ms sql server.
-
How to install DNS Server on Windows Server 2019
from microsoft, the domain name system (dns) is one of the industry standard protocol sets that includes tcp / ip, along with dns client and dns server that provide name resolution services that map names to the ip addresses of computers. .
-
Install Windows Server 2003 and create a backup server
network management documentation server 2003 as details of how to install, create a companion server in case the main server is malfunctioning, create a domain, join the client to the domain, the conection {remote desktop from the client data to server}, set adsl router parameters to server, turn
-
SQL Server 2022 Installation Guide
microsoft sql server 2022 is the latest version of sql server. a notable new feature is data virtualization, which allows users to query different data types across different data sources from sql server.
-
Instructions to change DNS Server on Windows, Mac, iOS and Android
by default, your computer will automatically obtain dns information from your isp (isp). sometimes, dns servers are unstable and you are blocked from accessing certain websites. or the default dns server is blocked by some websites for a number of reasons. in this case you should change the dns
-
How to configure DNS Server on Ubuntu Server 11.04
dns server is a server with domain name resolution function. in this article, we will detail the steps to install and configure dns server on linux with ubuntu server version 11.04.
-
Instructions for setting up individual FTP Server with FileZilla
unlike http - designed to forward hyper - text data over tcp connections, standard ftp ensures that the server responds to requests as soon as it receives a signal from the host. not only provides fast and accurate file transfer, but also security, gives users more options in the process of
-
HAVING clause in SQL Server
the having clause is used in conjunction with the group by clause in sql server (transact-sql) to limit the group of returned rows, only when the condition is met is true.