How To
Using SQLite ODBC with .NET on Simple Examples
If you want to know everything about SQLite ODBC and how to use it with .NET, you are on the right way. In this article, we will consider the SQLite ODBC driver, SQL ODBC connection string, SQLite database manager with GUI, and code examples in .Net.
(more…)Create ER Diagram for SQL Server Database Using SSMS and SQL Designer
Entity Relationship Diagrams are widely used for analyzing database structure and troubleshooting issues with logic or deployment. In this article, we provide a detailed walkthrough of what an ER Diagram is and how to create and manage database diagrams.
(more…)Oracle DROP USER Command with Examples
Oracle is one of the most popular relational database management systems famous for its flexibility and convenience for information management. You can easily adjust any Oracle database to meet your everyday requirements. Sometimes, it is necessary to delete particular users from your Oracle database. Basically, there are two ways of achieving this goal: by using the Oracle DROP USER
command or with the help of an Oracle IDE allowing you to automate the process. This tutorial is valid for all Oracle versions starting from 11g-12c and ending with 19c.
How to Compare Two Formatting Styles in dbForge SQL Complete
One of the primary features of dbForge SQL Complete—a top-tier add-in for SSMS and Visual Studio—is code formatting, which helps beautify SQL code and make it consistent and easy to read, understand, review, and share across teams.
(more…)What is the Difference Between Schema and Database?
Today, we are going to talk about whether schema and database is the same. To be more precise, we will describe the main differences between these two terms in general. After that, we will take a closer look at the differences between databases and schemas in the following relational database management systems: SQL Server, MySQL, PostgreSQL, and Oracle.
(more…)Understanding PostgreSQL Date Types and Functions (by Examples)
In this article, we will look into working with dates in PostgreSQL, including the various date data types and formats, their functions, and the ways how to deal with them in your everyday routine. We will be using dbForge Studio for PostgreSQL to illustrate the examples.
(more…)WHERE Condition in MySQL with 16 Different Query Examples
In this article, we are going to talk about the WHERE
clause and how to use it in MySQL. Besides SELECT
, the scope of the WHERE
clause includes the UPDATE
and DELETE
statements. The WHERE
clause is indispensable for quality work with MySQL databases. That’s why the current article will deal with this clause and explore its distinguishing features in-depth.
How to Switch From SSMS to dbForge Studio Effortlessly
If you are reading this, chances are that you are an active user of Microsoft SSMS. And following the title that has brought you here, you may ask us: why should you bother switching? What should dbForge Studio ever offer to make you leave the convenient familiarity of SSMS?
(more…)How to Work With Inheritance in Entity Framework Core
Entity Framework Core from Microsoft is a cross-platform, lightweight, and flexible version of its predecessor, Entity Framework. EF Core is an object-relational mapper (ORM) tool that offers a standardized way of storing and retrieving data to and from diverse data sources.
(more…)Incremental Load in SSIS
People are ever more in a hurry. They want their data almost right now. And even more, data is getting bigger and bigger. So, you can’t use good old techniques because they’re “good enough”. It has to be fast. And ETL steps are not an exemption. This is where incremental load comes to play. And if you’re on this page, you probably are looking for incremental load in SSIS.
(more…)