Regular Sized Data

There are many guides and opinions how to most efficiently move large amounts of data between database instances. However, what I’ve had to do recently is just move a few rows of data between databases instances, and of course, I wanted to do this as efficiently as possible. Here’s a nice way to do this using SQL Developer. [Read More]

One way to actually remember how to do something (so you don’t have to always google it) is to explain how to do it. I’m going to do a quick post on the most straightforward way to update a column from another table in Oracle. This is an intuitive task in SQL Server. You would just write something like [Read More]

“Big Data” is one of those tech buzz phrases that is so ubiquitous that it has become passé. But as big data became commonplace, a new term emerged that I’ve never quite felt like I grasped: “data lake.” I know it has something to do with storing data for (potential) analysis, and it also has something to do with big data. The goal of this post is to pin down exactly what this term means. [Read More]

The other day I was querying an Oracle database from SQL Server via the Linked Server feature. One of my queries kept throwing errors, and I tried to troubleshoot/rewrite it with no luck. Eventually I got an error message like this: [Read More]

In everyone’s SQL career there comes a time when you run a query and you get a bizarro result set. After some investigation, you discover that it’s because of how you are using NULL in your where clause. NULLs still surprise me. I’m going to briefly touch on a bit of philosophy of what a NULL is and then give one example of where it can behave strangely in SQL. [Read More]

I noted a few posts ago that the OES released their wage data for 2017. Since I have already detailed the queries I used to analyze this data in previous posts, I thought I would just do a quick post listing some interesting tidbits. [Read More]

Recently I was working on a SQL Server database, and I needed to create a linked server to an Oracle database. The goal was to implement a process of moving data from the SQL Server to Oracle and then do some minor data manipulation on the Oracle database. One constraint was that I needed to push the data from SQL Server to Oracle rather than pulling from Oracle. So I installed the Oracle ODBC driver and got to work. Here are a couple lessons I learned. [Read More]