SQL Server Intersect
INTERSECT says “give me what’s common to both” as the word itself implies. It is the intersection of […]
Blog
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 […]
Windows Domain
Wikipedia begins to describe a Windows domain the following way: “A Windows domain is a form of a […]
Computer Network Types
Defining the types of computer networks is not an easy task. Networks can range from two computers connected […]
Binary and Decimal Numbers
0 00000000 32 00100000 64 01000000 96 01100000 1 00000001 33 00100001 65 01000001 97 01100001 2 […]