integration and implementation of technology-focused business solutions

Oracle’s new autonomous database

July 17th, 2018

With the latest Oracle Database release (version 18c), there’s a cloud-only product available called Oracle Autonomous Database Cloud that allows for a more autonomous data warehouse. It’s not artificial intelligence really, but more of a self-monitoring and self-adjusting system.

Some of the hands-on tasks that a database administrator previously had to work on have now been automated. For example, if part of a database was slowing things down due to a bad disk, the database administrator would need to go in, move the data to another area, and restore the bad disk. Now that’s been automated along with many other tasks in this new system.

As this technology continues to evolve, it will certainly make things easier for database administrators and other IT administrators. There used to be a point in time where you had to intervene to let a database grow. Then they evolved to where they could grow more on their own. But you still had to have someone monitoring it to see when it got close to max storage, because it could only grow as long as you had adequate storage.

With this version being cloud-based, it will be interesting to see if it’s the beginning of cloud-only services for some databases. But regardless, it’s an interesting step to watch as they release a database that’s billed as being self-driving, self-securing, and self-repairing.

But what does that do to the database administrator’s job? No, it’s not going to eliminate the need for a database administrator. Instead, it’s going to allow them to do more with less time. They can focus on planning and strategy rather than spending their time keeping the database up and running. Yes, most database administrators are still going to monitor it and check what it’s doing, but it really will free up a lot of their time to focus on other priorities, and that’s a good thing.

Comments: None

Oracle releases Apex 18c

July 3rd, 2018

At LSG Solutions, we’ve long been proponents of Oracle Apex software. Because of Apex’s low code concept, it allows for developers to produce applications much more quickly and without having to know all the specifics of HTML, CSS, Javascript, and other coding languages.

Apex first appeared as a product in 2004 with HTML-DB, and it’s continued to evolve and improve from that time. Back then, it wasn’t like the normal web apps we’re used to today, but it did allow power users to build their own reports without waiting for a developer.

The latest version is Apex 18c, which we will be introducing to some of our customers because of the new features it offers to them. As with any database release, it’s packed with new features, but some that stand out more than others. You can see a full list of features and release notes on the Oracle website.

One feature we’re excited about is the integration of JET charts into the database. It’s been an independent product in the past. As it offers a much better option for graphs, we’re happy to see it fully integrated.

One thing that’s definitely interesting about this release is that Oracle changed their versioning sequence for this one. Previously, they had used a sequential versioning approach where the biggest number was the most current version.

Now they jumped to 18 to adopt the year of release as part of their versioning strategy. Had they kept their sequential numbering, this version would be 12, so that’s a pretty big difference. Oracle says the new releases will occur on a more regular cycle always designated by the last two digits of the year of release.

This version is available both as installed software and in the cloud, so it provides flexible options for customers who want to implement it in their current setup.

Comments: None

Flexible options for Oracle Database Appliance

June 19th, 2018

We’ve long been a proponent of Oracle hardware and software and have many clients utilizing it. Many years ago, Oracle didn’t have a lot of flexibility in their offerings to meet different client needs and different budgets, but it was still a great option when it fit the need.

In recent years, they’ve significantly expanded their offerings and have adapted to the changing needs of their target market, which is great. One recent example is the new Oracle Database Appliance offerings, which include X7-2S, X7-2M, and X7-2HA. The disk capacity ranges from 16TB to 300TB.

Back when they first released Oracle Database Appliance, they offered 2S, 2M, and a third one that didn’t have a letter. So a lot of tech industry people joked that the third one must be 2L, or large. Well, now the third one has a letter identification, too. The HA stands for high capacity, and it definitely fits!

So which one is right for you? Well, that depends.

The X7-2S can be a good fit for both production environments and development environments. It has less memory than the others, but it still has lots of memory.

The X7-2M has more memory overall, but that’s really its primary advantage. In reviewing the specs, I don’t see anything else about the medium option that offers a competitive advantage above the small except in terms of storage space.

Either of these options make the most sense for a customer who has already invested in Oracle database. The purpose of this hardware is to make data going out and data coming in as efficient as possible. It’s fast, and that matters for many people.

