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
Using AWS Schema Conversion Tool for Application Conversion
24 Feb 2017

A typical database migration project includes not only the schema conversion and data migration but also the application remediation. We are talking about one or many applications interacting with the source database. To wrap up the database migration project, you will need to convert the SQL code used in the application and then reconnect it to the new database. AWS Schema Conversion Tool (SCT) helps to automate this process and simplifies required efforts estimation for manual SQL code conversion. Check the following video to see the application conversion project in use and find out how the AWS Schema Conversion Tool helped our DBAs durin...

Discover How Face Tracking Mobile Apps Can Improve Your Business
10 Feb 2017

Detection of human faces in real-time imaging is a common task, which may occur in different areas and fit diverse business demands. Various algorithms were developed to resolve this task, and some of these solutions can be used in mobile applications for iOS or Android. Let us take a look at an iOS application prototype, which demonstrates the implementation of the Face Detection technology in quite a simple and entertaining way. Have a look at the following video to learn more about how you can use face tracking in mobile apps: The existing solution might be used to build a turnkey and cost-effective application which meets your expectation...

Portfolio spotlight: Momdezvous mobile application
05 Feb 2017

Mothers of small children are a specific category of people, united by common interests, problems, and hobbies. Absolutely all mothers are interested in finding new friends for communication, spending time together, and visiting various events. It would be great if new friends were living nearby. The main goal of the Momdezvous mobile application, developed at DB Best, is to unite moms with small children on one social network and provide interesting leisure and activities. Momdezvous is a private social network (like Facebook), intended for a narrow audience. It allows users to meet other users to build friendships for themselves and their c...

Cross-platform video streaming using RTSP
27 Jan 2017

Remote cameras can be used in various application solutions. Usually, this technology helps with building a local monitoring system for home or office (for example, a baby monitoring system). Besides that, remote cameras can come in handy for the fun and games industry: you can attach the compatible device to drones or other radio controlled toys and control them using a live view from the remote camera. The live video broadcast from one mobile device to another can be carried out in different ways. For example, you can use the common Real Time Streaming Protocol (RTSP). It supports direct video broadcast and doesn’t require an intermediate...

Introducing Fast Data Comparison in Database Compare Suite version 4.6
27 Jan 2017

Many of us regularly use Database Compare Suite — a tool developed by DB Best — for database migration and upgrade projects. This powerful and handy software solution helps confirm successful database migrations by verifying that the data made it to the destination table. Customers reported to us that comparing data between two huge tables simply took too long just to see if they were different. We listened and did something about it. This latest version of Database Compare Suite introduces a new feature called Fast Data Comparison to solve this problem. Data Comparison Data comparison has always been the core of the Database Compare Suit...

Now is the time to consider augmented reality applications
16 Jan 2017

Mobile applications industry delivers good news: augmented reality (AR), voice control, virtual reality (VR) and other amazing technologies become more and more popular. More importantly, modern smartphones have enough power to process the graphics for AR and VR. You can simply insert your smartphone into an affordable VR headset in order to dive into virtual reality. So, the most part of smartphone users now can access this variety of modern breathtaking technologies. Moreover, these technologies are not expensive and they do not require extra power from a mobile device. To see how the DB Best powered AR & VR application works, pleas...

Portfolio spotlight: Using iBeacons in the mobile application for exhibitions
04 Jan 2017

Visiting an exhibition, you may want to use a specific mobile application developed for the particular event. Especially if we’re talking about an airplane show, which tend to cover large areas. During the show, you would definitely like to know exactly where you are, what’s around you, and where else to go. Using map services to implement the previously mentioned features is a fairly simple and common task. But how do we get information about the various exhibits? Well, here we have an opportunity to integrate a truly fascinating IoT device. Our app developers used Apple’s iBeacons as part of our Live Airshow mobile application to enha...

First look at AWS Schema Conversion Tool with tighter DMS integration
03 Jan 2017

On December 20 2016, Amazon released version 1.0.502 of AWS Schema Conversion Tool (SCT). SCT now provides the integration with Data Migration Service (DMS)  and allows you to create AWS DMS endpoints and tasks. In addition SCT allows you to run and monitor the DMS tasks from SCT. AWS Database Migration Service helps you migrate databases to AWS easily and securely. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracl...

Power BI Reports
Embedding Power BI Reports in a WordPress blog
26 Dec 2016

Back in March of 2015, DB Best published a blog post on how to embed Power BI Power View interactive reports into your blogs and websites. Much has changed in Power BI since then and Microsoft has made it possible to easily embed reports into your blog articles. There are now two basic options for embedding reports. Power BI Embedded is a service on Azure for publishing Power BI visuals and uses authentication to make sure users can see the data they are supposed to. The other method is to use the new Publish to web feature introduced in the October 2016 release of Power BI. The downside is that you can’t authenticate users to view the ...

Reduce the cost of an Oracle database migration project by using SQL Server Linked Servers
21 Dec 2016

When talking about migration from Oracle to SQL Server, we always look for ways to work with our customers to keep costs under control. We recently completed an Oracle to SQL Server migration proof of concept project for a government organization in South America. What made this project unique was the way we used SQL Server Migration Assistant (SSMA) to convert one of eleven Oracle database schemas that were running on a 12-node Oracle RAC cluster to SQL Server. The other ten schemas remained in place and we used SQL Server Linked Servers on the new SQL Server instance to connect to the Oracle schema tables. This allowed the customer to use t...