Bill Ramos

Chief Technology Storyteller

Ok, my official title is Director of Technical Product Management. I also work on customer projects as a solution architect for projects related to SQL Server, Microsoft Azure, and AWS.

What makes DB Best great is the breadth of technologies and services they offer to their customers and partners. For example, how many people get to work with technology like the AWS Snowball Edge?

 

 

It's my job to work with the DB Best team members to define the services that DB Best provides to its customers. More importantly, tell the customer success stories in blog posts, webinars, and training events to help people better understand the latest technologies and how they can move forward with their digital transformation efforts.

Database migration to SQL Server award winners 2016

 

A brief history of Bill

To understand how I got here, I assembled a "blast from the past" tour of my 37 years in computing.

Semper Paratus "Always Ready"

 

I started my database career in 1982 with the US Coast Guard by creating one of the first vessel tracking systems using the Pick operating system and later with dBASE II on CP/M.

 

The PC era and the start of client-server

 

In 1987, I landed at Ashton-Tate and eventually Borland as a developer working on the dBASE product line. At that time, I got my first exposure to the Microsoft, Ashton-Tate, Sybase SQL Server running on OS/2 where I wrote compatibility and performance test suites for the platform.

 

Start Me Up era

 

 

In 1995, I joined Microsoft as a program manager in Visual Studio working on database design tools for SQL Server and Oracle. I spent several years in Microsoft Office working integrating SharePoint and SQL Server with Access as part of the XP release. I then had the privilege of being a lead program manager for Excel, Access, and VBA for the Office 2003 release.

At the tail end of 2003, I had a chance to work with another great team in developing the manageability and performance troubleshooting tools for SQL Server Management Studio across the SQL Server 2005, 2008, and SQL Server 2008 R2 releases. I want to think I was part of the team that made SQL Server for the masses, but I might have been wrong based on this "Man on the street" interview.

In this role, I immersed myself in the world of Oracle with the goal of taking the best they offered, to make SQL Server better for DBAs. Plus, the intel helped spawn this video for a Microsoft sales event.

 

 

Entering the world of marketing

 

In 2010, I had a unique opportunity to join a technical marketing company, Indigo Slate – formally known as Advaiya Inc. As the VP of Technical Consulting, I got the chance to immerse myself in the world of technology marketing for a variety of large software vendors like Microsoft, VMware, Cisco, and SAP. Also, I consulted with Microsoft to develop technical content for helping Oracle DBAs better understand SQL Server technologies.

 

In recognition of the community involvement with SAP HANA, SAP awarded me the title of HANA Distinguished Engineer (HDE) in 2015. It was also where I refined my processes for evaluating technologies for customers. Check out my interview at 2 minutes and 37 seconds in the video below on what being an HDE meant to me.

 

That's my story!

37
Years of experience
94
Blog posts
32782
Happy readers
NOW
Ready to innovate
Reducing time and costs while building highly available system
Developing Always On Availability Group checklist with reduced configuration time and costs
11 Sep 2017

One of America’s largest transportation authorities was running the mission-critical system on SQL Server platform and any down times could harmfully impact millions of citizens. So, they contacted DB Best to help them modernize their system. We advised them to implement high availability and disaster recovery solutions to keep their system running without interruptions. To meet the customer’s needs, we performed technical support and delivered detailed instructions and automated scripts to implement the highly available architecture in compliance with Always On Availability Group checklist. Our solution allowed the customer to build ...

How to determine Oracle migration ROI for complex systems
06 Sep 2017

A global pharmaceutical company has been supporting hundreds of applications on the Oracle platform. Their complex system became outdated over the years with 90% of end of life or extended support Oracle versions with very expensive contracts. They needed a cost effective solution, so they looked for a way to move their workloads to a higher value SQL Server solution. See how we helped our customer determine Oracle migration ROI (Return on Investment) for their highly complex environment. Let’s see how we approached the analysis to demonstrate that our customer could achieve an Oracle migration ROI within 1-year by moving to SQL Server...

Migration Project for A Global Leader in Security Technology
Migrate Sybase ASE databases to SQL Server for a security technologies company
25 Aug 2017

DB Best recently completed a project to migrate Sybase ASE databases to SQL Server for a global leader in security technology. Faced with skyrocketing license costs with SAP to renew their out-of-support server instances, our customer needed a way to migrate hundreds of Sybase ASE databases. To make matters worse, our customer faced upgrading their out of support PowerBuilder applications. By migrating to SQL Server on commodity Intel based servers, our customer found that they could exceed their performance needs and lower overall licensing costs. Check out the video below to see how we approached the project to migrate Sybase ASE databases ...

