CATEGORY: DATABASE TECHNOLOGY TRENDS

Behind the Scenes of Database Evolution

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

Join Dobler at SQL Saturday on June 10th in Fort Lauderdale

By | Blog, Events, SQL Server | No Comments
Join the team from Dobler Consulting on Saturday, June 10th at SQL Saturday #627 in Fort Lauderdale, FL. Dobler Consulting is a Gold Sponsor and will be represented by several of our SQL team. We invite all our SQL colleagues go stop by our booth, ask your SQL questions and say hi. Don’t miss our DBA Manager, Carlos Colon’s presentation Practical Uses for SQL Server 2016 Dynamic Data Masking where will explore how to set up Dynamic Data Masking for use in production support and for generating production-like test data For anyone interested in Data Warehousing, we will also be sharing information about XpressInsight, our data warehouse product, certified on SQL Server 2016. You can learn about the day long event in Fort Lauderdale and register, here. Find a local SQL Saturday Training Event near you. Join Dobler at SQL Saturday on June 10th in Fort Lauderdale was last modified: May 21st, 2017 by Peter DoblerLike this:Like Loading... (more…)

Remote Database Support

By | Blog, Oracle, Preserved Content Pages, SAP HANA, SAP Sybase, SQL Server, Sybase | No Comments
Get Around the Clock Database Support at an Affordable Price. Traditional remote database support services offer services based on your install base, if you need it or not. We offer a new approach of database managed services that goes beyond the databases and covers the entire user experience of any application. Remote DBA Support Plans and Pricing   We Support These Systems SAP Sybase ASE 16 SAP Sybase IQ SAP Sybase Replication Server SAP Sybase PowerDesigner SAP Sybase PowerBuilder SQL Anywhere SAP HANA SAP BusinessObjects Microsoft SQL Server 2016 Microsoft SharePoint Oracle Database 12c Golden Gate Oracle RAC Oracle Enterprise Manager MySQL Times Ten In-Memory Database Discover the Difference Managed Oracle Database Services Can Have on Your Business The basic concept of a remote database support is to lower the cost of database administration. Traditionally, remote database support was offered to large enterprise corporations with entire teams of databases. The goal was to do the same at a lower cost. This is just another form of outsourcing.   The Right Remote Database Support Service Model For You Our remote database support approach is one of the most flexible in the business. It is geared towards small and medium businesses that have a one or more applications (more…)

3 Risks due to Lack of Routine Database Maintenance

By | Blog | No Comments
Relationships with databases are surprisingly similar to those between people. If we don’t regularly dedicate time and resources to maintaining and nurturing them, they may not be there when we need them the most. Since it has become increasingly clear to industry executives, C-suites, and other thought leaders that data is the hottest commodity, protecting yours should be a top concern. There is no reason to risk losing your entire database, which could have catastrophic consequences. Let’s examine a few of the risks of failing to perform regular database maintenance. False Conclusions About Productivity You might have one database or you might have several. In either case, all data is organized in structures sharing one trait: associated indexes that allow data to be located efficiently. Database indexes need constant updates and adjustments. Without regular maintenance, indexes become fractured, making data retrieval cumbersome and time-consuming. From the outside, it could seem that you need to add staff to your team to complete tasks on time while the underlying problem is a system running slowly due to unmaintained indexes. False conclusions about productivity levels can have devastating financial impacts. Security Breaches Database security is simple common sense, but the associated risks with (more…)

Event – Planning and Executing a Successful SQL Server Database Migration

