WPF SQLite Dapper List and Add People – 1This series of posts shows us how to build a WPF project using SQLite and Dapper that allows […] May 6, 2020 in Dapper tagged sqlite / people / database / sql / WPF / Dapper / WPF SQLite Dapper People by Mike
SQLite Database IntroductionSQLite is a relational database management system (RDBMS) contained in a C library that ends up being embedded […] May 4, 2020 in Database tagged database / sql / lite / sqlite by Mike
Dapper micro-ORM IntroductionDapper is an open-source Object Relational Mapper (ORM) for .NET. It was written by the people over at […] May 3, 2020 in Dapper tagged data / database / query / Dapper / ORM / Dapper by Mike
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 […] May 3, 2020 in Dapper tagged grid / datagrid / Dapper / database / server / sql / WPF / read / Dapper by Mike
WPF Read a SQL Server Table into a DataGridThis post is about how to connect to a local SQL Server database and read a table from […] May 1, 2020 in WPF tagged datagrid / open / data / table read / database / connection / server / itemssource / sql / T-SQL / table / read / grid by Mike
ACID DatabasesACID (atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee validity even […] April 20, 2020 in Database tagged transaction / ACID / database by Mike
Move SQL Server Database FilesDo you need to move one or more of your SQL Server database files? For example, are the […] January 11, 2020 in SQL Server tagged database / files / move / mdf / ldf by Mike
SQL Server Error 5123Are you trying to attach a database to SQL Server Management Studio and getting Error 5123? Are you […] February 17, 2019 in SQL Server tagged 5123 / attach / denied / database / error / security / access / SSMS / administrator / run by Mike
MySQL IntroductionMySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, one of […] October 21, 2018 in Database tagged MySQL / RDBMS / database / sql by Mike
SQL Server Pages and ExtentsThe page is the fundamental unit of data storage in SQL Server. An extent is a collection of […] April 1, 2018 in SQL Server tagged database / pages / sql / internal / extents / SQL Server Data Structures by Mike
Itzik Ben-Gan’s SQL DatabaseIn Itzik’s book T-SQL Querying, published by Microsoft Press in 2015, he uses several tables as examples. Here […] March 6, 2018 in SQL Server tagged suppliers / sql / products / diagram / relationship / Itzik / tables / customers / orders / details / database / SQL Itzik Database by Mike
SQL Server Burton’s DatabaseThere exists a SQL Server online course at Udemy.com that prepares you for the 70-461 exam. The couse […] February 24, 2018 in SQL Server tagged database / sql / transaction / burton / diagram / relationship / department / employee by Mike