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
Global Retailer Tunes up OLAP Performance Ten-fold
15 Dec 2016

When a company grows, it’s no surprise that their database stored data grows as well. This is the case for all companies, and our customer, a global retailer in the beauty industry, was no exception. While working on this project, we managed to increase the average speed of query execution by 30x, saved up to 190 GB of memory and freed up 28 GB of disk storage space. Prior to these great results, there was a hard optimization process performed on the customer’s system based on the OLAP cubes technology. We sped up the query execution by 107x. Freed up to 190 GB of memory, and improved the overall performance of the OLAP Cube by 3x. We...

AWS Schema Conversion Tool: Specific Features of Migrating Data Warehouses to Redshift
14 Dec 2016

This continues our video blog series on the AWS Schema Conversion Tool (SCT). In the previous blog post we’ve talked about the general approach of data warehouses migration to Amazon Redshift, and in this article, we are going to dig deeper into the DW migration specific features. Before starting the migration of Greenplum, Netezza, Oracle or Teradata data warehouse to Amazon Redshift, you will want to understand the capabilities and limitations of Redshift. This video will give you a better understanding of what you may encounter when migrating to Amazon Redshift. Be sure to check out our new AWS Schema Conversion Tool Jumpstart offer to g...

AWS Schema Conversion Tool: General Approach to Migration of Data Warehouses to Amazon Redshift
06 Dec 2016

This post continues our video blog series on the AWS Schema Conversion Tool (SCT). In our previous blog posts, we talked about using AWS SCT for transactional database migration projects. The AWS Schema Conversion Tool also supports migrating data warehouse (DW) workloads to Amazon Redshift. AWS Schema Conversion Tool uses a different approach to DW migration projects compared to the transactional database migration workflow. With transactional databases, you typically have stored procedures, triggers and other database objects which deal with business logic in the database. With a data warehouse, you typically don’t have these types of...

SSMA for Oracle 7.0 — Overview of Data Migration Features
05 Dec 2016

DB Best uses a 12-step migration process to make sure all bases are covered as part of a typical migration project. Data migration is a critical part of a database migration projects and tools like SSMA can help in the process. In the following video, we will show you how to migrate data from Oracle to SQL Server using the SSMA tool, as well as highlight errors that may occur during database migration.   Need help getting started? Check out our Jumpstart for SSMA offer! (more…)...

Countdown to AWS re:Invent – Come see us at booth #236
21 Nov 2016

AWS re:Invent 2016 is just days away, and DB Best is excited to be there November 29 – December 2. We’ll be at booth #236. Come see us! To help start the conversation, here is a list of our recent AWS Schema Conversion Tool blog posts: Migrating an Oracle to MySQL Database using the AWS Schema Conversion Tool AWS Schema Conversion Tool: Offline Mode AWS Schema Conversion Tool: Connecting to Oracle Source Database Selecting target database type for migration using Assessment Report in AWS Schema Conversion Tool Troubleshooting database migration issues using AWS Schema Conversion Tool Assessment Report Converting Objects during Dat...

AWS Schema Conversion Tool: Applying Converted Code to Target Database
16 Nov 2016

This continues our video blog series on the AWS Schema Conversion Tool (SCT). After connecting to the source database and troubleshooting the database migration issues it’s time to apply converted code to the target database. The AWS Schema Conversion Tool provides two ways of applying changes to the target database. The first option allows you to generate the SQL-script. You can modify this script if needed and then execute it using your favorite database tool. The second option allows to modify the target database in real-time, using the GUI of the AWS Schema Conversion Tool. In addition, SCT drops and recreates existing objects on the...

DB Best upgrades a leading telecom company’s SQL Server 2000 and 2005 databases
11 Nov 2016

Upgrading SQL Server can be a complicated and nuanced operation, it can’t be simply performed with a few mouse clicks. In many ways, upgrading SQL Servers follows a similar process to more general database migration projects. Because of the similarities, we can apply our 12-step database migration methodology to great effect. From analyzing the existing database architecture to consolidating resources for operational cost reduction, DB Best has the tools and know-how to ensure your SQL Server platforms are up to date. In the following video, we will show you how DB Best executed a SQL Server upgrade project for one of Europe’s leading tel...

Innovation in Loyalty Programs: Augmented Reality Mobile Application for Discount Offers
10 Nov 2016

People enjoy the money-saving rewards of discount offers. On top of that, people enjoy the fun of playing games. With Reward Hunter from the DB Best app development team, mobile phone users can get the best of both worlds. At DB Best, we’ve combined these two activities into one augmented reality mobile application that can engage users and help you grow your business. This fun new application, called Reward Hunter, comes in an “out of the box” version for use on either iOS or Android mobile phones. Reward Hunter can also be customized for your business, for a unique user experience to help build your company̵...

Faster reporting and flexibility using SSIS and SQL Server
DB Best Case Study: Faster reporting and flexibility using SSIS and SQL Server to offload Excel reports from SSAS cubes
03 Nov 2016

DB Best recently completed a complex development project for one of the largest banks in the Middle East. Faced with non-customizable and slow-to-generate reporting, the customer contacted DB Best to develop a new and improved solution. The customer’s original system was built on two SQL Server Analysis Services systems, each containing large amounts of various aggregated data types with Excel workbooks directly accessing the two SSAS cubes. Not only did this system take a considerable amount of time to generate reports, but the non-customizable structure proved limiting for the customer. Check out the video below to see how DB Best used SQ...

SSMA for Oracle 7.0 — What’s New — Using In-Memory OLTP in SQL Server 2016
14 Oct 2016

This continues our video blog series about new features on the new capabilities of SQL Server Migration Assistant 7.0. SQL Server 2016 In-Memory OLTP significantly improves OLTP database application performance and allows running large queries against the same tables using clustered and non-clustered columnstore indexes. This technology was introduced in SQL Server 2014 and now SSMA 7.0 supports migrating Oracle Database In-Memory tables to In-Memory OLTP with SQL Server 2016. Background on SQL Server In-Memory OLTP and Oracle Database In-Memory SQL Server 2016 In-Memory OLTP is a high performance, memory-optimized engine, designed for modern...