WPF SQLite Dapper List and Add People – 1
This series of posts shows us how to build a WPF project using SQLite and Dapper that allows […]
sql
SQLite Database Introduction
SQLite is a relational database management system (RDBMS) contained in a C library that ends up being embedded […]
WPF Insert into SQL Server Table with Dapper
In this post we look at inserting a row of data into a SQL Server table from a […]
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 […]
SQL Server Installation
As of February 2019, the time of this writing, the current version of SQL Server is 2017. There […]
MySQL Introduction
MySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, one of […]
Create Table SQL Script in Excel
You have some data in Excel that you need to import into SQL Server. You don’t have a […]
SQL Server B-Tree
When you think of B-trees, think “clustered index”. All indexes in SQL Server on disk-based tables are structured […]
SQL Server Pages and Extents
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of […]
SQL Server Left Joins Simplified
In order to more easily understand left joins we will modify Itzik Ben-Gan’s database from the previous post […]
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 […]