SQL Server Pages and Extents
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of […]
database
Itzik Ben-Gan’s SQL Database
In Itzik’s book T-SQL Querying, published by Microsoft Press in 2015, he uses several tables as examples. Here […]
SQL Server Burton’s Database
There exists a SQL Server online course at Udemy.com that prepares you for the 70-461 exam. The couse […]
Sample Relational Databases
You can use existing databases for testing purposes. If you are testing queries or just wanting a sample […]
Blockchain Implementation
How do you get started using blockchain? First of all you want to be sure that your specific […]
SQL Server Except
EXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […]
Distributed Database
What is a distributed database? Here is what Wikipedia says: “A distributed database is a database in which […]
SQL Server Export to Excel
https://www.microsoft.com/en-us/download/details.aspx?id=23734 Wizard From within SQL Server you can use the wizard to export a tables or tables (using […]
SQL Database Design Introduction
Over at the website SQL Server Central they have series of articles that they group into what they […]
SQL Server Introduction
Wikipedia says: “Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, […]
Database Model
Wikipedia says the following about the definition of a Database Model: “A database model is a type of […]
MongoDB Introduction
MongoDB (commonly referred to as simply Mongo), a play on the term “humongous,” is a general purpose NoSQL […]