I’ll be honest-I’m a believer in Oracle products. If it were my money, that’s where I’d spend it. But, I also recognize it’s not the right fit for everyone. You need to know how to set it up and support it (or work with someone who can help you do that). But if you have that part covered, it’s a great option for people who need this level of server.

Comments: None

Statewide contract for as-needed IT services

June 5th, 2018

LSG Solutions was recently awarded a statewide contract to provide information technology services for state agencies and affiliates on an as-needed basis.

This contract originated with a request for proposal from the Office of Management and Enterprise Services (OMES). OMES is responsible for key functions at the state level, including central purchasing, central accounting and reporting, employee group insurance, human capital management, budget and policy services, and information services.

While OMES has technology staff assigned to various state agencies through their information services division, they recognize that periodic needs to augment staff can occur, especially with the complexity of state agencies and their affiliates.

With this contract, LSG Solutions will be able to augment the OMES staff as needed for a variety of tasks, including special projects or covering routine responsibilities when other staff members are unavailable.

Within our proposal, we provided proof of our past and current experience in multiple disciplines outlined in the request, including the following:

  • IT Administrative Services
  • Project Management
  • Application Development and Support (includes Systems Analysis)
  • Enterprise Architecture (Business & Technical Architecture)
  • Database Administration
  • Data Warehouse Architecture
  • Technical Grant Writing

It certainly comes as no surprise that multiple information technology service companies responded to this request for proposal from the state for a total of 12 responses. We have a long history of providing quality technology services to the state of Oklahoma, and we are pleased to be awarded this additional contract with the state.

Our services will include both on-premise and cloud environments, primarily for Microsoft and Oracle products, although our services can extend to other technologies as well.

The list of potential organizations we could help through this contract is rather lengthy, as the definition of state agencies and affiliates includes boards, commissions, counties, cities, school districts, hospitals, colleges, universities, and more.

Comments: None

Managed services on cloud-based systems

May 15th, 2018

One question we get from time to time is whether or not our managed services work the same on cloud-based IaaS-Infrastructure as a Service-and as a PaaS-Platform as a Service-set ups as they do on on-site hardware.

The short answer is yes, they do work the same. It doesn’t affect our services or offerings at all.

We’re already remote anyway, so we’re agnostic to the location of the hardware to do everything we need to do in the first place. The hardware is just in a different data center.

We actually set all of our managed services up with that in mind more than a decade ago. Back in the 2000s, we had a client move all their hardware to a data center that had the bandwidth they needed.

At the time, the “cloud” wasn’t a term that was being used. It was known as a hosted solution in a data center. The data center provided all the telecommunications and security their system needed. The cloud has just taken it to another level with virtualization technology.

We were able to provide managed services remotely for that client, and it didn’t matter that their hardware had moved. Ever since, our managed services have been location agnostic.

You might wonder if cloud-based solutions will take care of your database and software as well. They won’t.

Sure, the system administrator piece is offloaded to your cloud provider. That could be Amazon, it could be Microsoft, or it could be Oracle. They’ll take care of your physical hardware, your operating system. But above that in the stack is your responsibility, including your database and software.

Of course, below that in the stack, you still have to hold the cloud provider accountable. If there are any real issues, you still need technical minds conversing with the cloud resource provider to determine what’s going on.

Our managed services still operate just like they would on servers you have on-site. It’s a seamless process for us and doesn’t affect our offerings at all.

Comments: None

The cloud versus hardware solutions

May 1st, 2018

Not long ago we worked with a state government agency here in Oklahoma that was looking at either upgrading their hardware systems or moving to the cloud.

Initially, they were going down the traditional route, which is procuring more hardware. However, they had a forward-thinking IT director that called Oracle to see what the options were for a cloud-based solution.

The system they went with is known both as an IaaS-Infrastructure as a Service-and as a PaaS-Platform as a Service. Because of how seamless and affordable it is, it was a great choice for their needs.

There were three major reasons it was a good fit.

