SQL Server Case
The SQL Server Case statement is best explained by example. What Case allows us to do is get […]
Database
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 […]
Distributed Database
What is a distributed database? Here is what Wikipedia says: “A distributed database is a database in which […]
Blockchain Introduction
Blockchain is revolutionary software. Blockchain is an Internet protocol that tells the Web how to transfer the rights […]
SQL Server Documentation
There are several ways to document a database. This post will only discuss some of the queries you […]
SQL Server Extended Properties Part 2
This article discusses how to view extended properties in a SQL Server database. Our previous article discussed how […]