Data Migration Support

Containers are In – Azure Can Help

By | Azure, Blog, Uncategorized
Application development and deployment has come a long way in recent years. The introduction of containers opens the door for more lightweight, portable, scalable development. Add to that the capabilities of Kubernetes clusters and you get a new level of efficiency when managing application development, testing, and deployment. If your team is actively using Linux containers and Kubernetes clusters, it’s important to make sure your database products are supporting your efforts. Microsoft Azure has been helping its clients utilize and manage containers with Azure Container Service (ACS), now taking it a step further with the development of Azure Kubernetes Service (AKS). Why Containers? Containers have tons of benefits for API development. They are basically self-contained instances that run natively on your OS, maintaining configuration settings across multiple platforms. Imagine your developers working on an API on their laptop, which has one set of configurations, and then sending to another developer for review. Will the other environment behave exactly the same way? Impossible to know. With virtualization, you can eliminate these issues, but this is taxing on your system. Containers are lightweight so that you can run multiple containers on your machine without experiencing performance issues. Remember, these are running natively, (more…)
Oracle Gold Partner

What’s New in Oracle’s Database 19c

By | Oracle
Oracle is one of the leading providers of database services with decades of experience at the top of the pack. Their new product releases are always exciting to watch, improving upon their legacy of client-focused products and services. Last year they released database 18c, the first of a new annual release schedule, that featured the revolutionary Autonomous Cloud database along with Multitenant Architecture, In-Memory Columnar Architecture, and Native Database Sharding. This year’s database 19c continues to build on the foundations set in previous years with a focus on stability and efficiency. If you are thinking about upgrading or migrating to Oracle’s database 19c, here are a few special features to expect in this newest version. New Features in 19c This database version comes with some exciting enhancements to make your job faster and easier. While the main focus of this development cycle has been on stability, there are a few new features focused on automating and optimizing for the client. Let’s look at a few of these enhancements. Automatic Indexing – Indexing items takes time and can mean a lot of busywork for your IT team. With Automatic Indexing, Oracle’s 19c uses machine learning algorithms to identify items, map and (more…)

How Much Does Custom Software Cost?

By | Custom Software
Whether discussing software or shelving, the word ‘custom’ is generally associated with high price tags, but that it a common misconception in our industry. When asked “how much does a custom software project cost?” our first, and shortest answer is, not as much as you think. Technology has evolved rapidly over the years, and these projects don’t have the same sticker shock that they used to. You may be surprised to hear that custom software can often be the more economical option. Our second answer is a bit longer, and understandably so. Each project is unique and comes with its own set of requirements. But rather than focusing on cost, it may be more beneficial to focus instead on the software’s ROI. That will give you the most comprehensive picture of any software’s feasibility and profitability. It’s About Finding the Right Solution When an organization is interested in custom software, it is because they have a need to fill, and custom solutions are like a square peg in a square hole, they are designed to be perfectly integrated into the workflow. The resulting efficiency means that a well-designed solution should save you money long-term. They also typically increase process automation, (more…)

What You Need to Know to Migrate Your Oracle Database to the Cloud

By | Oracle
Many organizations are making the switch from on-prem to cloud databases. These cloud native warehouses can provide more reliable and timely access, cost-efficiency, and automated backup and recovery. If you are using any on-premises version of Oracle Database, you might want to consider whether moving to the Oracle Database Cloud is right for your company. There are numerous migration methods, and the process can be very simple when you work with an expert. Try reviewing these key factors prior to selecting a migration method and save yourself some additional time. Know Your On-Premises Operating System/Platform and Version – Ensure you have a full understanding of the platform your company is currently working on along with the version. Are you using Windows, Mac OS, or Linux? There are some operating requirements that will be applicable depending on the migration method you are interested in adopting. Know Your On-Premises Database Version & Cloud Database Version – Are you currently using Oracle Database 11g, 12c CDB, or 12c Non-CDB? Depending on your response and the cloud version you are transferring to, Oracle has multiple migration options for you to choose from. For example, a move from on-premises Oracle Database 11g to Oracle Database (more…)

3 Top Analytics Tools To Boost Your Productivity

By | Azure, Database Technology Trends, Oracle, SQL Server
Data analytics have become a major focus for companies determined to be competitive in the market. Leaders need to be able to access and analyze timely data quickly to help drive business decisions that will sustain their companies’ competitive advantage. Thankfully, the growing technology market continues to make this possible. Companies already have numerous analytics tools to choose from, and the options will continue to grow. We will now discuss three of the top analytics tools you should consider before making your next strategic move. 1. Microsoft SQL Server Analysis Services (SSAS) – SSAS is an innovative processing and data mining tool within the Microsoft SQL Server. It analyzes large amounts of data, provides business intelligence reports, and can be used to create business models to support business decisions. All data is stored within a data warehouse, and users can access to create cubes that allow faster analysis. These cubes are multi-dimensional and can be viewed in various ways. Imagine the data as a pivot table that can be modified using certain dimensions and attributes. Multi-dimensional expression (MDX) is the language used to query a cube. Compared to other leading analytics tools, Microsoft SSAS is less complex and much easier (more…)

Simplifying Your Analytics with Azure Databricks

