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…)
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…)

We’re Excited About SQL Server 2019, Here’s Why

By | Azure
Microsoft SQL Server 2019 is out in preview and it’s got some exciting new features. When Microsoft announced the release at their Ignite 2018 conference on Sept 24th, we couldn’t wait to see what was in store. This newest offering will continue to build on the solid foundation of SQL servers while expanding offerings of flexibility and further embracing big data by adding support for Kubernetes, Apache Spark, and Hadoop clusters. Embraces Big Data – Probably the biggest change to SQL 2019 is the ability to manage big data clusters. Big data has always been a bit of a gap in the arsenal of Microsoft’s SQL servers, but not anymore. With SQL 2019, Microsoft is fully embracing big data with Kubernetes. Kubernetes is an open-source container-based platform that represents exciting new possibilities for this SQL engine. With SQL on Kubernetes you will be able to can create high availability solutions with Linux containers and manage multiple data sources all in one place. Manage Relational and Non-Relational Data – The new engine can query data from a number of different sources, including relational and non-relational data storage. Microsoft has built in native support of Apache Spark and Hadoop Distributed File System (more…)

Reducing Application Errors with Application Continuity

By | Database Technology Trends
The database and application work hand in hand. When a client interacts with features on your website the application calls back to the database, and the database responds by giving it the right information or action. It’s a well-orchestrated conversation. When something happens that stops the conversation the application doesn’t get what it needs and the customer receives an error. This is where application continuity comes in. The idea is to enable maximum continuous communication between the application and your database instances even if there is an outage. This is a massive step in maintaining data integrity and improving the end user experience. The first step in understanding continuity is virtualization. This means that your database layers are virtualized in the stack and your infrastructure can create multiple nodes and instances for your workload, shuffling transaction and processing usage as needed. It is useful for scaling up and down easily and allows more redundancy to protect in case of outages. When one node goes down, whether for scheduled maintenance or unexpected failure, the other nodes are there to take its place and your customer is never the wiser. There are some software products that can help you design this virtualization (more…)

5 Tips for Managing Multiple Cloud Providers

By | Azure, Database Technology Trends, Oracle, SAP HANA, SQL Server, Sybase
Cloud adoption continues to rise and shows no signs of stopping anytime soon. As companies become more comfortable with the cloud platform as a tool, they are moving farther from on-prem setups. The newest trend shows many groups now using multi-cloud solutions. RightScale 201 State of the Cloud Report found that 81% of respondents have a multi-cloud environment. The organizational average was just under 5 clouds, including production and test environments. Why Multi-Cloud? – Each cloud provider has different strengths and weaknesses to offer. Using multiple clouds lets you take advantage of the best tools and applications for your workloads without limiting your resources. It can also be strategic as companies can shift workloads to their various platforms depending on current prices and availability parameters. Adopting a multi-cloud environment can help take your workload management to the next level, but it can also come with some challenges to prepare for. Here are 5 tips to help you manage multiple cloud providers. Choose Wisely – Don’t be suckered in by low rates and storage fees. Those numbers can (and will) change. The more important factor is to select the clouds that have key features you need. Look at the applications and (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…)
sybase recovery services

In-Memory Databases vs Intel NVMe NUMA

By | Blog, Database Technology Trends, SAP HANA, Sybase | No Comments
For the past few years, the hot topic for database vendors was the in-memory database. The general belief was and maybe still is, that server memory is getting cheaper and density will continuously improve. For the most part, this has been the case, maybe not as extreme as predicted. However, the data storage needs for databases increased at a much faster pace during the same time, which created another problem. Going beyond 1TB of memory in a single server will quickly become very expensive. A 1TB database used to be called very large. This attribute is now applied to the 5-10 TB databases servers. In-memory databases are needed where read and write performance are equally important. Traditional databases improve read performance by caching data in memory, but there is no way to improve write performance. To be ACID (Atomic, Consistent, Isolated and Durable) compliant, data must be written to persistent storage. An in-memory database achieves this by writing every transaction in parallel to a high-performance storage. In many cases this is a flash drive on the PCI bus or a SSD drive. But every write action must be stored away from Memory (RAM) to be ACID compliant. There are many (more…)

SAP IQ Edge Edition

By | Preserved Content Pages | No Comments
SAP IQ 16 (Sybase IQ), Edge Edition, packs a set of powerful data warehousing functionality into one cost-effective solution. All the features in SAP IQ can be found in this new midmarket edition. An innovative, column-oriented design and open, flexible analytics architecture makes SAP IQ the choice of companies of all sizes – especially those keen on taking advantage of their data. Optimized to perform on less hardware, the Edge edition is a clear choice for midsize companies. View a replay of the webinar here   Objectives Uncover deep insights about business issues for today and tomorrow Extend the power of analytics with a proven data warehousing solution Scale and adopt to your growing business needs Deploy and manage with ease Solution Grid-based, column-oriented analytics platform In-database analytics with built-in numerical and analytical functions Plug-in to the SAP InfiniteInsight® solution and other predictive software Architecture optimized for queries and workloads in SAP BusinessObjects™ business intelligence solutions Benefits Rapid information access to transform your business Unified sources of diverse data for rich insights Efficient administration and optimized hardware for low total cost of ownership Improved control and security for private, secure data Vibrant community of knowledge enriching SAP IQ deployment and maintenance (more…)

Database Strategy

By | Blog, Preserved Content Pages | No Comments
Elevate Your Business With The Right Database Strategy   An Effective Database Strategy for Your Business Your business’s database strategy must be developed with consideration for the varying database technologies that are available on the market and how they can be used to support the data used by your business. We start with a full evaluation of the data needs of your business, and then evaluate existing systems to determine their ability to fulfill those needs. We evaluate the following when creating an effective strategy: Required business intelligence needs Data types Existing Enterprise Technology Stack Relation with vendors Alignment of Enterprise Data Requirements to Vendor Software Database Performance requirements in relation to the Size and structure of existing databases How the data needs of the company will grow over the next 5 years With these insights, our team can go to work developing a database strategy that will support the needs of your business throughout its future growth. Whether we need to adjust your existing system or migrate to a new system, our team will ensure that your systems will be there to support your business through the growing demands of your ever-changing business needs. Database Strategy With Dobler Consulting (more…)