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

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 Support

What’s the Deal with Oracle 18c? (part 2)

By | Oracle
Last week we introduced Oracle’s database 18c, and focused on the new release structure and its increased accessibility on cloud environments.  If you missed this article, here’s a link to go check it out now before heading back over for part 2.  – What’s the Deal with Oracle 18c (part 1) This week we are focusing on more specific feature enhancements to those areas you have come to expect in an Oracle product.  Starting with security and moving on to platform architecture we are looking at how this newest release helps simplify your data management.  We will discuss key features from Database 12c that get exciting upgrades in this new release. Stability – Several new features increase the platform stability, including Real Application Clusters, Recovery Manager and Flashback.  Oracle takes advantage of the multi-server architecture to deliver enhanced backup and recovery features, and reduced downtime for scheduled activities. Security Enhancements – Oracle has always prioritized security and this newest version builds upon that foundation.  With simplified and optimized security protocols, this database will help you prepare for more stringent security requirements coming up in the General Data Protection Regulation (GDPR).  Here are just a few ways Oracle emphasizes security in (more…)
Security

What’s the Deal with Oracle 18c? (part 1)

By | Oracle
Oracle’s newest release, 18c, is out, and I know what you’re thinking: what happened to 12.2.0.2?  Is it really time for a whole new version?  Well rest assured, this is not really a whole new version. It’s an entirely new method of naming that more accurately reflects what has been going on for years.  The old model of multiple release versions and patch sets wasn’t doing justice to the database.  The multiple release model led many to shy away from adopting any first release database for go-live workloads.  But honestly, for years the patch sets have been full releases in all but name. So now Oracle has decided to change its release schedule, and each annual release will be named after the last two digits of the year.  The plan is to speed the release of smaller changes while avoiding the massive overhauls that used to come with first releases.  What would have been database 12.2.0.2 is now 18c, and 12.2.0.3 will instead be 19. They have also gotten rid of the Patch Set Updates and Proactive Bundle Patches.  Instead we will now get Release Updates (RU) and Release Update Revisions (RUR).  So now that we understand the new release (more…)

Dobler Consulting Celebrates Ten Year Milestone as a Managed Solutions Provider

By | Press Releases
  Remote Database Administration An Idea Whose Time Has Come…   Tampa Bay – February 22nd, 2018: In 2008 Peter Dobler, CEO and Founder of Dobler Consulting had an idea. He saw that database volumes were growing exponentially, that they were increasingly less secure and the talent pool of skilled Database Administrators (DBAs) was shrinking. His entrepreneurial idea was to attract the most talented DBA’s, give them the very best tools, training and processes; then remotely service large corporate databases more scalably and securely as a managed solution. “In 2008 the concept of Remote Database Administration was novel thinking to many, but not all, corporate CIOs,” said Dobler “I am forever grateful to the early adopters who saw that data growth, security and talent could either be an existential threat or a competitive opportunity for their enterprises.” The implications of exponential data growth are alarming, the research firms IDC confirms that from 2013 – 2020 data will grow from 4.4 trillion gigabytes to 44 trillion – a 10X factor. The Bureau of Labor Statistics projects an 11% increase in the need for DBAs. And the Ponemon Institute estimates the average data breach cost US companies $3.5 million in 2017, with a 27% (more…)
sybase recovery services

In-Memory Databases vs Intel NVMe NUMA

By | Blog, Database Technology Trends, SAP HANA, Sybase | No Comments
For the past few years, the hot topic for database vendors was the in-memory database. The general belief was and maybe still is, that server memory is getting cheaper and density will continuously improve. For the most part, this has been the case, maybe not as extreme as predicted. However, the data storage needs for databases increased at a much faster pace during the same time, which created another problem. Going beyond 1TB of memory in a single server will quickly become very expensive. A 1TB database used to be called very large. This attribute is now applied to the 5-10 TB databases servers. In-memory databases are needed where read and write performance are equally important. Traditional databases improve read performance by caching data in memory, but there is no way to improve write performance. To be ACID (Atomic, Consistent, Isolated and Durable) compliant, data must be written to persistent storage. An in-memory database achieves this by writing every transaction in parallel to a high-performance storage. In many cases this is a flash drive on the PCI bus or a SSD drive. But every write action must be stored away from Memory (RAM) to be ACID compliant. There are many (more…)
SQL Server

Planning And Executing A Successful SQL Server Database Migration

By | White Papers | No Comments

By Carlos Colon / DBA Manager at Dobler Consulting

Migrating an existing database to SQL Server can be a taunting task. No matter if your current database is Oracle, Sybase, DB2 or MySQL, the core of the migration tasks are almost always identical. A SQL Server database migration project can be broken down into 6 steps.

1. Analysis
2. Planning
3. Build
4. Migrate, Test, Fix, Repeat
5. Deployment
6. Support

This presentation will walk you through these steps and in addition will also cover these topics:

– Typical SQL Server Migration Plan
– Key Deliverables
– Database Migration Steps
– Brief Overview of SQL Server Migration Assistant Tool (SSMA)
– Common Problems in Database Migrations

Download the Guide For FREE!!

Read More

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 Maintenance

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