Welcome to Code-Gorilla! I write online content on whatever technologies I happen to be working with at the time.
My current focus is on mobile and web development but you could find a little bit of everything here.Enjoy the content and Happy Coding! |
MS DOS Snippets
Tuesday, December 15, 2020
MS DOS Code Snippets that I commonly looking for.
This is a simple list of MS DOS statements that I am using quite a bit and I'm always looking for examples when switching between all of the different scripting languages.
Echo off
Get ...
Tuesday, December 15, 2020
MS DOS Code Snippets that I commonly looking for.
This is a simple list of MS DOS statements that I am using quite a bit and I'm always looking for examples when switching between all of the different scripting languages.
Echo off
@echo off
Get ...
PowerShell Code Snippets
Tuesday, December 15, 2020
PowerShell Code Snippets that I commonly looking for.
This is a simple list of PowerShell statements that I am using quite a bit and I'm always looking for examples when switching between all of the different scripting languages.
Download PowerShell:
Tuesday, December 15, 2020
PowerShell Code Snippets that I commonly looking for.
This is a simple list of PowerShell statements that I am using quite a bit and I'm always looking for examples when switching between all of the different scripting languages.
Download PowerShell:
What Is ETL, and Why Should I Care?
Monday, October 15, 2018
Extract, Transform, and Load (ETL) is not a specific tool. It’s a philosophy that’s rapidly evolving. Explore your options and learn why you should be aware of it.
You may have read my MC Press Online articles about Microsoft SQL Server Integration Services (SSIS). I’d like to broaden the topic to discuss Extract, Transform, and Load in a philosophical sense to give you a better understanding of how you could use ...
Monday, October 15, 2018
Extract, Transform, and Load (ETL) is not a specific tool. It’s a philosophy that’s rapidly evolving. Explore your options and learn why you should be aware of it.
You may have read my MC Press Online articles about Microsoft SQL Server Integration Services (SSIS). I’d like to broaden the topic to discuss Extract, Transform, and Load in a philosophical sense to give you a better understanding of how you could use ...
Make your Website Google Friendly for Free Thanks to letsencrypt.org
Sunday, September 16, 2018
Using Windows Acme Simple (WACS) to apply a free SSL certificate to your websites running on Windows
Google has specified that websites are not secure unless they are utilizing an SSL certificate. With recent updates to Chrome, warnings are displayed indicating that your website is not secure if the user attempts to use any text inputs on a website ...
Sunday, September 16, 2018
Using Windows Acme Simple (WACS) to apply a free SSL certificate to your websites running on Windows
Google has specified that websites are not secure unless they are utilizing an SSL certificate. With recent updates to Chrome, warnings are displayed indicating that your website is not secure if the user attempts to use any text inputs on a website ...
Install DB2 Version 11.1 Community Edition on Windows
Monday, August 6, 2018
DB2 Database Preparation for Use with SSIS
When writing my book Extract, Transform and Load with SQL Server Integration Services I was using my past experience which was to use DB2 on the IBM i so I did not include include installation instructions for ...
Monday, August 6, 2018
DB2 Database Preparation for Use with SSIS
When writing my book Extract, Transform and Load with SQL Server Integration Services I was using my past experience which was to use DB2 on the IBM i so I did not include include installation instructions for ...
Book Review by Steven Cole: Extract, Transform, and Load with SSIS
Wednesday, June 20, 2018
Do your business apps access different data sources? This book shows you how to make that task easier
As a developer, I have often worked with business applications that pull in data from various sources, such as files or databases, and send that data to multiple destinations. This sounds simple enough, but clients and/or applications typically do not ...
Wednesday, June 20, 2018
Do your business apps access different data sources? This book shows you how to make that task easier
As a developer, I have often worked with business applications that pull in data from various sources, such as files or databases, and send that data to multiple destinations. This sounds simple enough, but clients and/or applications typically do not ...
TechTip: Data Warehouse Updates from IBM i Using SSIS
Thursday, May 26, 2016
Point-and-click your way to repeatable data updates to or from any database from your DB2 database.
In this article, we will select the data from a simple database table to retrieve all active users in a DB2 database and insert the data into a target Microsoft SQL database server using SSIS. Of course, this process can be run daily as a scheduled task.
Thursday, May 26, 2016
Point-and-click your way to repeatable data updates to or from any database from your DB2 database.
In this article, we will select the data from a simple database table to retrieve all active users in a DB2 database and insert the data into a target Microsoft SQL database server using SSIS. Of course, this process can be run daily as a scheduled task.
Easily Create Excel Spreadsheets from Your IBM i Using SSIS
Tuesday, November 10, 2015
Point-and-click your way to building a repeatable, dynamic Excel spreadsheet from DB2.
Using SSIS, you simply point-and-click to set up your flow and configurations without writing any code except the SQL that gets the data. Using this technique, you could easily have your Microsoft gurus accessing your DB2 data with minimal programming ...
Tuesday, November 10, 2015
Point-and-click your way to building a repeatable, dynamic Excel spreadsheet from DB2.
Using SSIS, you simply point-and-click to set up your flow and configurations without writing any code except the SQL that gets the data. Using this technique, you could easily have your Microsoft gurus accessing your DB2 data with minimal programming ...
Simplify Common Database Operations, Including ETL, with a Few Point-and-Clicks
Wednesday, August 13, 2014
Do you know about Microsoft SQL Server Integration Services (SSIS)? No? Let me introduce you.
Prior to doing development with Microsoft technologies, I was unaware that SQL Server Integration Services (SSIS) existed. I was familiar with migrations and Extract, Transform, and Load (ETL), and I wrote many applications to perform these operations. ...
Wednesday, August 13, 2014
Do you know about Microsoft SQL Server Integration Services (SSIS)? No? Let me introduce you.
Prior to doing development with Microsoft technologies, I was unaware that SQL Server Integration Services (SSIS) existed. I was familiar with migrations and Extract, Transform, and Load (ETL), and I wrote many applications to perform these operations. ...
Book Review by Joe Pluta: Advanced Integrated RPG
Thursday, January 30, 2014
Isnt it about time somebody told us how to integrate RPG and Java?
Tom Snyder's first foray into RPG programming books, Advanced Integrated RPG, is an auspicious beginning. The book is ostensibly about three specific examples of integration between RPG and Java: accessing Excel spreadsheets, creating PDF documents, and ...
Thursday, January 30, 2014
Isnt it about time somebody told us how to integrate RPG and Java?
Tom Snyder's first foray into RPG programming books, Advanced Integrated RPG, is an auspicious beginning. The book is ostensibly about three specific examples of integration between RPG and Java: accessing Excel spreadsheets, creating PDF documents, and ...