By | Blog, Events | No Comments
Hillsborough SQL User Group Meeting – 4/27/2017 Please join us at a new location for the Hillsborough SQL User Group on Thursday, April 27th.  Dobler Consulting will be hosting our group at the Corporate Center I – Conference room (Suite 122) located at the West Shore entrance to the International mall.   The address is: 2202 North Westshore Boulevard Suite 122 Tampa, FL 33607 Parking is available at the west entrance (airport side).  Please follow the Visitor parking signs past the garage and around the fountain. Featured Presentation: Planning and Executing a Successful SQL Server Database Migration Carlos Colon, DBA Manager Dobler Consulting Migrating an existing database to SQL Server requires much more than just moving the schema and data. They key to a successful database migration effort includes designing the target system, identifying all components from the existing system that will need to be migrated, and allowing adequate time for changes and testing. In this session we will discuss all the different database components and configuration items that will need to be considered during the migration effort, how to utilize the SQL Server Migration Assistant as a planning and implementation tool, what components cannot be migrated (and what can be done (more…)

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

Avoid DBA Burnout: 5 Steps for Management

By | Blog | No Comments
As the importance of database administrators – DBAs – continue to grow, along with a strong economy that offers an abundance of DBA job openings, many companies are concerned about the threat of DBA turnover. Your DBA is responsible for the performance, integrity, and most importantly, the security of your database every day, including nights, weekends, and holidays. Any down time, and your company can suffer lost revenue, or even worse, a significant data breach. The nature of this work lends itself to burnout because it is a daily, ongoing challenge and seemingly never complete. With these constant stresses, many DBAs often feel overlooked and as though they perform a thankless job. Some fear they’re only noticed when the inevitable hiccups in database systems occur. There is no shortage of job opportunities for talented DBAs, and there are only so many to go around. More and more companies are making it a priority to keep their DBAs happy to avoid burnout and thereby minimizing the chance they will proactively seek out a new opportunity. Following are some practical ways to keep your DBA engaged at your company to reduce the risk of turnover. 5 Steps to Prevent Burning Out Your (more…)

HIMSS Conference 2017: Experiences from Launching a New Product

By | Blog | No Comments
Launching a new product at HiMSS among thousands of healthcare providers is an exhilarating experience. The sheer size and scope of the show proves the magnitude of the industry and that there’s an opportunity for innovators and new products to make an impact. At HIMSS 2017, we launched our new customized data warehouse and business intelligence solution, XpressInsight®. Our time at HiMSS was as much as a validity test for the product as it was an opportunity to gather sales leads. You can learn from our experience and successfully launch your product at HiMSS Conference 2018. What is XpressInsight? XpressInsight is a Framework as a Service (FaaS) Data Warehousing and Business Intelligence solution.  This set of software tools and design patterns can be leveraged to solve your reporting problems using data from any source in your organization.  It can be built in a fraction of the time and at a fraction of the cost of more traditional approaches.  It is hosted in the cloud and is certified HIPAA, SSAE16, and PCI compliant.  XpressInsight for Healthcare is specifically designed for Healthcare data. Keys to Successfully Launching a New Product at HiMSS 2017 When launching a new product at such a high-profile (more…)
Healthcare Data Warehousing

A Data Warehouse Solution Should Provide Easy Access to Healthcare Data

By | Blog, What's New | No Comments
The healthcare industry has been facing significant disruption in recent years, due largely to the Affordable Care Act (ACA). ACA has changed the landscape in how medical records are maintained. Many healthcare providers, especially smaller ones, had not previously implemented an electronic medical records system when ACA was first enacted. With the implementation of the ACA, the role of IT in healthcare organizations has changed significantly.  Meeting reporting deadlines has required the IT organization in healthcare to move quickly to provide easy access to data. Now that most providers are using Electronic Medical Records (EMR), the healthcare industry is in a good position for the next wave in healthcare IT. EMR has set the stage to allow healthcare systems to have greater visibility into the business and to identify opportunities for improvement across the spectrum of patient care delivery. This is made possible through a Data Warehouse and Business Intelligence (BI) solution. Compelling Benefits of a Data Warehouse and BI Solution There are many advantages to implementing a data warehouse and BI solution. The ability to slice and dice data from an EMR system opens up discussion on how you can run your healthcare system more efficiently. Let’s walk through (more…)
CIO of the Year Partners

Dobler Consulting Congratulates the Winners of the Tampa Bay Business Journal 2016 CIO of the Year Awards

By | Blog | No Comments
Last week, Dobler Consulting was proud to join the Tampa Bay Business Journal, CDW and Tampa-based IT services company Cologix, in celebrating the exceptional leadership, innovative spirit and technical excellence of nine local IT professionals at the 2016 CIO of the Year Awards. These outstanding individuals were recognized at a formal luncheon hosted at the Straz Center for the Performing Arts in beautiful Downtown Tampa.   Here are the Tampa Bay Business Journal CIO of the Year Winners: Government – Todd Bayley, Pasco County Government Healthcare – Timothy Thompson, BayCare Health System Non-Profit – Chad Lewis, Tampa Preparatory School Private-Large – Scott Cashette, Albertelli Law Private-Medium – Michael Geis, myMatrixx Public – Kimberly Anstett, The Nielsen Co. Emerging Leader – Stephanie Davis, Cox Target Media/Valpak   Additionally, awards were given to companies who deployed IT solutions in innovative ways to deliver exemplary results: Best Big Data & Analytic Project – Catalina Marketing Innovative Technology Project – Triad Retail Media   All of us here at Dobler would like to express our heartfelt congratulations to the winners. Additionally, we’d like to recognize all the award nominees whose technical skill and leadership exemplify the highest standards and qualities one would expect of (more…)

CALL US TODAY!

(813) 322-3240

%d bloggers like this: