Integrating Oracle Cloud Mobile Apps into Your Workload

By | Oracle
As the digital world continues to expand, the demand for mobility solutions is increasing. The good news is that the prevalence of cloud migrations is making the transition much smoother. Oracle recommends you move any on-premise Oracle application to the cloud. As a leader, knowing your enterprise’s data and applications are accessible regardless of your physical location can do wonders for your peace of mind. Consider Oracle Mobile Hub If you are interested in enterprise mobility for your organization, consider the Oracle Mobile Hub. It provides a comprehensive platform that simplifies application development for your developers and business owners. It focuses on extending your back-end systems so you can take advantage of applications you already use in a secure mobile environment. You also have the option of using your own developers to build and deploy new apps that will integrate seamlessly onto the platform. What Other Capabilities Does Oracle Offer to Enhance Enterprise Mobile Strategies? Using Oracle’s mobile development framework, you can create a single application that will run on multiple devices, phones and tablets, and operating systems. Android and iOS are both compatible. Oracle’s service bus manages interactions between services and applications throughout the network. This includes both newly (more…)

How to Make Power BI Work for You

By | Database Technology Trends, SQL Server
If you’re searching for software that will enhance your analytics process while making it simpler and more flexible, Power BI is worth looking at. It provides tools that the non-technical users on your team can use to perform analytics with minimal help from the IT team. You can create intuitive models, data visualizations, and dashboards and share them with whoever you want. What is Power BI? –Power BI is a cloud-based analytics software service consisting of a combination of tools (i.e., visualization, self-service data analysis, etc.) that allows users to connect to multiple data sources—no matter where the data resides— and create customized, coherent insights. It’s not exactly new since many of its components were in the market prior to its 2015 release. For instance, Microsoft released Power Pivot as an Excel add-on in 2010. This tool alone is a game changer as it gives analysts the tools to import large volumes of data, create relationships between the data, and perform powerful analysis using PivotTables and Pivot Charts. Using Power BI, you can further manipulate these datasets to perform more complex analyses. Utilize All Components of Power BI – Power BI consists of many components. Users find some more useful (more…)

Make the Most of Microsoft SQL Server with Management Studio

By | SQL Server
Microsoft SQL Servers are an industry leading choice for your workloads, but if you are not using Management Studio you may be making things harder for yourself. The additional service is designed to integrate with your SQL database engine and improve object management, database queries, and other management functionality. What is Management Studio? – SQL Server Management Studio (SSMS) was originally released with SQL 2005 and helps users access and manage their SQL instances. It is an integrated management interface that allows you to access your SQL Server, manage objects, write scripts and perform queries with a number of tools and features. It combines tools from Enterprise Manger, Query Analyzer, and Analysis Manager to get this job done. SSMS is easy to use with an intuitive User Interface (UI) and familiar design built on Visual Studio and will help improve your team’s management of SQL Server objects and elements Object Explorer – The interface is intuitive and makes accessing and managing your databases simple and efficient. The Object Explorer is a hierarchical navigation tree that allows you to locate and act upon objects in your environment. These objects can be databases, tables, etc. You can click through the tree to (more…)

What is Azure Stack and Why Do You Need It?

By | Azure
Whether you are using Azure or not, I am sure you are familiar with the term. The Azure Cloud is the fastest growing cloud computing service out there and is quickly edging out AWS for the market. It is a powerful and expansive service that fully supports hybrid infrastructures for robust data management. You may not know quite as much about Azure Stack, so we wanted to shed some light on this Azure extension. What is Azure Stack? – This service is an addition to your Azure Cloud network that enables offline operations on your edge computing machines. It allows your on-site users to manage data, perform analyses, and even design queries using little bandwidth. Actions can be performed in an offline environment and then reserved for specific connection windows and deployed to the cloud. Let’s Talk About Edge Computing – Your network is a complicated series of user APIs and core network processing capabilities. Think of this overall structure as a web of interconnected strings leading back to the central data hub. Edge computing refers to the processes that take place farther away from your centralized network, literally at the edge of your web. We will discuss this in (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…)

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

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

Microsoft SQL Server and SharePoint Consulting Services

By | Company News, General Announcements, What's New | No Comments

For several years, Dobler Consoling is serving the Tampa Bay area with its MS SQL Server consulting and support services. As a full spectrum database services company, we are proud to announce our expansion into the Microsoft Data Platform competency. With just one certification shy of achieving Microsoft Silver Partner status, Dobler Consulting is continuing its commitment to the Microsoft data platform. Read More