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…)
Database strategy and consulting services

Customer Case Study: Administrative Services Company Uses Managed Services to Replace IT Dept

By | Case Studies
Overview Business Situation: Client needed dedicated IT team to manage Microsoft SQL Server database and backups. Solution: Dobler Consulting’s Managed Services contract for ongoing support and consultation. Benefits: Low/No Maintenance, Ongoing Support, Maximize Efficiency, Lower Cost Option. Business Challenge Insurance Administrative Services (IAS) is a local company based out of Clearwater, FL. They provide innovative business solutions for insurance agencies and facilitate business processes for some of the country’s leading agencies. In 2010, the company recognized the daily management of the database and backups was impacting the productivity of their team. The company’s Microsoft SQL Server required management for upgrading, tuning, and scaling that took valuable time away from their core team. They decided that in order to optimize their potential they needed a dedicated IT team. However, to hire an in-house team would have been costly and time consuming. The required staffing, personnel, and HR resources that would be needed encouraged them to seek a different solution. Solution The solution for IAS was a contracted database administrator. This would give them the benefit of expert knowledge and increased resources, without the prohibitive staffing challenges. IAS selected Dobler Consulting to fill this role. Dobler’s managed services product provided ongoing database (more…)
Database strategy and consulting services

Customer Case Study: Leading Healthcare Provider Uses Managed Services to Support Sybase ERM

By | Case Studies
Overview Business Situation: ERM on Sybase needed level 1 support. Client’s current database administrators (DBAs) were taxed and losing productivity. Needed more Sybase experts. Solution: Dobler Consulting’s Managed Services contract for ongoing support and consultation. Benefits: Gained Sybase Expertise, Increased Productivity, Cost Effective. Business Challenge Healthcare is challenging enough without the added pressure of large scale database maintenance. One of the leading healthcare organizations recently learned this lesson. Their business processes are on an EMR application running on Sybase AIX. They realized their DBAs were bogged down with mundane on-call tech support. They were having trouble maintaining knowledgeable staff for these issues. Fewer people these days can claim expertise in Sybase, and the lack of available resources meant that this company needed help. They reached out to SAP and were referred to one of the top Sybase experts, Dobler Consulting. Solution The solution for this company is a Managed Services contract with Dobler Consulting. They are able to utilize Dobler’s team and expert Sybase knowledge to maintain the database on the back end. As a healthcare provider, it is vital that records be accessible at a moment’s notice. That is why it is so crucial to have support that is (more…)
Database strategy and consulting services

Customer Case Study: Custom Software Provider Increases Productivity Through Managed Services Support

By | Case Studies
Overview Business Situation: Routine Maintenance requiring too much time. Pulled focus from client project tasks. Needed less hands-on maintenance. Solution: Migrate from Azure to AWS and use Dobler Consulting for ongoing managed services. Benefits: Performance Improvement, Increased Stability, Lower Maintenance. Business Challenge This client is a premier supplier of premium customer loyalty software. The team spends their time designing and implementing custom software solutions for their clients, but they recently found themselves devoting more and more time to their internal solutions. Their IT infrastructure required frequent attention for routine maintenance and support. This attention took time and focus away from client facing activities and decreased productivity. The team needed a solution to handle the day-to-day maintenance that would free them up for more strategic work. The client had devised a corporate strategy to migrate from Azure to Amazon Web Services (AWS) to minimize maintenance needs. They used this opportunity to add Dobler Consulting for their ongoing support. Solution Dobler began their relationship with the company to support their database migration from Azure to AWS. Dobler’s team managed a successful migration and proved to be a valuable partner throughout the process. During the migration, Dobler managed the company’s IT requirements and (more…)
Database strategy and consulting services

Customer Case Study: Financial Technology Powerhouse Upgrades and Migrates Sybase Database in Record Time

By | Case Studies
Overview Business Situation: Older hardware and software were taxing resources with poor performance and stability. Solution: Migrate from AIX to Linux and upgrade to latest Sybase version (ASE 16). Benefits: Performance Improvement, Increased Stability, Lower Maintenance. Business Challenge The financial services firm was using Sybase on AIX to run mission-critical processes, but performance and stability issues were becoming increasingly problematic. This system took a lot of manpower to maintain. It also lacked the necessary scaling and performance to improve their processing. They decided to upgrade to the newest version, ASE 16 and to migrate to Linux OS. This decision was just the first step. Now they were faced with the issue of time. The client needed to complete the project within just a few months so they could have the system back up and running for year end processing. With a short window in which to complete the project, they needed a partner who could act fast. Dobler Consulting stood out as a Sybase expert who could help steer them toward the smoothest and quickest implementation. Solution Dobler Consulting worked together with the company to plan and implement the IT project in an unprecedented amount of time. Using templates planned from (more…)