First, when the quote from Oracle came back, the IT director was rather surprised. It was going to be a lot more affordable to move everything to the cloud than it was to procure the new hardware and have their system administrator set everything up.

They even looked at the cost over a number of years, and it still saved them money.

Second, the physical location was important to them. They were actually working on moving some of their hardware off-site to a state-wide data center. So if they had opted to go the traditional route, they would have needed to set all the equipment up on-site initially, then eventually would have moved it to that data center. The cloud-based solution alleviated any risk and concerns with moving the hardware to a new location.

Third, their usage was going to be a public-facing app. It actually has to be exposed over the internet to users, and those users are everywhere physically. It’s not like they’re just on one intranet. So a public cloud solution was perfect for them in that regard as well.

What we found in this case is that this particular technology was a great option for moving to the cloud. It was very Oracle-centric. It used the Oracle Database Standard Edition, as well as Oracle Application Express. Other solutions with third-party technology can be moved to the cloud as well, but this case was very Oracle-oriented.

While there are times that physical hardware makes more sense than a cloud solution, it's true those cases are become more and more rare.

Comments: None

Sex Offender Registry updates for better, quicker data

April 17th, 2018

We continue to work with the Oklahoma Department of Corrections on improvements to their Sex Offender Registry system, which allows law enforcement and the general public better and quicker access to data.

Streamlined review process

We’ve continued system and process improvement efforts designed to require less user input, which means a streamlined review process for any new data on any sex offender in the system.

One of the things the system does is sync up nightly with the national database, SORNA. By streamlining the review process, data is available on a nationwide basis quicker than it was before, and the data is actually better.

Better public communication

For the public, there are a couple changes rolling out. First is the responsive website we’ve talked about before. This means that you’ll be able to access the public facing tool easily from your mobile phone and tablet.

Second is modifications to the email notifications. Since those were a new addition to the system since we started working with ODOC, they’ve now gone through a revision and improvement process. They’ll be a lot easier to read primarily due to some formatting changes.

Better law enforcement communication

Finally, we’re making some changes that should translate to a higher volume and quality of data by communicating better with the law enforcement users of the system.

Up to this point, there’s never been an easy way for the FBI, special investigators, private investigators, and so on to get notifications when they log in or even mass emails. So we’re adding both of those capabilities into the system.

These changes will help the public and law enforcement with better, more up-to-date data that provides more peace of mind in the process.

Comments: None

Employment Security Commission update

April 3rd, 2018

I’ve blogged before about the Oklahoma Employment Security Commission and the work we’re doing with them. We’ve now done quite a bit of work on their Electronic Benefits Payments Control (BPC) system, which has resulted in the ability to catch more overpayment of unemployment benefits.

The problem of overpayment

There are essentially two different cases. There are accidental, inadvertent mistakes, where people keep getting unemployment benefits when they shouldn’t be. But there are also plenty of times where people are abusing the system, often out of desperation.

Some people don’t realize this sort of thing is tracked, and they continue to collect unemployment after going to work for someone else. They don’t realize that their new employer has to report their employment to the OESC, and they end up getting caught eventually. Then the individual has to repay that overpayment to the OESC, either by writing a check or having their wages garnished.

The process of catching people

Before we started helping with the system, it was a more manual, rudimentary process. That means the cases they could catch and amounts they could collect were only as good as the number of people they had working for them.

Now the system is much smarter. It’s an artificial intelligence of sorts where a process will be running all the time to look for those suspicious cases and flagging them.

Then the investigators at the OESC can focus on investigating those cases, rather than finding the cases in the first place.

The individuals that were overpaid then get a bill and start the repayment process.

Federal reimbursement through TOP

Another aspect of the system we’re implementing involved reimbursement from the federal government down to the state level for people that are caught in repayment. That program is the Treasury Offset Program (TOP).

There’s a federal database clearinghouse that will allow OESC and agencies in other states to find out whether people are employed in a different state but still receiving unemployment benefits from them.

Because of these changes, the OESC may be able to bring on more staff, as the system will begin producing more cases for them to investigate. That will result in a larger workload but also additional revenue from increased overpayment reimbursement.

