All articles: Others

Checkout our self-help content, created by our top Experts!
How to Use Connection State Property for SQL Server with SqlConnection Class – Querychat
In the article, we learn how to get the current connection state for SQL Server using the SqlConnection class. This article also provides an example of using the SqlConnection state property in VB code to check the connection state to the SQL Server database. Information about connections, whether it is...
SQL Server vs DB2: Advantages and Disadvantages – Querychat
In this article, we will discover two DBMS, namely the MS SQL Server and IBM DB2. Also, we will find out what are their advantages and disadvantages. Microsoft SQL Server Microsoft SQL Server is one of the most popular DBMS. This is a database management system, the engine of which...
What is Teradata and its Main Features – Querychat
In this article, we will discover what Teradata is, the features of Teradata SQL, and why this database differs from other relational DBMSs. What is Teradata? The main feature of this database is that it is parallel, although this technology is far from new. What does parallelism mean? Teradata downloads,...
What is Azure SQL? – Querychat
In this article, we will find out what the Azure SQL is and what its main features are. Also, we will discover the Azure SQL pricing.  Azure SQL in a nutshell Azure SQL is often considered to be SQL Server but in the form of a cloud database. This is...
How to Perform an Audit Transformation in SSIS – Querychat
In the article, we learn how SSIS Transformations works to audit the specified target table. Providing an example of SSIS Audit Transformation to a database table in SQL Server. SSIS stands for SQL Server Integration Service. It is one of the ETL (Extract Transform Load) tools used to create ETL...
Azure management portal – Querychat
When we have SQL databases or other resources hosted on Microsoft Azure, we need to be able to use the tools to manage them. One of those tools is the Windows Azure Management Portal (or simply called Azure Management Portal). It is a web-based graphical interface for creating and managing...
How to Use a Specific Database in MySQL – Querychat
In this article, we will find out how to start our work with a specific database when our MySQL schema consists of several databases.  We will discover the basics of the USE statement, and also we will learn how to check the names of all our databases in the schema....
SQL Server Management Objects SMO – Querychat
SQL Server Management Objects (SMO) are objects defined for developers to automate and program Microsoft Server administration tasks. SMO is one of SQL Server cross-platform scripting modules made available for users not on windows machines. These modules support power-shell and other scripting languages and can be installed with SQL server...
How to Create an Azure SQL Database – Querychat
In this article, we will take a look at the step-by-step to create a new Azure SQL database using the Azure portal. We will also configure the Firewall to allow us accessing this new database. Lastly, we will verify that we can access it through the Internet using Management Studio....
Connect to SQL Server using Python on Windows – Querychat
This article explains the steps to connect to the SQL Server database using Python on Windows using pyodbc driver. There are several python SQL drivers available such as pypyodbc, pyodbc, and pymssql. However, it’s recommended to use pyodbc because Microsoft is putting its testing efforts and confidence in this driver....
1 2 15 16