Tag: SQL
If you want to become a data processing and analysis specialist, you cannot do without SQL. This language can be used not only by analysts or scientists, but also by anyone who can spend several days...
SQL subqueries are queries attached to another query. Subqueries can be used:In the SELECT instruction; In the FROM instruction; In the WHERE condition.What is a subquery in SQL? The...
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...
In which cases it is necessary to manually add statistical objects to tables and indices in Microsoft SQL Server.The statistics can be generated automatically and updated depending on certain...
The Heimdall Data software agent automatically caches the data without disrupting the current infrastructure.Caching can optimize application response time and reduce database licensing costs....
The first cross-platform SQL Operations Studio tool from Microsoft for database developers and administrators.Microsoft SQL Operations Studio (or SOS, as the product was called) is the first tool...
The Azure SQL managed database instance will help you move local SQL Server applications to the cloud. Microsoft has announced a new addition to the Azure cloud services for SQL Server - Azure...
Microsoft turns a cross-platform solution into a convenient alternative for developers and database administrators. Microsoft seems to be closing the gap between Azure Data Studio and SQL Server...
Databricks is an analytical service based on the open source Apache Spark project. Databricks was used to absorb a significant amount of data. In February 2018, integration between Azure and...
Dynamic administrative views, time statistics and client statistics of SQL Server Management Studio.Configuring database performance is not the most enjoyable task for database professionals, but...
Almost all my recommendations addressed to developers of SQL Server, Visual Studio and VB.NET are based on readers' suggestions. Your ideas have made Reporting Services (SSRS) more effective.At...
T-SQL is an extension of the SQL language that is used in Microsoft SQL Server. This section contains materials for learning Microsoft SQL Server and T-SQL language. This is one of my favorite...
Many are already familiar with SSRS, know what it is and how to use them, but also many do not know this MS SQL server component, so now let's get acquainted with SQL Server Reporting Services,...
SQLCMD - Let's consider a command line tool that is used to interact with Microsoft SQL Server. In this article we will talk about SQLCMD, a command line tool that is used to interact with...
On postgresql.org you can find links to download different distributions for different operating systems. In particular, to download the Windows distribution you should go to enterprisedb.com and...
PostgreSQL is one of the most popular database management systems. The postgresql project itself has evolved from another project called Ingres. Formally, the development of postgresql began back in...