Comments: None

Software development with

March 20th, 2018

We sometimes get asked if we do development, and the answer is yes! We’ve actually been doing development for a long time, in addition to development with other software systems.

Yes, we’re an official Oracle reseller and do a lot of development using those tools, but that’s not all we do. Our goal is to match the needs of our clients with the software system that fits them best.

Most companies have invested in a particular software system or setup, and when they look at options to expand their technology, they want to stay within that same system. Here are a few things to consider related to choosing that system.

Internal skills and comfort level

We partner with companies on software development, but the ongoing upkeep in many cases is the responsibility of the internal team. That means it’s critically important to evaluate the existing skills and comfort level before adding any new software. We’ve worked with many clients who had a high level of comfort with, which means that’s what we used to expand their systems.

What you need to accomplish

Any software development project should start with a discussion of the ultimate goal for what you need the system to accomplish. The end goal can be drastically different from one company to the next and one project to the next. That’s why multiple software development options exist! They all serve different needs in terms of goals and budget.

Over the years, we’ve designed and developed some incredibly robust systems for our clients using It’s a powerful environment, and it can be customized to meet a lot of needs.

Ease of implementation

One of the reasons became popular is its ease of implementation. It doesn’t require a lot of crazy licensing steps, which means Microsoft made it easy for developers to get started. They even offered free scaled-down versions that still had a decent amount of functionality when it first came out. The ease of implementation certainly factors in for a lot of users.

There are some people in the IT world who like to engage in database wars about which platform is better than the others, but we don’t get into that. Our goal is to create the right system to fit our client’s needs, and is one of many options we have to do that.

Comments: None

Building trust with our clients

March 6th, 2018

Trust is important in any partnership. We know that some of our clients have full trust in us from the beginning, whereas we need to constantly earn and keep that trust with others. And that’s okay. It’s part of doing business, and we always strive to earn and keep trust over time with all of our clients.

Here are a few factors that contribute to building trust with clients, especially for IT companies.

Ensure everyone is okay

This may sound like an odd piece of advice, but it’s a concept we use a lot. It’s a way to approach communication with other people that focuses on ensuring everyone feels comfortable in the interaction.

One of the biggest ways to make sure everyone is okay is to avoid jargon. And there’s plenty of jargon in the IT world! In the old days, we would walk into a meeting with a client and speak our IT language. But if they didn’t understand that IT language, we ran the risk of making the client uncomfortable.

Most people don’t want to raise their hand and admit they don’t understand something, which can lead to significant confusion down the road. By making sure we explain things in non-technical terms at every step of the process, we help our clients feel more comfortable with the interactions and with the decisions they need to make.

Put yourself in their shoes

Everyone’s professional background is a little different, even if they hold similar job titles. Some IT directors have a technical programming background but are less comfortable with other aspects of IT, whereas others are experts in network administration but less confident with certain software systems. There's a wide range of prior experience among people in every role, and it’s important to understand where your client is coming from.

Putting yourself in their shoes also involves seeking to understand the bigger picture. What else is going on at the company or in their IT department that might create stress or concern for that IT director (or other point of contact)? Ultimately, you want to make the project and your interactions about them and not about you, so it helps to understand the bigger picture.

Communicate with transparency

I’ll admit there have been times I avoided having difficult conversations. It’s pretty natural for most people to want to avoid conflict, but sometimes you just have to handle it. Companies who work with a strategic IT partner often have large projects that are critical for the company’s success. It’s important for their IT partner to be open and honest when communicating about that project to ensure the best possible outcome.

This also includes clear communication and thoroughly explaining anything the client might not understand. By taking the time to communicate with them, they’re better able to communicate with internal audiences about the value of the project you’re working on.

If you could put a dollar figure on what companies waste due to mistrust and lack of productivity related to mistrust, it would be huge. Trust is critical! You can’t turn on a switch and immediately gain someone’s trust. There are some scenarios where trust can be built quickly, but most of the time it’s a gradual and worthwhile process.

Comments: None


501 E. 15th St., Suite 200B
Edmond, OK 73013