By | Azure
Big data and analytics go hand in hand. If you are handling big data, then you understand the power and the pitfalls this brings. Advanced analytic options, AI and real-time processing are useful tools. But to balance this power you may end up sacrificing productivity and ease of use. Azure Databricks provides a high-performance analytics engine optimized for your Azure cloud database. It’s incredibly easy to deploy, even for large-scale enterprises. Free up your team for the more important stuff. What is Databricks Azure Databricks is a collaboration between Microsoft and Databricks to provide an optimized analytics platform for a large-scale cloud environment. So, what does it do? First, let’s look at Databricks. Basically, Databricks is Apache Spark made more accessible to a large-scale enterprise environment. If you aren’t familiar with Apache Spark, it is the open-source analytics engine developed out of UC Berkeley that has gained significant traction in the past 5 years. It has become a leading platform with widespread use at the enterprise level. It has some drawbacks, though. It is complicated to deploy, and the larger your organization, the more complicated it becomes. Enter Databricks. This managed version automates a lot of the processes, making deployment (more…)

3 Reasons to Consider Oracle EPM Cloud

By | Oracle
As a business leader, it’s up to you to make some big decisions about your data and processes. It can be tricky to figure out which platform is right for your company. There are no clear answers, except to find out what’s right for you. If your current system has room for improvement, you may want to consider Oracle’s EPM Cloud. The comprehensive data solution streamlines your business processes, providing innovation, flexibility and state-of-the-art security. Innovation In a recent survey conducted by Oracle, 81% of finance leaders reported their top-rated benefit of using Oracle’s EPM Cloud was consistent access to innovative technology. With Oracle’s EPM Cloud you are always at the front of new innovations and technology. Most groundbreaking tech is being released on the cloud, and it pays to take advantage of the platform. Cutting-edge analytics, like Machine Learning and AI, can analyze your data and detect patterns that human eyes would never catch. With this advanced analysis you can make more strategic decisions. Always up-to-date technology also means more options for automation. This saves you time and money and reduces the likelihood of errors. This newfound time can be better spent in strategy than in rote tasks. Flexibility (more…)

Expanding the Market: MS SQL Server 2017 and Linux

By | Blog, Database Technology Trends, SQL Server
Microsoft’s exciting cross-platform product, SQL Server 2017, is poised to reach a whole new audience. Recently this industry leader has joined the growing trend of support for open source solutions.  Our team is continually investigating new innovations for our clients, and we wanted to share what we have discovered about new features and performance. Why Now? Linux is becoming increasingly popular thanks to its security, stability, and efficiency.  Its design protects against virus and malware attacks with a complex architecture and secure user account structure.  With more and more businesses choosing Linux, Microsoft realized they were forcing clients to manage multiple environments by keeping SQL Server only on Windows.  Rohan Kumar, then General Manager of Microsoft Database Systems, discussed the decision with Frederic Lardinois for Tech Crunch.  “We had a couple of discussions in the past where it wasn’t approved,” he told Lardinois, but four years ago his team recognized the value of expanding, so they pitched the idea once again. “The biggest surprising part was that we were expecting a whole lot of back and forth. It was really surprising to see how quickly the decisions got made,” recalls Kumar. How? With the company’s support in place, Kumar’s team needed (more…)
Database Maintenance

3 Risks due to Lack of Routine Database Maintenance

By | Blog | No Comments
Relationships with databases are surprisingly similar to those between people. If we don’t regularly dedicate time and resources to maintaining and nurturing them, they may not be there when we need them the most. Since it has become increasingly clear to industry executives, C-suites, and other thought leaders that data is the hottest commodity, protecting yours should be a top concern. There is no reason to risk losing your entire database, which could have catastrophic consequences. Let’s examine a few of the risks of failing to perform regular database maintenance. False Conclusions About Productivity You might have one database or you might have several. In either case, all data is organized in structures sharing one trait: associated indexes that allow data to be located efficiently. Database indexes need constant updates and adjustments. Without regular maintenance, indexes become fractured, making data retrieval cumbersome and time-consuming. From the outside, it could seem that you need to add staff to your team to complete tasks on time while the underlying problem is a system running slowly due to unmaintained indexes. False conclusions about productivity levels can have devastating financial impacts. Security Breaches Database security is simple common sense, but the associated risks with (more…)

SAP ASE Edge Edition

By | Preserved Content Pages | No Comments
This might be the biggest announcement from SAP you never heard of. After dropping the name Sybase from its product names last year, SAP is quietly reshaping its database platform offerings. And I mean this in a good way. Under the Sybase name there were 2 ASE products; Sybase ASE Enterprise Edition (EE) and Sybase ASE Small Business Edition (SBE). The Sybase ASE EE product was and still is the flagship and the most commonly known edition of Sybase. But it came with a hefty price ticket. To offer a Sybase ASE database server to the SMB market space, Sybase created ASE SBE, limited to 2 CPU sockets and 8 engines on a physical server, at a very low price. The server virtualization revolution has dramatically changed the server landscape and database servers made their transitions to the new world. The majority of newly deployed database servers are virtualized, either on premise or in the cloud. The Sybase ASE EE 15.7 database server enabled Sybase clients to make the move to the virtual servers with the introduction of the threaded kernel model. SAP ASE EE 16 continued the optimization for virtual servers and offers one of the most advanced database (more…)