Tag: sqls
It takes 2 actions to determine the size of tables in a database from a command line hosted on a MySQL or MariaDB server:1. Connect to the database server with the command: mysql -u root -p...
Microsoft SQL Server allows you to import data from an Excel file into a database using the built-in T-SQL language in an SQL query. Today I will tell you in detail how it is done, what...
Today we will consider how to run Python code in a Microsoft SQL Server database, you will learn what you need to do to enable this feature, and how to run Python code using a regular T-SQL...
Enabling profiling is an affordable way to get an accurate estimate of the time the request has been executed. First you need to enable profiling and call show profiles to get an accurate...
We will consider in detail the process of installing the free edition of MySQL 8 Community on the Windows 10 operating system. What is MySQL? MySQL is a free relational database management...
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...
In this material I will show you how to compare two databases in Microsoft SQL Server with the possibility of further synchronization, while showing a simple way that does not require writing complex...
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...
You probably already know that you can disable the index. This can be handy with large loads, and loading + enabling indexes (you will have to completely rebuild them) is faster than loading with...
When you run SELECT COUNT(*), the speed of results depends largely on the structure and settings of the database. Let's do a survey on the Votes table in the Stack Overflow database - 300 GB version...
Cool hints of requests - SQL Server documentation contains a pretty cool list of query hints: But what is the color box? Let's see.Since SQL Server query optimizer usually chooses the best...
Azure Data Studio is a free open source tool for working with Microsoft SQL Server databases. Azure Data Studio is based on Visual Studio Code and its interface is almost identical, the only...
This material provides an overview of 9 best tools that programmers and administrators use to work with Microsoft SQL Server. Azure Data Studio Azure Data Studio is a free, cross-platform, open...