Oracle to SQL Server migration with SSMA: How to convert materialized view with float type
24 Mar 2017

SQL Server has several different ways of implementing the same behavior as an Oracle materialized view. SSMA cannot understand the original optimization reason for why the application needed the materialized view, so SSMA flags certain conditions as an error. This blog post discusses error O2SS0522 where the Oracle materialized view includes FLOAT columns, WHERE or GROUP BY clauses, subqueries, UNION, MINUS, INTERSECT, etc. Currently SQL Server Migration Assistant (SSMA) for Oracle converts materialized views to SQL Server indexed views. While converting a materialized view, SSMA creates necessary unique clustered index on the view in SQL Se...

Using AWS Schema Conversion Tool Extension Pack for OLTP databases
23 Mar 2017

Running your database migration projects, you may have already noticed that AWS Schema Conversion Tool (SCT) automatically generates an additional schema called extension pack. This schema emulates the system functions and specific features of the source database in your target DB instance. In the following video, we demonstrate how to apply this extension pack to the OLTP database. And in our future blog posts we will talk about working with extension pack for data warehouses. Make sure to check out our new AWS Schema Conversion Tool Jumpstart offer. Continue reading to learn more about the extension pack features. (more…)...

Why guess? Learn how augmented reality with 3D objects allows you to try before you buy!
17 Mar 2017

Have you ever asked yourself, wouldn’t it be cool if I had a smartphone application that would show me how a piece of equipment will look on my shop floor before buying? We’re proud to introduce you to an augmented reality iOS application developed by DB Best. This application displays a selected 3D model of production equipment on the screen of iPhone or iPad, adding it to the live camera picture. So, you can explore, how the machinery will fit into your production facilities after the installation. Also, you can discover the selected production equipment in details by zooming and rotating the model on the screen of your smartpho...

Oracle to MySQL migration with AWS SCT: How to convert BULK COLLECT clause
16 Mar 2017

Oracle’s SELECT INTO statement with BULK COLLECT clause allows you to retrieve an entire result set and store it in a PL/SQL collection type variable in a single operation. This approach allows to avoid the use of a loop statement to retrieve one result row at a time, thus making the code compact and effective. MySQL doesn’t support the BULK COLLECT INTO operation, so, SCT can not convert the source Oracle code correctly. When you try to convert the source code that contains the SELECT INTO statement with BULK COLLECT Clause, SCT will generate the following message “140 — Severity CRITICAL – MySQL doesn’t support BULK ...

Extracting Data from Warehouses with Data Migration Agents in AWS Schema Conversion Tool
15 Mar 2017

Migrating data warehouses to Amazon Redshift represents a serious challenges when you consider what it takes to transfer huge amounts of data in parallel. On February 16, 2017, Amazon released version 1.0.600 of AWS Schema Conversion Tool (SCT). This release brings the support of Data Migration Agents. Now you can effectively extract data from Oracle and Teradata data warehouses and prepare it for use with Amazon Redshift. In the following video, we will demonstrate the typical workflow of using the Data Migration Agents to extract data and upload it to Amazon Redshift using the S3 Bucket as a data loading zone. Make sure to check out our new...

Oracle to SQL Server migration with SSMA: How to convert Unparsed SQL — Pivot Operator
09 Mar 2017

Oracle 11g introduced pivot operation that allows writing cross tabulation (also called transposed, crosstab and matrix) queries that rotate rows into columns and aggregate results. Pivot rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output and performs aggregations where they are required on any remaining column values that you want to get in the final output. SQL Server Migration Assistant (SSMA) for Oracle cannot correctly parse the pivot operator and generates the following error message: «Error O2SS0004: Unparsed SQL». In this blog post we will provide some...

Oracle to SQL Server migration with SSMA: How to convert foreign keys with different types of columns and referenced columns
09 Mar 2017

Oracle allows you to create foreign key for table using columns with different data types. But SQL Server Migration Assistant (SSMA) for Oracle cannot convert them to SQL Server correctly because SQL Server doesn’t support the foreign keys that use columns with different data types. So, when you try to convert the original code that includes the foreign key with the columns of different data types, SSMA will generate the following error message: «Error O2SS0231: Foreign keys with different types of columns and referenced columns cannot be converted». In this blog post we will show how you can address this error and eliminate this conv...