Simplify Data Management with Azure Data Studio

By | Azure
Azure is well known as one of the industry’s leading cloud providers, offering exceptional security, business management, and analysis tools in affordable packages. In this article we take a look at one of the best tools for editors and DBAs, the Azure Data Studio. This resource, formerly known as SQL Operations Studio, is a platform for building and editing your SQL queries with useful tools and an intuitive UI. If you are looking for a tool to seamlessly integrate your query editing with your database management, look no further than Azure Data Studio. This cross-platform tool makes managing your database, objects, and queries easier than ever. Initial Release and Rebrand – This product was released for public preview nearly 2 years under the name of SQL Operations Studio, and last fall was released for general availability (GA) under the new name, Azure Data Studio. Some customers questioned whether the Azure heading would pose problems for on-prem SQL infrastructures. The answer is no. Microsoft is dedicated to supporting all instances of SQL Server and related database products, including on-premises and hybrid infrastructures. This means that whether you are hosting on site SQL Servers or utilizing the Azure Cloud infrastructure, you can (more…)

Migrating from SQL Server to Azure

By | Azure, Database Technology Trends, SQL Server
Extended support for SQL Server 2008 has ended, and there is no better time to consider a migration to Azure. Continuing to run business applications and workloads on an unsupported platform will open you up to unnecessary vulnerabilities and potential legal issues. The risk is just not worth it. If you have been holding out for fear of complicated processes, there’s good news, Microsoft is making it easier than ever to migrate to Azure and take advantage of the benefits of cloud computing, including scalable resources and always up-to-date security features. With a trusted database solutions partner, your migration can be quick and painless. Check out this guide for more information about migrating from SQL to Azure. Why Migrate – If you are on SQL Server 2008, the answer is clear. Migrating is a must to stay on top of your database health and security. Now you may be asking, why can’t I just upgrade to Server 2019? You absolutely can. But this time is a perfect opportunity to minimize the impact of a cloud migration to reap the benefits of hosting your workloads in a cloud or hybrid environment. Utilizing the Azure cloud allows for scalable database solutions and (more…)

Why OCI is the Perfect Platform for Oracle EBS

By | Blog, Oracle
Oracle E-Business Suite (EBS) is a fantastic compilation of tools for consolidating your enterprise functionality, management, and analytics. But what platform should you use to make the most out of your Oracle EBS? On-prem or third-party cloud infrastructure may not be making the most out of your Oracle applications. With Oracle Cloud Infrastructure (OCI) you will enjoy the fastest, most efficient, most optimized platform to get the maximum benefit from Oracle EBS. What is Oracle EBS? This suite of applications handles everything you need to run your enterprise level business functionality, including customer relationship management (CRM), human resources management (HRM), enterprise resource planning (ERP), and supply-chain management (SCM). The EBS collection is one of Oracle’s major product offerings with robust capabilities to consolidate your business management under one roof. With tools covering logistics, financials, order management, marketing, HR, and many more, Oracle EBS is an industry leading, comprehensive solution. Is On-Prem a Problem? If you are a current or future owner of Oracle EBS you may be wondering what infrastructure will best compliment this powerhouse of tools. More and more companies are moving away from in-house data centers because of the high cost of implementation and maintenance. These data centers (more…)

What’s New in Management Studio Version 17.6

By | SQL Server
Microsoft continues to make great strides in improving SQL Server Management Studio (SSMS). Version 17.6 comes with some impressive new features and bug fixes that enhance your user experience. Azure SQL Database Managed Instance Users If you’re using the newly developed Azure SQL Database Managed Instance, a new model of Azure SQL Database, you should definitely consider upgrading to SSMS v 17.6. One of the most notable changes is the added support for some of its most common management scenarios. After you complete the upgrade, you can expect a much more efficient support process if you encounter issues with the following: Databases – Creating, altering, backing up, and restoring databases are all fairly common tasks in database management, which makes their processes easy to support. Object Explorer – All technical issues that arise while using Object Explorer to manage objects in each SQL Server instance are eligible for support. SQL Linked Servers – You can relax when using Linked Servers to connect to other database instances on a remote server, same server, or an entirely different machine. The SQL Tools Team has you covered. SQL Agent Jobs – Your automated execution jobs/tasks usually consist of several steps. Any disruption can (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…)

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

5 Ways MS SQL Server Enhances Data Integrity

By | SQL Server
We’ve entered a time in which high quality data is at the heart of operating a successful organization. For many companies these days data IS the business. For others, data is a driver. In both scenarios its critical to maximize your data’s efficacy, and this means being sure you can trust that data. I’m talking about data integrity. It’s essential to be able to trust your data, and that means using a database you can trust that is actively working toward ensuring your data.  Microsoft SQL is a longstanding leader in the game. Their database offers top of the line stability and data integrity. If you are concerned about ensuring your data integrity this database might just be right for you. Why Microsoft SQL Server? – Microsoft SQL Server 2019 features upgrades that will give your organization greater access to large amounts of valuable data quickly. Once it’s released, querying multiple sources of data, both structured and unstructured, will be simpler and more secure than ever. MS SQL preview CTP 2.0 is now available in preparation for the upcoming official release. If you’re interested in experiencing some of the new features beforehand, consider downloading it soon. In the meantime, here (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…)