This project dealt with parsing my personal collection of T-SQL scripts into a SQL Server database. I needed to accomplish as much of that process as possible, programmatically because the number of snippets in my collection had become quite large. The scripts needed to be parsed from an XML file that my code snippet software uses and from .SQL files stored in the file system. I needed to be able to link every script to its database record and that link must be maintained, even after the title or content of the script have changed. It was a process that I expected to accomplish in a couple months, but it ended up taking almost a year.
Category: Projects
Remove Duplicate WordPress Posts in C# with WordPress API
While doing some QA on WordPress Poster, the program I wrote to post example T-SQL scripts and queries to my WordPress blog, I discovered that it duplicated many blog posts during testing. Thankfully, I anticipated that something like this could happen during the development of WordPress Poster and made sure that any content that it … Continue reading Remove Duplicate WordPress Posts in C# with WordPress API
T-SQL to WordPress HTML
T-SQL to WordPress HTML is a program I created to discover, load and parse into HTML, the T-SQL scripts and queries that make up the T-SQL portion of this website. The scripts originated from a directory of SQL files on my development machine and from the code snippet management software I use, called Snippet Manager. … Continue reading T-SQL to WordPress HTML
WordPress Poster
WordPress Poster is an application I developed to manage most of the example queries and scripts in the T-SQL section of this website. The program adds new blog posts to this site when I create them on my PC and includes logic to determine if it should apply updates to the scripts I've already posted. … Continue reading WordPress Poster
Microsoft Docs Parser
When I decided to post my T-SQL script library on this site, I wanted to be able to identify things like T-SQL functions, data types and language elements along with SQL Server system objects (i.e. system views, system procedures, system tables, system functions) that were in each script. The Microsoft Docs Parser is a program … Continue reading Microsoft Docs Parser