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
Oracle to SQL Server migration with SSMA
Oracle to SQL Server migration with SSMA: How to convert cursor or cursor variable as a function or procedure call parameter
09 Mar 2017

Oracle 9i introduced the predefined SYS_REFCURSOR type meaning we no longer have to define our own REF CURSOR types. SQL Server doesn’t support SYS_REFCURSOR type and doesn’t have a direct equivalent for it. Thus, SQL Server Migration Assistant (SSMA) for Oracle converts SYS_REFCURSOR variables into varchar (8000) and generates the appropriate warning message: «Warning O2SS0259: Cursor type was converted to varchar». Oracle’s SYS_REFCURSOR type allows returning recordsets from stored procedures and functions. For example, a procedure can open a cursor and use a ref cursor to return a subset of the records to the caller procedure or an...

Database migration with SSMA: How to handle typical conversion errors
09 Mar 2017

Welcome to our blog post series covering the typical conversion errors of SQL Server Migration Assistant (SSMA). DB Best has a vast experience in database migration, so, we constantly encounter these errors and found the solutions for most of them. We will devote one blog post per common error message that may occur during database migration with SSMA. Each blog post contains a problem statement and our recommendation on how to fix it correctly. Related posts Below you can find the table of contents for blog posts, related to the typical SSMA conversion errors. We will update the list in this post for new SSMA error posts. For regular us...

Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported NumToDSInterval function
02 Mar 2017

Oracle’s NumToDSInterval function converts the provided number value of specified time units or expression to an interval day to second literal. Usually, we use the interval values when dealing with dates. PostgreSQL provides some support for intervals but does not support storing values of such kind in variables. Hence, there are no functions in PostgreSQL able to return interval values.We commonly use the functions working with date intervals in reporting and other type of queries. So, when you try to convert the code with the NumToDSInterval function call, SCT will generate the following message “5340 — Severity CRITICAL — Post...

Database migration with AWS SCT: How to handle typical conversion issues series
02 Mar 2017

Welcome to our blog post series covering the typical conversion issues of AWS Schema Conversion Tool (SCT). DBBest team has a vast experience in database migration area. So, we decided to start the blog post series covering the most common conversion issues of AWS SCT. Each blog post will be devoted to a certain action item and will provide specific solution or a workaround for a problem. Below you can find the table of contents for blog posts, related to the typical AWS SCT conversion issues. We will update the list in this post for new SCT issues posts. For regular users of SCT feel free to bookmark this post to keep an eye out for new ...

Oracle to MySQL migration with AWS SCT: How to handle unsupported NumToYmInterval function
02 Mar 2017

Oracle’s NumToYmInterval function converts the provided number value of specified time units or expression to an interval year to month literal. Usually, we use the interval values when dealing with dates. MySQL provides a certain level of support for intervals but does not support storing values of this type in variables. Hence, MySQL does not have any functions that are able to return interval values. The functions working with date intervals are commonly used by reporting and other type of queries. So, when you try to convert code with the NumToYmInterval function call, SCT will generate the following message “340 — Severity CRIT...

Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported data types
02 Mar 2017

Oracle’s subtype declaration allows creating an “alias” for some datatype declaration, which can be re-used later as many times as needed. PostgreSQL domains do not match Oracle’s subtypes completely. Thus, whenever you try to convert PL/SQL code containing variables that are declared with defined subtype, SCT will generate the following message: “Issue 5028 — Unable to convert definition of object with unsupported datatype”.   Continue reading to learn more about the possible remedies of this issue. (more…)...

Oracle to MySQL migration with AWS SCT: How to convert variables of SYS_REFCURSOR datatype
02 Mar 2017

Oracle 9i introduced the predefined SYS_REFCURSOR type meaning we no longer have to define our own REF CURSOR types. We normally use Oracle’s SYS_REFCURSOR datatype to declare the CURSOR variable of a weak type, which means that we don’t know exactly the number of columns and their type. Then this SYS_REFCURSOR variable has to be used together with a dynamic SQL code to open the cursor variable. MySQL does not support cursors of a weak type. So, when you try to convert any variables of SYS_REFCURSOR datatype in your source code, SCT will generate the following action item: “Issue 337 — MySQL does not support a variable of S...

Optimizing your Redshift Storage with AWS Schema Conversion Tool
02 Mar 2017

Amazon introduced the new feature called Redshift Optimization for the Schema Conversion Tool (SCT) November 17, 2016 release. You can now use AWS SCT to optimize your Amazon Redshift databases. For more information, see Optimizing Amazon Redshift by using the AWS Schema Conversion Tool. In the following video, we will demonstrate the essentials of using the Redshift Optimization to improve the query performance. Make sure to check out our new AWS Schema Conversion Tool Jumpstart offer to get you up and running fast for your migration to Amazon Redshift. Background on Redshift Optimization When do you really need to launch the Redshift Optimi...

Using a Neural Network for Face Tracking on Android
02 Mar 2017

In one of our previous blog posts, we talked about face tracking basics. We have demonstrated a simple mobile Face Tracking application, based on native iOS frameworks. Nonetheless, it had some serious limitations and restrictions. We will now take a step forward and talk about more complex face tracking mobile application, where a neural network performs the detection of users’ faces. We should note that the implementation of neural networks in mobile applications proved to be quite a challenging task. Delivering a decent result for a wide range of mobile devices requires using nontrivial solutions and really good optimization hacks. C...

Break the Silence — Try Emojitones for Sound Messaging!
01 Mar 2017

Communication remains a very important part of our daily life. Smartphones’ usage growth allows you to stay in touch with your friends on the go. Many chat applications have already made their name in the market, for instance Skype, WhatsApp or Facebook Messenger. Nonetheless a new solution can certainly break through and find its place in the sun. Especially when it comes with some really cool and innovative features. We proudly present Emojitones, the first ever sound-based messenger in the world, developed by DB Best team. This awesome chat application delivers an unprecedented messaging experience using emojis with hilario...