SQLite Database Introduction
SQLite is a relational database management system (RDBMS) contained in a C library that ends up being embedded […]
database
Dapper micro-ORM Introduction
Dapper is an open-source Object Relational Mapper (ORM) for .NET. It was written by the people over at […]
WPF Read a SQL Server Table into a DataGrid with ...
This post is about how to connect to a local SQL Server database and read a table from […]
WPF Read a SQL Server Table into a DataGrid
This post is about how to connect to a local SQL Server database and read a table from […]
ACID Databases
ACID (atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee validity even […]
Move SQL Server Database Files
Do you need to move one or more of your SQL Server database files? For example, are the […]
SQL Server Error 5123
Are you trying to attach a database to SQL Server Management Studio and getting Error 5123? Are you […]
MySQL Introduction
MySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, one of […]
SQL Server Pages and Extents
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of […]
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 […]