SQL Server
The data type is defined as the type of data that any column or variable can store in MS SQL Server. What is the data type? When you create any table or variable, in addition to specifying a...
In this article, there are 8 concepts to understand if you want to become an advanced programmer faster. The list is not complete, but it can be a good starting point for self-education in...
Previously, SQL as a tool was enough for research analysis: quick data search and preliminary report on data.Nowadays, data come in different forms and do not always refer to them as...
Many developers, even those who have long been familiar with SQL, do not understand window functions, considering them some kind of special magic for the chosen ones. And although the...
When switching from MS SQL to MySQL, apart from data migration, you must also transfer the application code, which is in the database.Earlier we discussed how to move MS SQL to a MySQL...
In this article, I will talk in detail, especially for beginner programmers, about how to create a database in Microsoft SQL Server, as well as what you should know before creating a...
Before starting to create an SQL table, it is necessary to define the database model. Design an ER diagram in which to define the entities, attributes, and relationships. Basic...
If you mainly use open-source programs in your company, and there are several MS SQL server databases, you can consider moving to a MySQL database.Below are a few reasons why you might want...
Is there a way to save dynamic SQL results in a variable? This is a very popular question, let's see the answer to that question in this blog.For example, here is dynamic SQL which we execute...
Installing a new SQL Server instance is a common task for DBAs, and most of us use a simple and straightforward GUI approach.However, there are some configuration options, both during and...
SQL Server has an interesting feature called Linked Servers. It is about linking other databases to SQL Server and using their data as local. There are many powerful open source systems written...
There are official ratings and other analytical data that show DBMS popularity.Some ratings are based on the frequency of reference in search engine queries, ie, if people are more often looking...
Sometimes you have to face the situation when in Microsoft SQL Server with the configured replication, the database distribution starts to grow. There is nothing wrong with the fact that the database...
To determine the size of tables in a database hosted on Microsoft SQL Server, you need to perform the following steps: 1. Connect to a database server using SQL Server Management Studio...
SQL Server applies role-based security rights delimitation. A role is a certain set of rights that can be assigned to a certain user or group of users.In SQL Server there are default server...
One of the tasks that one has to face during software development or DBMS administration (and, in particular, SQL Server) is determining which version of the SQL Server is installed, in which edition...