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

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

2018 Trends for Database and Data Management – Six Months Later (Trend 1)

By | Database Technology Trends
Enterprise database platforms are expected to expand beyond traditional relational database models to include non-relational alternative models   Read about Trend 2 Six months in, it seems quaint now to say that the world of non-relational data has exploded. Customers now expect general purpose database platforms will support a whole new level of workloads and functions. This is driven in part by the emergence of the non-relational technologies of NoSQL and Hadoop and the creative force to extract new value from data. The new standard is the ability to use multiple data types, video, graph and spatial capabilities, in addition to data virtualization and data virtualization support. Real time data analysis is now the norm and no longer the exception. Six months in, is it safe to say we are at the acceptance level of this trend but implementation and vision remains another matter?  Want to find out more about how your company can leverage the power of non-relational data and your database platform?   Join Dobler Consulting and Anthony Antonello, VP, SAP HANA Global Center of Excellence, for a Live Webinar June 19th, 2018 @ 2:00 PM EDT for: SAP Sybase Roadmap 2018 View Video Replay and Download Presentation (more…)

Simplifying Your Analytics with Azure Databricks

By | Azure
Big data and analytics go hand in hand. If you are handling big data, then you understand the power and the pitfalls this brings. Advanced analytic options, AI and real-time processing are useful tools. But to balance this power you may end up sacrificing productivity and ease of use. Azure Databricks provides a high-performance analytics engine optimized for your Azure cloud database. It’s incredibly easy to deploy, even for large-scale enterprises. Free up your team for the more important stuff. What is Databricks Azure Databricks is a collaboration between Microsoft and Databricks to provide an optimized analytics platform for a large-scale cloud environment. So, what does it do? First, let’s look at Databricks. Basically, Databricks is Apache Spark made more accessible to a large-scale enterprise environment. If you aren’t familiar with Apache Spark, it is the open-source analytics engine developed out of UC Berkeley that has gained significant traction in the past 5 years. It has become a leading platform with widespread use at the enterprise level. It has some drawbacks, though. It is complicated to deploy, and the larger your organization, the more complicated it becomes. Enter Databricks. This managed version automates a lot of the processes, making deployment (more…)

Dobler Consulting Achieves A Silver Microsoft Partner Certification To Compliment Its Gold

By | Press Releases
Data Analytics + Data Platform Certifications Creates Synergistic Value For Microsoft Clients   Tampa Bay April 23rd, 2018:  Over the past 6 months, Dobler Consulting has achieved what only 5% of all Microsoft’s Service Partners ever achieve – Gold and Silver Certification. Silver Certification for Data Analytics means that Dobler Consulting is now a premier specialist in helping their clients turn data into actionable insights by using business intelligence, big data, and advanced analytics best practices. This vertically compliments Dobler’s Gold Certification for Data Platform achieved two years ago. This certifies skills competency and security assurances for work on big data SQL databases in on-site and hybrid environments. “Our certified vertical data competency will further enable our clients to more quickly innovate and implement new data-driven insights. This is a very exciting time to be in our business as the barriers between the company and the consumer begin to blur and merge.” According To Peter Dobler, CEO of Dobler Consulting. “Agile data infrastructure, combined with advanced analytics and creativity are making this epic transformation possible.” The convergence of data infrastructure to data solutions is now an exponentially accelerating trend. IDC reports that growth of the Big Data and Analytics will (more…)

Expanding the Market: MS SQL Server 2017 and Linux

By | Blog, Database Technology Trends, SQL Server
Microsoft’s exciting cross-platform product, SQL Server 2017, is poised to reach a whole new audience. Recently this industry leader has joined the growing trend of support for open source solutions.  Our team is continually investigating new innovations for our clients, and we wanted to share what we have discovered about new features and performance. Why Now? Linux is becoming increasingly popular thanks to its security, stability, and efficiency.  Its design protects against virus and malware attacks with a complex architecture and secure user account structure.  With more and more businesses choosing Linux, Microsoft realized they were forcing clients to manage multiple environments by keeping SQL Server only on Windows.  Rohan Kumar, then General Manager of Microsoft Database Systems, discussed the decision with Frederic Lardinois for Tech Crunch.  “We had a couple of discussions in the past where it wasn’t approved,” he told Lardinois, but four years ago his team recognized the value of expanding, so they pitched the idea once again. “The biggest surprising part was that we were expecting a whole lot of back and forth. It was really surprising to see how quickly the decisions got made,” recalls Kumar. How? With the company’s support in place, Kumar’s team needed (more…)
Data Migration Support

Invisible Columns in Oracle 12c

By | Oracle Tips, Technology Tips & Tricks
Invisible column is a new feature in Oracle 12c.  Invisible columns provide a convenient way to change a table’s structure without having to edit the existing applications using that table.   Invisible columns can be created at the time of table creation using CREATE TABLE command                                 SQL> create table inviscol_test                                 2  (compno number,                                 3  compname varchar(20),                                 4  compcode varchar(10) invisible);                                 Table created.   existing visible columns can be modified to invisible using ALTER TABLE command                                 SQL> alter table inviscol_test modify (compname invisible);                                 Table altered.   How does it work?   The insert statement where we don’t specify the column names will fail.                                 SQL> insert into inviscol_test values (101,'ABCD','A101');                                 insert into inviscol_test values (101,'ABCD','A101')                                 *                                 ERROR at line 1:                                 ORA-00913: too many values                                 Explicit column names should be included in the insert statement.                                 SQL>  insert into inviscol_test(compno, compname, compcode) values                                 (101,'ABCD','A101');                                 1 row created.   If invisible columns are not listed in the insert statement they are set to NULL                                 SQL>  insert into inviscol_test values (201);                                 (more…)

Dobler Consulting Achieves Microsoft Gold-Certified Partner Status

By | Press Releases, SQL Server | No Comments
September 2, 2017, TAMPA, FL— Dobler Consulting (doblerconsulting.com), a leading information technology and database services company, offering a broad spectrum of services to clients ranging from start-ups to Fortune 50 in a variety of industries, announced today that it has achieved Gold-Certified Partner status with Microsoft. The Gold Certified Partner status is the highest level within the Microsoft Certified Partner program. Dobler Consulting has demonstrated knowledge and expertise in multiple areas to achieve Gold Certified Partner status. Microsoft Certified Professionals must pass exams that prove their skills meet our standards. “Dobler Consulting continuously works to find new and innovative ways to improve skill proficiency and client outcomes. Our Microsoft Gold Certified Partner status demonstrates our knowledge of Microsoft database technology through testing and client references. We’ve successfully implemented projects to the complete satisfaction of our clients,” says Peter Dobler, Founder & CEO at Dobler Consulting. “And, we’re excited about the opportunities to engage in more Microsoft-based client engagements as a result of achieving this distinction.” Achieving the Microsoft Gold Partner status ensures our new and existing client base, that the Dobler team is highly qualified to take on the most complex Microsoft SQL Server database challenge.   About Dobler Consulting (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