T-SQL Parse a String 2In this post I’ll discuss how to parse a string in SQL Server so that you can move […] November 16, 2021 in SQL Server tagged string / parse / SQL Server Parsing by Mike
T-SQL Parse a StringIn SQL Server, do you have a table with a column that has several values in it that […] November 15, 2021 in SQL Server tagged csv / string / parse / charindex / substring / SQL Server Parsing by Mike
Splitting a Large Text FileSome text files are so large that they become difficult to work with. For example, If you try […] November 14, 2021 in Database tagged Bash / split / tsv / large / file / text / csv / git by Mike
Internet Movie Database (IMDB)The Internet Movie Database (IMDB.com) is a large website containing information related to films, television programs, home videos, […] November 12, 2021 in IMDB tagged dataset / movie / imdb / tv / database / internet / IMDB Data Files by Mike
SQL Select DistinctSometimes a column in a table has repeating values and you want to know what the list of […] November 12, 2021 in SQL Server tagged distinct / unique by Mike
SQL Count NULLsHow many NULLs are there in a column? What would the SQL query be? For small tables you […] November 12, 2021 in SQL Server tagged count / null / SQL Count by Mike
SQL Server Count DuplicatesYou may have a need to count the number of duplicates in a column. Perhaps you want to […] November 12, 2021 in SQL Server tagged duplicates / count / duplicate / SQL Count by Mike
Multiple Genres in Genres ColumnThis post discusses the code for a movie database that has a table with a list of genres […] November 10, 2021 in SQL Server tagged parse / foreign / movie / genre / genres / parsing / key / SQL Server Parsing by Mike
Atomicity of First Normal FormEdgar F. Codd’s definition of First Normal Form (1NF) makes reference to the concept of ‘atomicity’. Codd states […] November 10, 2021 in SQL Server tagged Atomicity by Mike
T-SQL Parse a String in a ColumnDo you have a column in your SQL Server database that contains a list of things separated by […] November 10, 2021 in SQL Server tagged string / parse / split / normalize / parsename / reverse / replace / Atomicity by Mike
SQL Server Import Data from a Text File Part 5While this is part 5 of this series, this will be the most simple example. I will be […] November 8, 2021 in SQL Server tagged import / insert / bulk / tab / delimited / tsv / SQL Server Import by Mike
Test Data GeneratorDo you need some sample or test data for your project? Are you doing work in a spreadsheet […] October 27, 2021 in Database tagged data / test / sample / set / generate / dataset / online / fake / generator by Mike