Protecting Your Database from Ransomware like WannaCry

By | Blog | No Comments
You may have heard about the recent WannaCry cyberattack that infected hundreds of thousands of computers worldwide. The ransomware holds a computer hostage until the user pays some amount of money (ransom) to the hacker or until a patch is made and installed. Why did it spread so quickly and how can you prepare for the next one, especially if you are a DBA? It’s not a matter of if, it’s a matter of when. Why were the attacks so effective? When this particular ransomware emerged on May 12th 2017, it had used an exploit on Windows systems that had been addressed by a critical patch two months earlier in March 2017. So, if end users kept up to date with receiving the latest critical security patches as they became available, they would have avoided being infected. Unfortunately, many businesses were not adequately prepared for an attack like this because maintain updates and they did not have the right security processes in place. It’s critical that companies are proactive in the measures they take to mitigate the risks involved with today’s cyber threats or they will become vulnerable. Lack of preparedness is one of the biggest factors why this cyber (more…)
Database Staffing

How to Hire the Right DBA, Remote or Onsite

By | Blog | No Comments
In this post, let’s take a closer look at how to hire the best database administrator for your company. Establish and Share Your Expectations For the benefit of your company and your potential candidates, clearly define the DBA’s role and your expectations in a thoughtful, detailed job description. Provide a thorough, specific list of daily and periodic tasks the DBA will perform. Clarify whether the DBA will be providing production support, development support, or support for a hybrid of the two, wherein several third party applications are involved. Production vs. Non-Production DBAs The prime objective of a production database administrator is to keep your system running with as little disruption as possible. A DBA in this scenario, would rather keep today’s business processes running before taking radical actions to resolve an issue, this is a case by case decision and needs careful consideration. A non-production DBA is more likely to approach things differently, using trial and error and being more cavalier about when to perform system reboots, checks and maintenance. DBAs should instinctively seek to isolate the problem, minimize its impact on workflow, and keep the production system running. A key trait to actively seek in a DBA is the (more…)

Three Major Trends in Business Data

By | Database Technology Trends | No Comments
I see three big changes occurring in the new world of business data. Big Data. Data sets that are too large and too complex for traditional data processing are now common, and they are becoming ubiquitous. According to Wikipedia, “As of 2012, every day 2.5 exabytes of data are created.” (An exabyte is 2.5 times 10 to the 18th power.) Personal devices, from smart phones to activity monitors, generate data on nearly all of us — our location, patterns of communication, and behavior. All of this is recorded somewhere; all of it can be processed to yield information that presents business opportunities. While data sets are getting larger, the term “big data” has come to refer not so much to the size of the data sets as their predictive power. A good analytics team can spot correlations in data that unearth business trends, prevent disease, or fight crime. What’s required isn’t processing power (although that helps), but imagination and communication. The hallmark of big data is the way it crosses departmental and disciplinary boundaries. Unstructured Data. Once upon a time you could only gather data if you created a model of your expected inputs beforehand. Such modeled data can be (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…)

Database Managed Services

By | Blog, Preserved Content Pages | No Comments
Your database is the virtual extension of your organization. Maintaining it as a flexible and uninterrupted flow of data is absolutely critical in keeping your business operating smoothly and efficiently – to put it simply, data flow interruptions simply cannot be tolerated. Organizations today demand the highest levels of data security and information available to support their data, but do not have the time or skill level to properly service their database. With Database Managed Services from Dobler Consulting, our clients have the time to focus on their core business while we keep their database running at peak performance and resilience. Benefits of Database Managed Services With over 200 years of combined experience in database management and support, the Dobler Consulting team taps into a broad range of database experience to fully service our clients. We diligently work to save you time and money on database managed services, critical support, and vital maintenance. We are prepared to quickly and proactively respond to unexpected events at all hours of the day, as our monitoring methods alter support personnel to proactively manage system alerts before they become larger issues. Our Core Database Managed Services include: Database Administration Database Monitoring and Troubleshooting Data (more…)

Data Mining

By | Blog, Preserved Content Pages | No Comments
The Data Mining Challenge The process of analyzing data from different perspectives and consolidating it into useful information for many different users can be a daunting task to undertake. The complexities that come along with bridging the gap between what business departments want and the data that is available can make it seem impossible. As most don’t understand the limitations involved in gathering and analyzing meaningful data, sometimes it can take an outside perspective to bridge this gap. With technology, there are always ways to get things done and, more often than not, multiple ways to accomplish your goals. With decades of experience working with companies of all sizes, growth cycles, and available technologies, we at Dobler Consulting can comfortable say that we know the most efficient and effective ways to mine your data. The Data Mining Process Data mining is an art and a science. Our team of experts will work with you to analyze your data in a meaningful way. We start by analyzing the patterns, associations, and sources of data. In studying the patterns and relationships within your data, our team can provide the reporting needed to help product managers evaluate price, competition, and the positioning of (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…)

Database Emergency Center

By | Blog, Preserved Content Pages | No Comments
Your primary production database has just crashed and you are losing business by the minute! Have you calculated the cost? It could be staggering! A non-functioning database could cause your business to come to a screeching halt. Poor performance, corrupt databases, and broken SQL Server processes are just a few of the potentially detrimental challenges that could unexpectedly arise in your database environment. These issues could have a major effect on the performance of your system and on your business as a whole – this is why the deployment of a rapid response team is so critical in these situations. Now, What Do You Do? The first thing to do is call Dobler Consulting Services at (813) 322-3240. We have experts ready to take your call and help you with your database problems. If you have a current service agreement in place with us, your call will take priority and be routed to an expert standing by ready to assist you. You don’t have an emergency support program in place? It’s not a problem! Without an emergency program in place, it may take some time and will likely cost you more, but we are available to help. What Is Your (more…)

Database Help Center

By | Blog, Preserved Content Pages | No Comments
There are no stupid questions when it comes to your database. Contact the experts at Dobler Consulting for answers to quick questions, in-depth insights, and any other issues at our Database Help Center. Dobler Consulting is a leader in SAP Sybase, SQL and Oracle Server database support services, and an SAP VAR Partner. Our database experts have over 200 years of combined experience in providing database consulting, database managed services, and licenses and maintenance for companies ranging from Small and Midsize Business to Fortune 500 companies. Fill out the form below with your inquiry or feel free to contact us by phone at 1-813-322-3240 or email atinfo@doblerllc.com! Our experts are waiting to assist you! (more…)