Deep in the Code

Questions About SAP Training

David Young — Tue, 06 May 2025 18:49:05 +0000

I used to try to write at least two articles per month here, but since taking a new job back in October 2023, I’ve been consumed mostly with learning about various aspects of SAP such as ABAP, BSP, and the like. Even so, I’m still here. In the last year and a half, I’ve probably …

Continue reading "Questions About SAP Training"

The post Questions About SAP Training appeared first on Deep in the Code.

Filtering Null Values of Type DATS using SAP Open SQL

David Young — Thu, 21 Dec 2023 18:31:10 +0000

In October, I started a new phase in my career of twenty-five years as an IT professional: SAP software engineer. I had worked with SAP in some capacity over the years, but those experiences mostly revolved around connecting APIs to SAP endpoints or querying the SAP database directly using a SQL client like Oracle Developer. …

Continue reading "Filtering Null Values of Type DATS using SAP Open SQL"

The post Filtering Null Values of Type DATS using SAP Open SQL appeared first on Deep in the Code.

Setting up an HP Printer in HP Smart on WiFi with Dual Band Networks

David Young — Mon, 20 Nov 2023 18:55:20 +0000

Recently I had to buy a new printer, and I didn’t have time to do any real research on what I wanted, so I bought one of HP’s low-budget all-in-ones, the HP DeskJet 3755. Currently this printer is selling for less than $100. Setting this printer up on WiFi has been more complicated than I …

Continue reading "Setting up an HP Printer in HP Smart on WiFi with Dual Band Networks"

The post Setting up an HP Printer in HP Smart on WiFi with Dual Band Networks appeared first on Deep in the Code.

Filling the Skills Gap

David Young — Fri, 04 Aug 2023 14:29:39 +0000

Over the course of my career, I have learned about quite a few qualities that team members can possess that add value to the team. Many of these strengths are fairly obvious: being willing to work hard, prioritizing tasks properly to meet deadlines, not becoming siloed and unaware of what other team members are doing, …

Continue reading "Filling the Skills Gap"

The post Filling the Skills Gap appeared first on Deep in the Code.

Making a Code Block from a Power BI Query Readable Using Notepad++

David Young — Wed, 07 Jun 2023 22:53:16 +0000

Oftentimes, when looking at the Advanced Editor window on a Power BI query, you will see that the SQL query in one of the steps has been compressed into fewer lines – perhaps even only one line; minified with Power Query codes like “#(lf)” (line feed) and “#(tab)”. To make this more readable, you can …

Continue reading "Making a Code Block from a Power BI Query Readable Using Notepad++"

The post Making a Code Block from a Power BI Query Readable Using Notepad++ appeared first on Deep in the Code.

Finding Column and Table Names in Amazon Redshift using SQL

David Young — Tue, 09 May 2023 21:37:38 +0000

Finding metadata regarding table and column names in Redshift can be daunting, especially if you do not know if the tables are internal or external. Redshift has a table called SVV_EXTERNAL_COLUMNS that is useful for looking at external tables, and there are scripts to look at internal tables as well. The SQL code I wrote …

Continue reading "Finding Column and Table Names in Amazon Redshift using SQL"

The post Finding Column and Table Names in Amazon Redshift using SQL appeared first on Deep in the Code.

Generating SQL Scripts on SQL Workbench/J to Create Amazon Redshift Stored Procedures

David Young — Thu, 09 Feb 2023 06:34:26 +0000

The task of generating a SQL script for a stored procedure or function is fairly simple in Microsoft SQL Server using SQL Server Management Studio, or in Oracle Database, using SQL Developer. However, if your database is Amazon Redshift, you’re probably using SQL Workbench/J to interact with your database, and unfortunately, its ability to script …

Continue reading "Generating SQL Scripts on SQL Workbench/J to Create Amazon Redshift Stored Procedures"

The post Generating SQL Scripts on SQL Workbench/J to Create Amazon Redshift Stored Procedures appeared first on Deep in the Code.

Happy New Year!

David Young — Mon, 09 Jan 2023 20:25:57 +0000

The post Happy New Year! appeared first on Deep in the Code.

Microsoft Learn for the Win!

David Young — Wed, 21 Dec 2022 23:48:15 +0000

Over the last ten years or so, I have worked with many different computer-based training (CBT) programs from various vendors, some paid, and some free. Of all the ones I’ve used, Microsoft Learn – which is free, as in “free beer”! – has been the best overall. Not only is the variety of subjects available …

Continue reading "Microsoft Learn for the Win!"

The post Microsoft Learn for the Win! appeared first on Deep in the Code.

Power BI Gateway Timeout Issue

David Young — Fri, 14 Oct 2022 22:57:47 +0000

Recently, I was informed that one of our Power BI Datasets could not be refreshed due to an error, and that the schedule had been turned off as a result. The error that was in the refresh history was similar to the one shown below. It appeared that something was causing a timeout on the …

Continue reading "Power BI Gateway Timeout Issue"

The post Power BI Gateway Timeout Issue appeared first on Deep in the Code.

Refreshing Published Power BI Reports

David Young — Wed, 31 Aug 2022 16:23:38 +0000

Since June, I have begun working in a new position that involves less in the way of application development, and more data analytics and database development. The primary tool I’ll be using is Microsoft Power BI, along with SQL Server, Amazon Redshift, and CRM Analytics (formerly called Tableau) for use with Salesforce. Power BI is …

Continue reading "Refreshing Published Power BI Reports"

The post Refreshing Published Power BI Reports appeared first on Deep in the Code.

Testing Connectivity to Multiple SQL Server Linked Servers

David Young — Mon, 27 Jun 2022 17:09:53 +0000

As we are preparing to migrate some of our older SQL Server databases that are nearing their end of support to SQL Server 2019, one of the necessary tasks is determining what Linked Servers need to be established on the new servers to maintain the existing functionality for all of our users’ applications. Testing the …

Continue reading "Testing Connectivity to Multiple SQL Server Linked Servers"

The post Testing Connectivity to Multiple SQL Server Linked Servers appeared first on Deep in the Code.

Ten Years of Deep in the Code!

David Young — Mon, 23 May 2022 22:44:08 +0000

What a long strange trip it’s been! Ten years ago today I made my first blog post here, and since then, I’ve learned quite a bit, and I hope that I’ve helped more than a few people with all the various and sundry issues that I’ve had during my adventures in software development. In 2012, …

Continue reading "Ten Years of Deep in the Code!"

The post Ten Years of Deep in the Code! appeared first on Deep in the Code.

Fixing the “Identity key store file not found” Error in Primavera P6 EPPM

David Young — Thu, 12 May 2022 07:00:06 +0000

