If you want to get a free copy of the Index, Table of Contents and of Chapter 1, have a look here. Click on the READ AN EXCERPT dropdown and then select the one you would like to review. Figure 1 illustrates how that looks like. Figure 1, how to get a free PDF copy […]
Read More →Tags: Oracle
MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203
I am proud to announce the publication of my newest book titled, “Microsoft Certified Associate Data Engineer Study Guide” for the DP-203 exam. The example data used in this book consists of my brainwaves. You can download the data and the source code for all the examples in the book on GitHub here . ADLS, […]
Read More →NHibernate MultiQuery and MultiCriteria unsupported Databases – Oracle and DB2
One of the better capabilities of NHibernate that I have recently found was the ability to group together queries on the client and execute them using only a trip to the database. What I have recently found, is that, as of writing this article and using NHibernate version 3.0 Beta 1, only SQL Server and […]
Read More →Connect to an Oracle database without an Oracle Client
Reducing the number of tasks during deployment of a new system or version update does, at least, 2 things. Fewer number of tasks means it takes less time Fewer number of tasks means less items to troubleshoot if something doesn’t work Removing the installation and configuration of an Oracle Client can now be avoided from […]
Read More →Using ODP.Net with NHibernate and System.Decimal
A few months ago I wrote a question asking for solutions to this error. There were some good answers but none of them provided me with a work around that was database independent. At least something that would work with both Oracle and SQL Server. I was implementing some calculated fields in NHibernate and I […]
Read More →Upgrade from Oracle 10g to Oracle 11g with ODP.net and NHibernate ORA-12514
Firstly, let me say that there is nothing special about this upgrade. The instructions which I wrote here will still work with an 11g database. The issue I had was more with, what is the difference between a SID and a SERVICE_NAME which is used to identify the data instance to connection to. The SID […]
Read More →