What Can AI Do for You?

By | Blog
Artificial Intelligence and Machine learning algorithms are continually increasing in their sophistication and application. These programs are designed to utilize input to learn and evolve, rewriting themselves and building in their capabilities. When used for a specific task, AI and machine learning programs get better and faster as they go, learning and growing more familiar with the data set, trends, and patterns of their workload. This has exciting applications for businesses looking to speed up processing, analyze big data, and reduce workloads on human resources. From improved automation to customer outreach and security, here are 10 ways AI can help any business. 1. Automation – AI is great at taking over routine tasks and automating time-consuming workloads. From virtual automation, like Robotic Process Automation (RPA) to machining and manufacturing, AI can take over many tasks once relegated to the grunt work pile. Programs and machines run by AI don’t get tired, don’t get bored, and don’t make human errors. This makes them particularly valuable for handling dangerous or hazardous tasks in industry and manufacturing. 2. Forecasting – Knowing how much to produce comes down to accurate forecasting. That is, analyzing sales trends to see how much product you anticipate moving (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…)
Backup Recovery

Improving your Database Security with Microsoft Azure

By | Azure
If you are interested in migrating to a cloud database but concerned about security issues, look no further. Hybrid and cloud native databases do have their own set of security concerns, but if you go with a trusted company and maintain it appropriately, you have nothing to fear. In fact, cloud databases can be more secure since they have access to the most advanced security protocols and automatic updates. Cloud native databases, or DBaaS (Database as a Service) platforms are databases hosted and maintained by third party providers. Operating a DBaaS means that your company will access data through the internet instead of through your internal network. DBaaS solutions offer great benefits for organizations in today’s “Big Data” arena. DBaaS is more scalable and flexible than traditional VM databases. It also eliminates the hardware requirements of maintain a database system. It is crucial to understand and trust the security protocols of your cloud provider before making the switch. Microsoft Azure is at the top of the list when it comes to cloud database offerings. It is a particularly good choice for the security conscious client. Microsoft in general, and particularly Azure, have a long history of prioritizing security for its (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…)
DBA burnout

Avoid DBA Burnout: 5 Steps for Management

By | Blog | No Comments
As the importance of database administrators – DBAs – continue to grow, along with a strong economy that offers an abundance of DBA job openings, many companies are concerned about the threat of DBA turnover. Your DBA is responsible for the performance, integrity, and most importantly, the security of your database every day, including nights, weekends, and holidays. Any down time, and your company can suffer lost revenue, or even worse, a significant data breach. The nature of this work lends itself to burnout because it is a daily, ongoing challenge and seemingly never complete. With these constant stresses, many DBAs often feel overlooked and as though they perform a thankless job. Some fear they’re only noticed when the inevitable hiccups in database systems occur. There is no shortage of job opportunities for talented DBAs, and there are only so many to go around. More and more companies are making it a priority to keep their DBAs happy to avoid burnout and thereby minimizing the chance they will proactively seek out a new opportunity. Following are some practical ways to keep your DBA engaged at your company to reduce the risk of turnover. 5 Steps to Prevent Burning Out Your (more…)

SAP Sybase Replication Server 15.6 | Real Time Loading into SAP Sybase IQ

By | White Papers | No Comments

SAP Sybase has developed a new, innovative and dynamic staging technology, allowing full use of the native, high-speed data load mechanism SAP Sybase IQ offers . . . Real Time Loading (RTL).

RTL addresses the need to have another system prepare the data for load by taking real time data movement from the source database, and applying staging technology to the data transfer in the background.

Up until now, the only option for loading data from an Online Transaction Processing (OLTP) database . . . airline reservation systems, financial transactions, etc., into a SAP Sybase IQ data warehouse was a so-called staging process. Staging means that the OLTP is isolated from the data warehouse loading process to ensure data integrity, due to the rapidly changing data content in the OLTP database systems.

Direct replication into SAP Sybase IQ was limited to low data movement environments. The reason lies in the fundamental differences on how SAP Sybase IQ processes data, and data movement strategies SAP Sybase Replication Server applies.

SAP Sybase IQ is a column vector database. Retrieving a single row requires assembling the row from each column component. This process makes row by row processing ineffective, and the so- called “trickle feed” loading of SAP Sybase IQ nearly impossible. The advantage of a column vector database is in the unmatched speed for complex data retrieval operations and data aggregation on huge data sets.

Download the White Paper for FREE!!

Read 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…)
BI Services and Strategy

Database Migration

By | Blog, Preserved Content Pages | No Comments
Database Migration in the Real World   The Database Migration Process Moving your data from one database to another can seem like a simple task in the beginning, but it can get very complicated very quickly as you dig into the processes and systems. Creating a plan and diligently following that plan is imperative to a successful database migration. At Dobler Consulting, our team of experts starts by evaluating the data structure, systems that contribute to the database, and the systems that pull from the database. After we understand how the systems are currently working, we will assess the growth strategy of the business and data demands that will be made in order to reach that growth strategy. This is a key step in any migration process. If you spend the time and resources necessary to migrate your data to a database that cannot achieve your short and long term goals without unnecessary complication, you will be doing more harm than good. Which Database Should You Migrate To? There are many factors that the end result of a database migration will be successful. What software and architectural solutions are available to maximize the effectiveness of your database? Will your software (more…)