Splitting a Large Text File
Some text files are so large that they become difficult to work with. For example, If you try […]
Database
Internet Movie Database (IMDB)
The Internet Movie Database (IMDB.com) is a large website containing information related to films, television programs, home videos, […]
SQL Select Distinct
Sometimes a column in a table has repeating values and you want to know what the list of […]
SQL Count NULLs
How many NULLs are there in a column? What would the SQL query be? For small tables you […]
SQL Server Count Duplicates
You may have a need to count the number of duplicates in a column. Perhaps you want to […]
Multiple Genres in Genres Column
This post discusses the code for a movie database that has a table with a list of genres […]
Atomicity of First Normal Form
Edgar F. Codd’s definition of First Normal Form (1NF) makes reference to the concept of ‘atomicity’. Codd states […]
T-SQL Parse a String in a Column
Do you have a column in your SQL Server database that contains a list of things separated by […]
Text to SQL Server
While this is part 5 of this series, this will be the most simple example. I will be […]
Test Data Generator
Do you need some sample or test data for your project? Are you doing work in a spreadsheet […]
SQLite Introduction
Wikipedia says: “SQLite is a relational database management system (RDBMS) contained in a C library. In contrast to […]
Simple CRUD ToDo List with Dapper
We have a short series of posts here that show the listings for a simple WPF ToDo list […]