SQL Server Blog
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...
MySQL Workbench - A web developer grows with the projects he creates and develops. As the projects grow, the complexity of the software part increases, the amount of data processed by it...
Select SQL - I don't intend to go into sql, you can read about it in any guide to sql server,mysql mainly supports all the basic commands of the ansi 92 standard,but the select command deserves...
VIEW in MySQL - This article is an overview of views that appeared in MySQL version 5.0. It covers the creation, benefits and limitations of views. What is a VIEW in MySQL? A view (VIEW) is a...
On the World Wide Web you can find a lot of information on how to configure MySQL-server, but almost no information on how to use it for an ordinary user.This is probably because applications...
First let's answer the question - what is MySQL? It is a Database (DB) in which data is stored in a structured way. The second question follows - why to refuse from simple and convenient files to...
SQL injection is a dangerous vulnerability that occurs due to insufficient filtering of data entered by the user, which allows you to modify queries to databases.The result of the SQL...
UPDATE command - makes changes to an already existing record or to a set of records in an SQL table. Changes the existing values in the table or in the main view table. UPDATE command. Syntax...
The SQL JOIN language operator is intended for connecting two or more database tables by a matching condition. This operator exists only in relational databases.It is thanks to JOIN...
Oracle DBMS - Database software is the main software tool for managing large volumes of information today. A database management system (DBMS) must be able to reliably manage large volumes of...
SQLite is a library written in C, which implements the SQL mechanism for working with data, in other words, the database engine.SQLite is not a client library that only allows you to connect...