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
Author: Rick Bishop
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
SQL Server 2016: Look up the Current UTC Offset and Daylight Savings Time indicator for any Time Zone
Sql Server 2016, ships with a new system catalog view that returns the current UTC Offset for a given time zone and whether the time zone is currently observing Daylight Savings Time. Fun fact: Not all UTC offsets are in one hour increments. Some are only 30 minutes. The time zones listed are the ones … Continue reading SQL Server 2016: Look up the Current UTC Offset and Daylight Savings Time indicator for any Time Zone
Everything you Need to know about WordPress Hosting
When I decided to move forward with creating this website, I decided early on that I didn't want to repeat the mistakes of the past by re-inventing the wheel, going through all the trouble of either developing a content management system from something downloaded on SourceForge or some other open source repository, just for the … Continue reading Everything you Need to know about WordPress Hosting
Microsoft Reverses Course on Visual Basic
Just kidding. It's still the redheaded step child. But seriously, every time I roll up my sleeves and dive into a new Microsoft technology, a part of me holds back from getting too excited. I'm struck by the amount of code I've written for software and web applications that used technologies that were effectively killed … Continue reading Microsoft Reverses Course on Visual Basic