Recently, I’ve installed multiple instances of Oracle Primavera P6 EPPM version 21 on Windows servers running Oracle WebLogic 12. In each case, after installing WebLogic and P6 EPPM, I get an error similar to the one below when trying to start the Node Manager: From what I can tell, this must be caused by a …

Continue reading "Fixing the “Identity key store file not found” Error in Primavera P6 EPPM"

The post Fixing the “Identity key store file not found” Error in Primavera P6 EPPM appeared first on Deep in the Code.

Saying Goodbye to ActiveX

David Young — Thu, 27 Jan 2022 21:36:24 +0000

I’ve never had much reason to use ActiveX controls, though one major web application I support has a function where users are able to send log entries via Outlook email. This function was built using an ActiveX control many years ago, when Internet Explorer was the only browser we had to support. If a user …

Continue reading "Saying Goodbye to ActiveX"

The post Saying Goodbye to ActiveX appeared first on Deep in the Code.

Element is Undefined Java Error on Adobe ColdFusion

David Young — Fri, 03 Dec 2021 21:50:15 +0000

An error that I’ve run into a few times when implementing new components in a ColdFusion website is “Element [COMPONENT NAME] is undefined in a Java object of type class…” This error, when found in a development environment, is likely due to a typo in declaring locations for components in the Application.cfc file. (Or perhaps …

Continue reading "Element is Undefined Java Error on Adobe ColdFusion"

The post Element is Undefined Java Error on Adobe ColdFusion appeared first on Deep in the Code.

Documenting Filenames in the Source Code with Python

David Young — Tue, 04 May 2021 22:31:50 +0000

Troubleshooting a web application page that is made from a crazy quilt of source code files is not always easy. Whether your application is built using ASP, PHP, ColdFusion, or something completely different, the challenge here is the same. How do you find the line of code in the source that is causing the problem …

Continue reading "Documenting Filenames in the Source Code with Python"

The post Documenting Filenames in the Source Code with Python appeared first on Deep in the Code.

Fixing a SQL Server Job Status Without Restarting Services

David Young — Tue, 15 Sep 2020 15:30:55 +0000

Yesterday morning I received notice that a SQL Server job for an application I support that normally ran fairly regularly was not working. This job was not kicked off by a manual schedule, but was called from elsewhere. I was able to run the job manually with no problem at all. Nevertheless, the job did …

Continue reading "Fixing a SQL Server Job Status Without Restarting Services"

The post Fixing a SQL Server Job Status Without Restarting Services appeared first on Deep in the Code.

Widgets in Temenos Quantum Visualizer for iOS and Android

David Young — Fri, 05 Jun 2020 21:23:14 +0000

Over the last few weeks, I have been building an application using Temenos (formerly Kony) Quantum Visualizer version 9. This app will eventually be pushed to both Apple and Android phones and tablets, which is the main reason someone would use Visualizer instead of developing natively with XCode and Android Studio. In theory, the JavaScript …

Continue reading "Widgets in Temenos Quantum Visualizer for iOS and Android"

The post Widgets in Temenos Quantum Visualizer for iOS and Android appeared first on Deep in the Code.

Automate the Export of Primavera P6 Projects using Python – Part 2

David Young — Thu, 16 Jan 2020 17:12:44 +0000

Happy New Year! The result of Part 1 was a list of XER files, all of which were in one folder. It is not clear from where in the Enterprise Project Structure (EPS) that each file belonged. Perhaps you would like to create a hierarchy of folders similar to the project screen in P6? I …

Continue reading "Automate the Export of Primavera P6 Projects using Python – Part 2"

The post Automate the Export of Primavera P6 Projects using Python – Part 2 appeared first on Deep in the Code.

Automate the Export of Primavera P6 Projects using Python

David Young — Fri, 06 Dec 2019 23:09:15 +0000

With a switch from an old version of P6 (8.2) to a new one (18.8), I needed to export our old projects from the 8.2 database into XER files. After discovering that the number of projects in that old database was in the thousands, I knew I’d have to automate the process if I wanted …

Continue reading "Automate the Export of Primavera P6 Projects using Python"

The post Automate the Export of Primavera P6 Projects using Python appeared first on Deep in the Code.

Maintaining Consistent Primavera P6 Client Configuration Files Across Multiple Users Using PowerShell – Part 2

David Young — Wed, 11 Sep 2019 17:42:32 +0000

A refactored and updated version of the P6config.cmd script below allows for multiple profiles, both Local and Roaming.

The post Maintaining Consistent Primavera P6 Client Configuration Files Across Multiple Users Using PowerShell – Part 2 appeared first on Deep in the Code.

Maintaining Consistent Primavera P6 Client Configuration Files Across Multiple Users Using PowerShell

David Young — Mon, 09 Sep 2019 21:20:35 +0000

In setting up Oracle’s Primavera P6 EPPM version 18.8, I discovered that users who connected to the client via Citrix were not picking up changes that were made to the default configuration file. Normally, if that file is changed and is newer than the user’s own file, it will be overwritten with the default. In …

Continue reading "Maintaining Consistent Primavera P6 Client Configuration Files Across Multiple Users Using PowerShell"

The post Maintaining Consistent Primavera P6 Client Configuration Files Across Multiple Users Using PowerShell appeared first on Deep in the Code.

Blockchain: Where to Begin?

David Young — Wed, 28 Aug 2019 22:00:40 +0000

Blockchain is a technology that I hear about almost every day now. And yet I haven’t found the best place to learn about it – both its concepts and its implementation. With so many courses and books, where to begin? Those of you who have learned about it and use it regularly – what resources …

Continue reading "Blockchain: Where to Begin?"

The post Blockchain: Where to Begin? appeared first on Deep in the Code.

Examining the TransactionObject in PowerBuilder During Update and Delete

David Young — Fri, 28 Jun 2019 00:07:06 +0000

During the upgrade of an application from Sybase PowerBuilder 6.5 to SAP PowerBuilder 12.6, I ran into a bug in the Update event that had me suspicious that the TransactionObject was somehow changing, causing the update to be directed toward a different database. As it turns out, the bug was due to a trigger in …

Continue reading "Examining the TransactionObject in PowerBuilder During Update and Delete"

The post Examining the TransactionObject in PowerBuilder During Update and Delete appeared first on Deep in the Code.

Memory Issues with Oracle WebLogic Smart Update

David Young — Tue, 14 May 2019 22:05:16 +0000

If you need to update Oracle WebLogic 10.3.6 on Solaris / UNIX / Linux with a security patch or service pack, you will likely find yourself using the Oracle Smart Update program. This program, which is run by executing the script bsu.sh, is usually found in the utils/bsu folder underneath the BEA Home folder. For …

Continue reading "Memory Issues with Oracle WebLogic Smart Update"

The post Memory Issues with Oracle WebLogic Smart Update appeared first on Deep in the Code.

Changing the Authentication Mode in Oracle Primavera P6 EPPM Using SQL

David Young — Sat, 13 Apr 2019 00:13:42 +0000

I am currently in the process of setting up an Oracle Primavera P6 EPPM 18.8 environment. The operating system on the application and Web server is Windows Server 2012 R2, the middleware is Oracle WebLogic 12c, and Oracle Database 12c for the RDBMS. This is the first time I’ve ever set up P6 from scratch, …

Continue reading "Changing the Authentication Mode in Oracle Primavera P6 EPPM Using SQL"

The post Changing the Authentication Mode in Oracle Primavera P6 EPPM Using SQL appeared first on Deep in the Code.

Enabling Integrated Windows Authentication in Chrome on a Mac

David Young — Thu, 21 Mar 2019 19:40:20 +0000

I was surprised at how difficult it was to find this information, given that Chrome is certainly one of the most widely-used browsers in the world, and also that it is commonplace to have Macs connecting to Windows domains. I found that the domains that would be sent IWA information are set in the AuthServerWhitelist …

Continue reading "Enabling Integrated Windows Authentication in Chrome on a Mac"

The post Enabling Integrated Windows Authentication in Chrome on a Mac appeared first on Deep in the Code.

SQL Server Script to Create INSERT Statements

David Young — Thu, 28 Feb 2019 23:54:11 +0000

Though you can generate INSERT statements using SQL Server Management Services if the Generate Scripts functionality is enabled, this script may help in cases when it is not. This script may not work in every single case, as there are data types not accounted for here.

The post SQL Server Script to Create INSERT Statements appeared first on Deep in the Code.

Use “IS NULL” Rather Than “= NULL” When Upgrading to Newer Versions of SQL Server

David Young — Thu, 31 Jan 2019 22:50:12 +0000

I’ve been upgrading an old Sybase PowerBuilder 6.5 app to a much newer version, SAP PowerBuilder 12.6. During this little adventure, I’ve had to update much of the hard-coded SQL code that was originally written for SQL Server 4.2, and was later upgraded to SQL Server 2000. This application’s database had been running on SQL Server …

Continue reading "Use “IS NULL” Rather Than “= NULL” When Upgrading to Newer Versions of SQL Server"

The post Use “IS NULL” Rather Than “= NULL” When Upgrading to Newer Versions of SQL Server appeared first on Deep in the Code.

A Solid-State Drive Can Revitalize that Old MacBook Pro

David Young — Tue, 08 Jan 2019 19:06:38 +0000

I’ve had the same MacBook Pro (late-2011 model 8,1) since early 2012, and am no longer able to put new versions of macOS on it, as Mojave only works with newer models. Over the years it’s become much slower, and the 500 GB HDD that came with it – almost being full – is near …

Continue reading "A Solid-State Drive Can Revitalize that Old MacBook Pro"

The post A Solid-State Drive Can Revitalize that Old MacBook Pro appeared first on Deep in the Code.

Don’t Put Spaces in Java Install Path!

David Young — Fri, 07 Dec 2018 23:17:16 +0000

So you’ve decided you want to install Oracle Middleware Weblogic Server on Windows, but you haven’t installed the Java JDK yet. Are you thinking about installing it somewhere like “C:\Program Files\Java\jdk…”? Do not pass GO, do not collect $200, go directly to Oracle installation jail! For whatever reason, Oracle – who also happens to own …

Continue reading "Don’t Put Spaces in Java Install Path!"

The post Don’t Put Spaces in Java Install Path! appeared first on Deep in the Code.

HTTP Error 414 on WordPress

David Young — Mon, 26 Nov 2018 22:23:38 +0000

While trying to update the WP LinkedIn widget on a WordPress blog, I ran into an HTTP error I had never seen before: 414. HTTP error 414 indicates that the URI is too long for the web server to interpret it. In the case of a WordPress blog, this is likely caused by a security …

Continue reading "HTTP Error 414 on WordPress"

The post HTTP Error 414 on WordPress appeared first on Deep in the Code.

Mailing Attachments from the Terminal Prompt in UNIX and Linux

David Young — Thu, 25 Oct 2018 21:25:44 +0000

Transferring files from a UNIX or Linux server when FTP is not installed can be tricky. In my case, there was a set of log files that I needed to send to someone for analysis. After discovering that FTP was not set up on the server, I decided to try another route: zipping the logs …

Continue reading "Mailing Attachments from the Terminal Prompt in UNIX and Linux"

The post Mailing Attachments from the Terminal Prompt in UNIX and Linux appeared first on Deep in the Code.

Entering License Keys for ColdFusion 2018

David Young — Fri, 28 Sep 2018 20:13:07 +0000

In case you decide not to enter a license key upon installing CF 2018, or if you entered one at installation, but want to enter a different one to upgrade between versions, there doesn’t seem to be any documentation on where to do that. The System Information screen can be accessed by clicking the “i” …

Continue reading "Entering License Keys for ColdFusion 2018"

The post Entering License Keys for ColdFusion 2018 appeared first on Deep in the Code.

ColdFusion 11 Requires Accuracy When Naming Stored Procedure Parameters

David Young — Wed, 26 Sep 2018 18:09:43 +0000

In the process of finally banishing Adobe ColdFusion 8 from my application servers and completing the transition to CF 11, I came across what is apparently a little-known change in the operation of the CFPROCPARAM tag inside a CFSTOREDPROC tag. After moving the website from CF 8 to CF 11, there were no major changes …

Continue reading "ColdFusion 11 Requires Accuracy When Naming Stored Procedure Parameters"

The post ColdFusion 11 Requires Accuracy When Naming Stored Procedure Parameters appeared first on Deep in the Code.

Copying Windows Registry Keys from One User to Another

David Young — Wed, 19 Sep 2018 17:56:43 +0000

After switching the logged on user on a Windows Service, I found out that the original user had some printers set up that were not present in the new user’s profile. While I could have manually set up the necessary printers on the new user, it seemed that there must be a way to do …

Continue reading "Copying Windows Registry Keys from One User to Another"

The post Copying Windows Registry Keys from One User to Another appeared first on Deep in the Code.

Overriding the USER_TABLES and USER_VIEWS Public Synonyms

David Young — Wed, 05 Sep 2018 19:32:16 +0000

To increase the level of security on one of the applications I support, I had to create a new user (we’ll call this one APPUSERREAD) in our Oracle Database that had read-only access to the previous application user schema (and this one will be APPUSER). One of the challenges at this point was to avoid …

Continue reading "Overriding the USER_TABLES and USER_VIEWS Public Synonyms"

The post Overriding the USER_TABLES and USER_VIEWS Public Synonyms appeared first on Deep in the Code.

Error when Migrating SOAP Web Services from Adobe ColdFusion 8 to CF 11

David Young — Thu, 23 Aug 2018 21:57:47 +0000

After moving a CF 8 app to CF 11, I ran into a difficulty in trying to set up the Web Service in the CF 11 Administrator. Since I couldn’t get the CF 11 server to accept a new entry in the Web Services list, I had to do a little more troubleshooting using what …

Continue reading "Error when Migrating SOAP Web Services from Adobe ColdFusion 8 to CF 11"

The post Error when Migrating SOAP Web Services from Adobe ColdFusion 8 to CF 11 appeared first on Deep in the Code.

Return URL with JavaScript that Prevents Loading of Cached Pages

David Young — Wed, 08 Aug 2018 17:06:00 +0000

If you want to force a page to reload from the server rather than getting a cached copy, one way to do it is to append a query string to the URL. If you want your web application to generate URLs that have this functionality, the code below can be implemented using JavaScript. Inside a …

Continue reading "Return URL with JavaScript that Prevents Loading of Cached Pages"

The post Return URL with JavaScript that Prevents Loading of Cached Pages appeared first on Deep in the Code.

Executing Stored Procedures in Loops Using PL/SQL Tables

David Young — Tue, 31 Jul 2018 20:59:43 +0000

I needed to be able to run a stored procedure once for each item in a list. In Microsoft SQL Server, I would probably do this with a table variable and a cursor, and the code would look something like this: However, PL/SQL does not have table variables. While an option like a global temporary …

Continue reading "Executing Stored Procedures in Loops Using PL/SQL Tables"

The post Executing Stored Procedures in Loops Using PL/SQL Tables appeared first on Deep in the Code.

Problems with iOS 12 Beta Screen Time

David Young — Fri, 20 Jul 2018 20:52:02 +0000

As should be obvious, putting a beta version of iOS on your primary iPhone may not be a wise choice – especially if you’re not a developer hunting for bugs. Even so, the iPhone 6s I bought for my daughter from Gazelle came with iOS 12 beta 3 loaded onto it. When I saw this, …

Continue reading "Problems with iOS 12 Beta Screen Time"

The post Problems with iOS 12 Beta Screen Time appeared first on Deep in the Code.

Primavera P6 Session Hung on Oracle Database

David Young — Fri, 29 Jun 2018 20:47:26 +0000

Occasionally a user will close a P6 application and the user’s session does not just go away. The easiest thing I’ve found is to check to see if there are hung sessions in the usession table (in Oracle – other database types may use a different name). This is the type of error you might …

Continue reading "Primavera P6 Session Hung on Oracle Database"

The post Primavera P6 Session Hung on Oracle Database appeared first on Deep in the Code.

Bindings not Working on ColdFusion Server

David Young — Thu, 07 Jun 2018 22:37:36 +0000

Just a quick note here. If you are running ColdFusion and you know that your bindings are set up correctly, but web requests being sent to the default root of websites on your server other than the intended one, it it highly likely that the “Cache web server paths” option was mistakenly (or unwittingly) set, …

Continue reading "Bindings not Working on ColdFusion Server"

The post Bindings not Working on ColdFusion Server appeared first on Deep in the Code.

Enabling Single Sign-On in Citrix Receiver

David Young — Fri, 25 May 2018 17:24:20 +0000

After downloading a new version of Citrix Receiver and installing it, I discovered that the single sign-on (SSO) functionality that used to “just work”, had stopped working. After hunting through the Local Group Policy Editor, the registry, and the folder in which Citrix was installed, I was able to put together the following instructions. Completing …

Continue reading "Enabling Single Sign-On in Citrix Receiver"

The post Enabling Single Sign-On in Citrix Receiver appeared first on Deep in the Code.

Six Years of Deep in the Code

David Young — Thu, 24 May 2018 15:52:09 +0000

In looking through my older posts, I realized that I wrote my first post, Guide for the Perplexed, six years ago yesterday. I don’t have as much time to write as much as did during the first couple of years of this blog; I generally write two posts per month now. Even so, I hope …

Continue reading "Six Years of Deep in the Code"

The post Six Years of Deep in the Code appeared first on Deep in the Code.

Solving the ORA-12504 Error

David Young — Thu, 10 May 2018 15:58:28 +0000

When attempting to use the ODBC Data Source Administrator to test a connection to an Oracle Database from an Oracle client – one that did not have TNSPING installed – I got the above error: Unable to connectSQLState=S1000[Oracle][ODBC][Ora]ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA When searching this error, I found quite a few …

Continue reading "Solving the ORA-12504 Error"

The post Solving the ORA-12504 Error appeared first on Deep in the Code.

Comparing Multiple Patterns with LIKE Operator

David Young — Fri, 20 Apr 2018 18:54:59 +0000

I really like the LIKE operator! (See what I did there?) I use it on a daily basis. It does have one frustrating shortcoming, however. Unlike the IN operator (where a list is used for comparison), you can only compare one pattern with each LIKE statement. If you have only a few patterns, this isn’t …

Continue reading "Comparing Multiple Patterns with LIKE Operator"

The post Comparing Multiple Patterns with LIKE Operator appeared first on Deep in the Code.

Updating the PrmBootStrap.xml Primavera P6 DB Configuration File on Citrix Servers

David Young — Fri, 23 Mar 2018 16:12:11 +0000

I support an environment where users access the Primavera P6 thick client on Windows via Citrix. If I connect to the Database Configuration app and add, modify, or delete the connection to a P6 database, the PrmBootStrap.xml file that is in my profile. For the version we are using (8.2), that location is C:\Users(username)\AppData\Local\Oracle\Primavera P6\P6 …

Continue reading "Updating the PrmBootStrap.xml Primavera P6 DB Configuration File on Citrix Servers"

The post Updating the PrmBootStrap.xml Primavera P6 DB Configuration File on Citrix Servers appeared first on Deep in the Code.

Stripping HTML Tags from Textboxes Using JavaScript

David Young — Wed, 14 Mar 2018 21:43:59 +0000

One of the applications I support routinely has a problem where users cut and paste text that contains HTML tags from other sources into the text boxes on entry forms in my application. Most of the time, this does not cause a problem. However, if the users do not capture all of the text, they …

Continue reading "Stripping HTML Tags from Textboxes Using JavaScript"

The post Stripping HTML Tags from Textboxes Using JavaScript appeared first on Deep in the Code.

Problems with Installing Applications on Windows Servers via Remote Desktop

David Young — Wed, 28 Feb 2018 17:09:33 +0000

If you have tried to install an application on a Windows Server when logged in with Remote Desktop Connection and the result was a dialog box like the one above, this post is for you. Understandably, many software companies want different kinds of licensing to be used when installing on a server running Terminal Services. …

Continue reading "Problems with Installing Applications on Windows Servers via Remote Desktop"

The post Problems with Installing Applications on Windows Servers via Remote Desktop appeared first on Deep in the Code.

Using CSS to Create Resizable Columns in WordPress with Thesis Theme…Part Deux!

David Young — Wed, 31 Jan 2018 20:23:57 +0000

About three years ago, I wrote a post about dynamically resizing the content column in WordPress.org when using the Thesis theme. The method described in that post worked fine until Thesis 2.4 was released last August. At that time, I noticed that my columns were no longer the full width of the window, and did …

Continue reading "Using CSS to Create Resizable Columns in WordPress with Thesis Theme…Part Deux!"

The post Using CSS to Create Resizable Columns in WordPress with Thesis Theme…Part Deux! appeared first on Deep in the Code.

Enabling SSL on WordPress Posts Automatically

David Young — Wed, 17 Jan 2018 23:29:47 +0000

At the end of last year, I wrote about setting the Enable SSL checkbox on all past pages and posts. What I did not address was how to automatically set the Enable SSL checkbox automatically – you currently have to manually click the box. Hard, I know. Nevertheless, I always like to find ways to …

Continue reading "Enabling SSL on WordPress Posts Automatically"

The post Enabling SSL on WordPress Posts Automatically appeared first on Deep in the Code.

Adding Configuration Files to Oracle Database 12c Instant Client

David Young — Fri, 05 Jan 2018 15:52:43 +0000

Happy New Year! Though I generally prefer to use the full Oracle client, I have many customers that use the Instant Client to save space. However, this setup frequently is missing the configuration files that may be necessary for some applications to be able to find database servers. If you are missing any of the …

Continue reading "Adding Configuration Files to Oracle Database 12c Instant Client"

The post Adding Configuration Files to Oracle Database 12c Instant Client appeared first on Deep in the Code.

Bulk Check “Enable SSL” Checkbox in WordPress

David Young — Fri, 29 Dec 2017 20:08:14 +0000

I think this is really going to be my last post of the year! I promise!!! I recently discovered that, for some reason, there does not appear to be a built-in way to set the Enable SSL checkbox on multiple posts in WordPress. While there may not be an app for that – there is …

Continue reading "Bulk Check “Enable SSL” Checkbox in WordPress"

The post Bulk Check “Enable SSL” Checkbox in WordPress appeared first on Deep in the Code.

Datacenter Migration, Authentication Changes, and Solaris – The Perfect Storm

David Young — Thu, 28 Dec 2017 21:53:01 +0000

The action of moving an Oracle Primavera P6 database from one server to another should be fairly simple. Changing the authentication type on that database from a virtual LDAP server to native Active Directory should also be simple. Doing both at the same time? Not so much. And even though I generally try to keep …

Continue reading "Datacenter Migration, Authentication Changes, and Solaris – The Perfect Storm"

The post Datacenter Migration, Authentication Changes, and Solaris – The Perfect Storm appeared first on Deep in the Code.

Another Code School Profile Scraper Update

David Young — Thu, 28 Dec 2017 19:21:07 +0000

Merry Christmas! This will be a short post – I guess Code School must make minor changes to their user profile code about this time each year, as it was just a year ago that I had to update this code. For the codeschool.php file, change this: to this: This will eliminate the links that …

Continue reading "Another Code School Profile Scraper Update"

The post Another Code School Profile Scraper Update appeared first on Deep in the Code.

Connecting to an Oracle Database RAC with ColdFusion 11

David Young — Tue, 19 Dec 2017 22:29:16 +0000

Recently we’ve been moving quite a few servers and databases into our new datacenter, so I’ve been having to learn – more quickly than usual – about the often obscure differences between older and newer versions of various software including Solaris and Oracle Database. A change to an Oracle RAC system caused the most interesting …

Continue reading "Connecting to an Oracle Database RAC with ColdFusion 11"

The post Connecting to an Oracle Database RAC with ColdFusion 11 appeared first on Deep in the Code.

Oracle MySQL Workbench / macOS High Sierra Bug Officially Fixed!

David Young — Fri, 01 Dec 2017 18:41:16 +0000

This is an update for a previous post. Oracle has released version 6.3.10 of MySQL Workbench, fixing the results grid bug that only plagued users running macOS High Sierra. I was very glad to see this release, as I was contemplating switching to Toad for MySQL, which I quickly found out is not free anymore.

The post Oracle MySQL Workbench / macOS High Sierra Bug Officially Fixed! appeared first on Deep in the Code.

Sync iCloud Photos with iOS

David Young — Wed, 15 Nov 2017 18:58:02 +0000

This is not so much a software development topic as it is an iOS / iCloud issue that does not seem to be well-documented, but was solved only after discussing with Apple Support. The scenario here is where an iOS device (an iPhone 8 Plus, in this case) gets restored from backup. During the time …

Continue reading "Sync iCloud Photos with iOS"

The post Sync iCloud Photos with iOS appeared first on Deep in the Code.

Hidden Results Grid on MySQL Workbench and macOS High Sierra

David Young — Fri, 27 Oct 2017 20:57:51 +0000

UPDATE: Oracle has released version 6.3.10! I recently updated my MacBook Pro to macOS High Sierra. Like every other OS update, this one was fairly uneventful – with the exception of having to do a hard reboot to get the Mac to come back up after the upgrade. That was definitely a nail-biter! Once the …

Continue reading "Hidden Results Grid on MySQL Workbench and macOS High Sierra"

The post Hidden Results Grid on MySQL Workbench and macOS High Sierra appeared first on Deep in the Code.

Routers with DD-WRT and VPN – Where to Begin?

David Young — Wed, 25 Oct 2017 18:51:14 +0000

I decided to set up a VPN for use at home. After doing a little research, I found that a common setup is to get a router that is compatible with DD-WRT, a Linux-based firmware for wireless access points and routers, and then to connect to one of many VPN services. After signing up for …

Continue reading "Routers with DD-WRT and VPN – Where to Begin?"

The post Routers with DD-WRT and VPN – Where to Begin? appeared first on Deep in the Code.

Open-Source Alternative to Adobe ColdFusion

David Young — Fri, 29 Sep 2017 19:15:12 +0000

Six years ago, I had reason to move several CFML applications from a Macromedia ColdFusion MX 6 server to what was the only major open-source alternative – Railo. Several years later, Railo was no longer being updated, and its website was shut down. The last post on the Railo site in mid-2015 mentioned a new …

Continue reading "Open-Source Alternative to Adobe ColdFusion"

The post Open-Source Alternative to Adobe ColdFusion appeared first on Deep in the Code.

Deleting Duplicate Rows in a SQL Server Table Using a CTE

David Young — Mon, 14 Aug 2017 20:45:05 +0000

Finding duplicate rows in a table is quite simple. Deleting only the duplicates – as opposed to deleting all rows that have duplicates – is a bit more complicated. I have a table variable called “@Readings” with the following schema: First, I load the table with data from another database on a linked server called …

Continue reading "Deleting Duplicate Rows in a SQL Server Table Using a CTE"

The post Deleting Duplicate Rows in a SQL Server Table Using a CTE appeared first on Deep in the Code.

Using Dependency Walker to Find Missing Dependencies

David Young — Thu, 03 Aug 2017 19:42:41 +0000

I was notified that a little-used application within my organization had begun displaying an error instead of allowing the users to log in via Citrix. This ActiveX control, which was integral to the operation of the application I was servicing, had come from a very old version of Crystal Reports. Apparently, someone had recently installed …

Continue reading "Using Dependency Walker to Find Missing Dependencies"

The post Using Dependency Walker to Find Missing Dependencies appeared first on Deep in the Code.

Moving a Legacy Citrix-Based Application to a Current Version of Windows

David Young — Wed, 26 Jul 2017 17:59:45 +0000

In my last post, the problem I experienced was with an old application (which I’ll call “App #1”) written in PowerBuilder 6.5, and accessed via Citrix. Today, a similar type of application (“App #2”) is the source of the problem, and the fact that it’s being moved to the same new server made the cause …

Continue reading "Moving a Legacy Citrix-Based Application to a Current Version of Windows"

The post Moving a Legacy Citrix-Based Application to a Current Version of Windows appeared first on Deep in the Code.

User Cannot Access an ODBC System DSN

David Young — Thu, 20 Jul 2017 22:35:48 +0000

In moving a Citrix-based application from one server to another, I discovered in testing that users who were not in the local Windows Administrators group on the Citrix server were no longer able to connect to an ODBC System Data Source Name (DSN) when presented with the connection dialog box. Though a box similar to …

Continue reading "User Cannot Access an ODBC System DSN"

The post User Cannot Access an ODBC System DSN appeared first on Deep in the Code.

Using MAX() in a SQL Subquery

David Young — Thu, 29 Jun 2017 17:03:01 +0000

One pro bono project I’m working on is improving a school website where parents can sign up for classes, view students’ grades, etc. One of the problems with the website was that the list of user accounts, which includes all parents and teachers, includes parents from previous years who no longer have students there. The …

Continue reading "Using MAX() in a SQL Subquery"

The post Using MAX() in a SQL Subquery appeared first on Deep in the Code.

Using PHP to Scrape the Report Card from a DataCamp Profile

David Young — Wed, 14 Jun 2017 17:57:38 +0000

UPDATE: This does not currently work, as DataCamp has changed the structure of profile pages. I will revise this as soon as is feasible. (7/26/17) Just as I have written scripts for displaying report cards for Code School, CodeEval, and Duolingo on my blog, I have written the below script for displaying a DataCamp profile. …

Continue reading "Using PHP to Scrape the Report Card from a DataCamp Profile"

The post Using PHP to Scrape the Report Card from a DataCamp Profile appeared first on Deep in the Code.

Java VM Issues While Installing Eclipse Neon on macOS Sierra

David Young — Fri, 19 May 2017 21:34:35 +0000

When installing the Eclipse IDE, one must be running a version of the Java Virtual Machine (JVM) that is compatible with the version of Eclipse that is being installed. I was trying to install Eclipse Neon on macOS Sierra, which is the most recent major release. Sierra ships with Java, but not the version which …

Continue reading "Java VM Issues While Installing Eclipse Neon on macOS Sierra"

The post Java VM Issues While Installing Eclipse Neon on macOS Sierra appeared first on Deep in the Code.

Connecting to Oracle 12g with the Instant Client and Excel VBA

David Young — Fri, 28 Apr 2017 16:45:15 +0000

One rather old application I’ve supported for several years loads data from Excel spreadsheets into a reporting database. These Excel spreadsheets have always been manually updated by several users. However, because the data that the users are entering into these spreadsheets are first being entered into another separate application database, these users have been doing …

Continue reading "Connecting to Oracle 12g with the Instant Client and Excel VBA"

The post Connecting to Oracle 12g with the Instant Client and Excel VBA appeared first on Deep in the Code.

DataCamp for Learning Data Science

David Young — Mon, 27 Mar 2017 19:59:28 +0000

I have long been a fan of sites that use gamification to teach technology-related skills such as programming languages and database concepts. I have used various free sites (such as Codecademy and Khan Academy) and premium sites like Code School. Each of these sites have strong and weak points, but all of them have been …

Continue reading "DataCamp for Learning Data Science"

The post DataCamp for Learning Data Science appeared first on Deep in the Code.

PSA: Be Wary of Unsolicited Business Loans and Other Offers of Money

David Young — Thu, 16 Mar 2017 18:09:49 +0000

This is my first post that is completely unrelated to the topic of software development or information technology, but I decided to write this public service announcement since anyone who runs a website is likely to be targeted by these types of scams. Over the last several days, I have received numerous calls per day …

Continue reading "PSA: Be Wary of Unsolicited Business Loans and Other Offers of Money"

The post PSA: Be Wary of Unsolicited Business Loans and Other Offers of Money appeared first on Deep in the Code.

Chrome Developer Tools Not Working

David Young — Wed, 22 Feb 2017 20:35:06 +0000

Recently I had to replace my Windows PC at work, and as a result, had to reinstall all of my applications, including Google Chrome. When I tried to open Chrome Developer Tools using the F12 key, nothing happened. The Inspect option seen when right-clicking on a web page was grayed out. I opened the drop-down …

Continue reading "Chrome Developer Tools Not Working"

The post Chrome Developer Tools Not Working appeared first on Deep in the Code.

Oracle Database Error ORA-01013 in Excel VBA After Migrating Application to New Server

David Young — Fri, 17 Feb 2017 21:48:48 +0000

I was testing an old Excel application that I had moved from one server to another and kept getting this error when running it on the new server: The error ORA-01013 (“user requested cancel of current operation”) is commonly a timeout issue. What could be causing a query to timeout on one server, but not …

Continue reading "Oracle Database Error ORA-01013 in Excel VBA After Migrating Application to New Server"

The post Oracle Database Error ORA-01013 in Excel VBA After Migrating Application to New Server appeared first on Deep in the Code.

Solving the ROW-00060 Error When Using SSIS with Oracle

David Young — Thu, 26 Jan 2017 22:24:06 +0000

I have built SSIS packages to load data from one Oracle database to another before, but never had I come across this error until recently: “ROW-00060: Internal error: [dainsert,16] Source: Oracle Destination: Oracle Error Occurred @ after 403k records.” Initially, I thought that some constraint had been violated on the destination data source – like …

Continue reading "Solving the ROW-00060 Error When Using SSIS with Oracle"

The post Solving the ROW-00060 Error When Using SSIS with Oracle appeared first on Deep in the Code.

Dealing with the Mixed Content Over HTTPS Error

David Young — Thu, 05 Jan 2017 23:18:25 +0000

It’s a new year, and with it comes new resolve to keep current with modern web development technologies! I had begun working through the recently-added PHP Path on Code School, and almost immediately I ran into a problem wherein the submit button on a quiz page caused the page to quit working. I reloaded the …

Continue reading "Dealing with the Mixed Content Over HTTPS Error"

The post Dealing with the Mixed Content Over HTTPS Error appeared first on Deep in the Code.

End of Another Year! … and a Minor Update to the Code School Profile Scraper

David Young — Wed, 21 Dec 2016 18:47:19 +0000

It’s hard to believe 2016 is already drawing to a close. It seems like just yesterday that I was writing about using PHP to search through my source code! Though I wouldn’t call this an intractable problem, I did notice something annoying when looking at my Code School profile on the sidebar of this site. …

Continue reading "End of Another Year! … and a Minor Update to the Code School Profile Scraper"

The post End of Another Year! … and a Minor Update to the Code School Profile Scraper appeared first on Deep in the Code.

When JavaScript’s deleteRow() Method Doesn’t Work

David Young — Fri, 28 Oct 2016 20:53:13 +0000

A section of JavaScript code that uses the method deleteRow() was giving me a headache in IE 11. I did not encounter this when using Chrome. In the code segment below, the variable “oHtmlTable” is assigned to an HTML table that already exists on a webpage. For no apparent reason, during the execution of the …

Continue reading "When JavaScript’s deleteRow() Method Doesn’t Work"

The post When JavaScript’s deleteRow() Method Doesn’t Work appeared first on Deep in the Code.

SQL Script to Find Text in all Database Tables and Views…Revised! Again!

David Young — Mon, 10 Oct 2016 19:46:32 +0000

The SQL script below, which modifies one I wrote last year, has been modified to work with SQL Server 2008 and newer versions. On these versions, when querying SQL Server to output the schema of a database table, length values of MAX are returned as -1. Since this script builds table variables that mimic the …

Continue reading "SQL Script to Find Text in all Database Tables and Views…Revised! Again!"

The post SQL Script to Find Text in all Database Tables and Views…Revised! Again! appeared first on Deep in the Code.

Scheduled Tasks and Anonymous Access in ColdFusion 11

David Young — Fri, 02 Sep 2016 17:04:18 +0000

I have been converting applications from ColdFusion 8 to CF 11 over the last several months, and some of the challenges have been quite a bit more daunting than this one. Even so, I felt this was worth mentioning. After copying all the code for my most recent upgrade candidate from the old server to …

Continue reading "Scheduled Tasks and Anonymous Access in ColdFusion 11"

The post Scheduled Tasks and Anonymous Access in ColdFusion 11 appeared first on Deep in the Code.

Windows Disks Keep Filling Up with Small Log Files

David Young — Mon, 08 Aug 2016 19:05:09 +0000

I noticed that a Windows server I use for development with Visual Studio 2013 Ultimate had begun filling its system drive with log files in C:\Windows\Temp for no apparent reason. The initial response of our infrastructure group was to simply delete the log files on a weekly basis, as no one could find the cause …

Continue reading "Windows Disks Keep Filling Up with Small Log Files"

The post Windows Disks Keep Filling Up with Small Log Files appeared first on Deep in the Code.

Missing Components After Moving a ColdFusion Site

David Young — Mon, 18 Jul 2016 17:15:28 +0000

Last week I was tasked with moving several of my applications from one CF 8 server to another one, due to the first server’s VM host having some kind of problem requiring daily restarts of the VM by our infrastructure team. After moving two applications, the users began complaining that one of the functions in …

Continue reading "Missing Components After Moving a ColdFusion Site"

The post Missing Components After Moving a ColdFusion Site appeared first on Deep in the Code.

Ruby on Rails Tutorial and Screencasts for Rails 5 Are Available!

David Young — Fri, 01 Jul 2016 04:56:20 +0000

The new Rails Tutorial from Michael Hartl is available at his main site and also at Learn Enough.

The post Ruby on Rails Tutorial and Screencasts for Rails 5 Are Available! appeared first on Deep in the Code.

Courses for Summer Learning

David Young — Mon, 30 May 2016 01:24:01 +0000

Two courses that have recently been made available (though I haven’t yet had the opportunity to take) at Code School are Powering Up With React (for React) and an HTML/CSS class called The Elements of Web Design. Summertime – which is rapidly approaching – is a good time to commit to spending time picking up …

Continue reading "Courses for Summer Learning"

The post Courses for Summer Learning appeared first on Deep in the Code.

Learning Enough to be Dangerous – Go From Being a Novice to an Advanced Developer

David Young — Fri, 29 Apr 2016 21:00:53 +0000

While I think the venerable Ruby on Rails Tutorial is still the best way to learn Rails, jumping into this tutorial can be challenging for those who are new to programming. With the fourth and latest beta of Rails 5 being released this past week, it is appropriate that Michael Hartl, the creator of the …

Continue reading "Learning Enough to be Dangerous – Go From Being a Novice to an Advanced Developer"

The post Learning Enough to be Dangerous – Go From Being a Novice to an Advanced Developer appeared first on Deep in the Code.

Changes in the ColdFusion.window.create Function Require a Modern Browser

David Young — Thu, 14 Apr 2016 21:47:07 +0000

I’m still working on upgrading some older CF8 applications to CF11. I came across an interesting problem, the exact cause of which I have not found, but I do have a solution of sorts. When the particular application I’m working on now was written, the standard browser that would be accessing it was Internet Explorer …

Continue reading "Changes in the ColdFusion.window.create Function Require a Modern Browser"

The post Changes in the ColdFusion.window.create Function Require a Modern Browser appeared first on Deep in the Code.

Using Ruby to Get All Links from a Sitemap XML File

David Young — Tue, 22 Mar 2016 19:48:43 +0000

I was looking at the cached pages on the Wayback Machine and decided to find out if that site had an API. (It does.) I wanted to find a way to use this API to submit links to the Wayback Machine database. As it turns out, a Ruby gem called WaybackArchiver has already been written …

Continue reading "Using Ruby to Get All Links from a Sitemap XML File"

The post Using Ruby to Get All Links from a Sitemap XML File appeared first on Deep in the Code.

Some Good Resources on Database Performance Optimization and Tuning

David Young — Wed, 16 Mar 2016 21:48:29 +0000

Database performance optimization is a skill that is very important for both the database administrator and the database developer. I decided to put together a few links here that may be useful in disseminating information about database tuning and query optimization on various database systems, both relational and non-relational. I’ll be updating this from time …

Continue reading "Some Good Resources on Database Performance Optimization and Tuning"

The post Some Good Resources on Database Performance Optimization and Tuning appeared first on Deep in the Code.

Fun with CFAJAXPROXY on ColdFusion 11

David Young — Thu, 03 Mar 2016 23:35:59 +0000

In the course of moving an application from ColdFusion 8 to ColdFusion 11, I came across some strange behavior caused by the CFAJAXPROXY tag. In CF8, a particular CFCOMPONENT called ProjectBeanService had proxies set up for its methods in the rendered JavaScript like this: However, in CF11, more proxies were created: This made no sense …

Continue reading "Fun with CFAJAXPROXY on ColdFusion 11"

The post Fun with CFAJAXPROXY on ColdFusion 11 appeared first on Deep in the Code.

Adding Lines to the Beginning and Ending of Files Using PowerShell

David Young — Wed, 17 Feb 2016 19:40:47 +0000

In dealing with an application with which I had little familiarity, I discovered that troubleshooting an app (in this case developed using ColdFusion) where many of the source code files are “included” dynamically can be difficult – especially when JavaScript scripts are combined that have functions with identical names. Because so many of the functions …

Continue reading "Adding Lines to the Beginning and Ending of Files Using PowerShell"

The post Adding Lines to the Beginning and Ending of Files Using PowerShell appeared first on Deep in the Code.

Adding a User to Multiple Exchange Distribution Lists Using Windows PowerShell

David Young — Fri, 12 Feb 2016 22:31:30 +0000

Adding a user to multiple distribution lists via Outlook can be a tedious process if many lists are involved. For today’s problem, I had to add a user to many lists that have a similar prefix. Instead of spending a an hour or more of adding the user to the DLs through the Global Address …

Continue reading "Adding a User to Multiple Exchange Distribution Lists Using Windows PowerShell"

The post Adding a User to Multiple Exchange Distribution Lists Using Windows PowerShell appeared first on Deep in the Code.

Using the Bing API to Send Pings to Ping-O-Matic

David Young — Tue, 09 Feb 2016 22:38:31 +0000

Those who use WordPress may be familiar with Ping-O-Matic for keeping blog search engines updated whenever a new post is written. I discovered that Bing had more of my posts indexed than any other search engine. I could manually submit the link for each post to Ping-O-Matic, but that would be no fun. Instead, I …

Continue reading "Using the Bing API to Send Pings to Ping-O-Matic"

The post Using the Bing API to Send Pings to Ping-O-Matic appeared first on Deep in the Code.

Using Macrium Reflect to Clone a Windows PC

David Young — Tue, 02 Feb 2016 02:01:58 +0000

Like so many developers are, I am the IT guy for my family as well as being one “in real life”. Today, I was confronted with an issue that was one of those hardware-related issues that crop up from time to time, and those can be just as difficult (if not more so) than software …

Continue reading "Using Macrium Reflect to Clone a Windows PC"

The post Using Macrium Reflect to Clone a Windows PC appeared first on Deep in the Code.

Using PHP to Search for Text in Website Source Code

David Young — Wed, 13 Jan 2016 20:37:39 +0000

As I’ve mentioned before, I use the Thesis premium theme on my WordPress site, and I generally have no problems at all. However, the newest Thesis update came out, and I am getting an HTML5 validation error. Usually when this sort of thing happens, whether it be with a theme or with a plugin, I’ll …

Continue reading "Using PHP to Search for Text in Website Source Code"

The post Using PHP to Search for Text in Website Source Code appeared first on Deep in the Code.

Which is More Important: Newest Data, or Fastest Load Time?

David Young — Tue, 05 Jan 2016 19:26:32 +0000

Happy New Year! As we developers often do, I have recently looked at some code that had aged a bit – more like vinegar and less like wine – and thought, “Did I write that? What was I thinking?” Constantly becoming aware of and implementing best practices, avoiding bad practices, and recovering from failures are …

Continue reading "Which is More Important: Newest Data, or Fastest Load Time?"

The post Which is More Important: Newest Data, or Fastest Load Time? appeared first on Deep in the Code.

Selecting Specific Data with the JSON Selector Generator

David Young — Thu, 31 Dec 2015 17:55:15 +0000

Last post of the year, I promise! Something I forgot to mention in yesterday’s post: I found a great tool for finding the correct JSON selector! The JSON Selector Generator allows you to put in a JSON string, and it parses it such that you can then select which block or item you wish to …

Continue reading "Selecting Specific Data with the JSON Selector Generator"

The post Selecting Specific Data with the JSON Selector Generator appeared first on Deep in the Code.

Using the Duolingo API with PHP to Get Profile Data

David Young — Wed, 30 Dec 2015 21:20:37 +0000

For those who are interested in learning a new language, Duolingo is a great place to start. It’s free, and some recent studies suggest that it’s more effective than Rosetta Stone (which is not free). I’ve been using Duolingo for the past few months and decided to do something similar with my Duolingo profile as …

Continue reading "Using the Duolingo API with PHP to Get Profile Data"

The post Using the Duolingo API with PHP to Get Profile Data appeared first on Deep in the Code.

Performance and Availability Issues when Using Linux Hosting for WordPress on GoDaddy

David Young — Tue, 15 Dec 2015 20:22:48 +0000

I have used GoDaddy for hosting this blog for several years now, and I can say that I have not always been happy about it. I have used a free service called Monitor.Us to let me know when the website was down, and until recently, it was down quite a lot more than I thought …

Continue reading "Performance and Availability Issues when Using Linux Hosting for WordPress on GoDaddy"

The post Performance and Availability Issues when Using Linux Hosting for WordPress on GoDaddy appeared first on Deep in the Code.

PHP 7.0.0 is Finally Here!

David Young — Thu, 03 Dec 2015 22:44:18 +0000

I’m been waiting for some time for this to be certified as production-ready! It’s like getting an early Christmas present. The Toptal Engineering Blog has an article detailing new and deprecated features in PHP 7.

The post PHP 7.0.0 is Finally Here! appeared first on Deep in the Code.