SQL Server Merge
Sometimes in SQL Server you need to create a summary table from a transaction table. Transactions are coming […]
Blog
Oracle VM VirtualBox
VirtualBox is a cross-platform virtualization application. VirtualBox it installs on your existing Intel or AMD-based computers, whether they […]
SQL Server Case
The SQL Server Case statement is best explained by example. What Case allows us to do is get […]
SQL Server Intersect
INTERSECT says “give me what’s common to both” as the word itself implies. It is the intersection of […]
SQL Server Except
EXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […]
SQL Server Integer Data Types
Here is a table showing the integer types of SQL Server from the Microsoft website. INT goes up […]
SQL Server Union
This article is discussing the combining of two or more tables using UNION or UNION ALL into one […]
SQL Server Inserting Into Views
Suppose we have a view that we can select to see the rows and columns of the underlying […]
SQL Server Views
A SQL Server view is a type of table expression. A View is stored in the database (with […]
SQL Server Security
Schema and Views The dbo stands for database owner. It is the schema. Objects can be grouped together […]
Blockchain Applications
The most obvious application of blockchain is a digital payment system where payments are immediate or nearly immediate. […]
Distributed Database
What is a distributed database? Here is what Wikipedia says: “A distributed database is a database in which […]