T-SQL Parsing To Get FrequencyThis post is about determining just how many parts there are in a string that is delimited with […] November 21, 2021 in SQL Server tagged sql / parse / SQL Server Parsing Many Columns by Mike
T-SQL Parsing Into Many ColumnsThis post is about working with one column in a SQL Server table that contains a comma-separated list […] November 20, 2021 in SQL Server tagged csv / string / parse / split / fruit / sql / T-SQL / SQL Server Parsing Many Columns by Mike
SQL Combining Two TablesThis post is about combining the data from two tables by adding columns, not rows. Here we think […] November 18, 2021 in SQL Server tagged sql / combine by Mike
Daily Thought Back-EndIn this third post on this project we’ll look at the back-end, meaning the database. The database technology […] November 25, 2020 in WPF tagged daily / thought / back / end / database / sql / table / sqlite / WPF Daily Thought by Mike
SQLite IntroductionWikipedia says: “SQLite is a relational database management system (RDBMS) contained in a C library. In contrast to […] November 11, 2020 in Database tagged sql / sqlite / local / database / SQLite by Mike
WPF ComboBox Colors with SQLiteThis post is a follow-up to a previous post called WPF ComboBox Colors. In this project, I have […] May 12, 2020 in WPF tagged picker / Linq / sql / Dapper / configuration / sqlite / colour / down / combobox / color / drop / options / box by Mike
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 people / database / sql / WPF / Dapper / sqlite / 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
WPF Insert into SQL Server Table with DapperIn this post we look at inserting a row of data into a SQL Server table from a […] May 4, 2020 in Dapper tagged sql / insert / into / connection / execute / 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 datagrid / Dapper / database / server / sql / WPF / read / grid / 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 table / read / grid / datagrid / open / data / table read / database / connection / server / itemssource / sql / T-SQL by Mike
SQL Server InstallationAs of February 2019, the time of this writing, the current version of SQL Server is 2017. There […] February 16, 2019 in SQL Server tagged server / sql / installation / 2017 by Mike