(David Fitzjarrell) Some of the strangest ideas (to me, anyway) can be found in the depths of PL/SQL code, be it a package, a procedure, a function or an anonymous block. Granted, such decisions may be the result of budgetary considerations which prevented a more robust and reliable application desi
Other News
impdp REMAP_DATAFILE Parameter
(Andrew Reid) I was asked to copy one database into another, which I usually do by copying the datafiles then recreating the control file. However, on this occasion, although both databases were on Oracle 11.2.0.4, the machine hosting the input database was X86 whereas the machine hosting the output
PreInstall RPM Makes Oracle Database Installation Easy
(Michael Miller) Last week I had to build an Oracle 11gR2 database in the lab. Usually this process involves selecting one of several VirtualBox VM images for an appropriate Oracle Enterprise Linux (OEL) build and then several hours of effort.
In praise of source code control: Do you use a source code repository for your Dynamics GP customizations?
(Steve Endow) In February 2012, I installed VisualSVN for source code control.
Automate Backups using PowerShell
(Gregor Suttie) This article talks about using PowerShell to automate different kinds of backups, including RavenDB, SQL Server and files backups such as IIS logs.
Accessing $document Properties In AngularJS
(Ben Nadel) This is just a quick little blog post about something silly that tripped me up in AngularJS for a few minutes the other day. I had injected the $document object in my Controller and was attempting to read the cookies; but, it kept showing up as “undefined”.
Jet Brains Releases 0xDBE
A new IDE for writing SQL is being developed by Jet Brains that may take over a lot of the existing tools. It is currently in a restricted Early Access Program of which I have not yet been accepted. I’m simply reporting based on the features they publish on their website. The new tool is called 0xDBE. 0xDBE is built […]
00: SSIS Advanced Techniques Workshop-Preview
Pro-Center Video Programming for IT Professionals
05: SSIS – Leveraging the Execute SQL task in SSIS
Pro-Center Video Programming for IT Professionals
04: SSIS – Replacing dynamic SQL with variables and expressions in SSIS
Pro-Center Video Programming for IT Professionals