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
Windows IIS and SQL Server on AWS
Deploying Windows IIS and SQL Server on AWS with CloudFormation
16 Aug 2018

In order to modernize their existing applications, databases, and infrastructure, the Office of the President of the University of California (UCOP), approached DB Best with a desire to not only create their ideal database environment but to cut costs along the way. Throughout our intensive discovery stage, we determined that we could help our client cut costs by migrating their Windows Internet Information Services (IIS)  and SQL Server to the Amazon Cloud (AWS). Over the course of our partnership, DB Best not only shifted them to the cloud, but built, tested, and deployed the next-generation of their database infrastructure. Oh, and we did...

Best practices for moving SQL Server to AWS: Amazon EC2 and RDS
26 Jul 2018

Our customer Getty Images was looking for a way to increase the level of user satisfaction by improving the performance of their enormous database system. They wanted to leverage operational best practices to increase resiliency/uptime, performance, and scalability at the lowest possible cost. Their overall goal was to move all of their applications out of their datacenter and over to Amazon Web Services through a lift-and-shift process. Watch the following video to discover how we approached this project. This blog post documents the best practices for moving SQL Server to AWS, specifically the Amazon EC2 and RDS environments which we develo...

Faster, Cheaper, Better: Upgrade SQL Server 2008 NOW
17 Jul 2018

So Long, Microsoft SQL Server 2008 I think that you’re supposed to know when it’s time to say goodbye. – Judy Sheindlin We get it. You’ve been running your SQL Server 2008 for ten years now, and its performance has made you very happy. It’s been as steady as a rock and helped guide your business while keeping your data safe and you really can’t ask for a better show from your database software. Unfortunately, it’s now reached the end of its support life, and that means you’re about to have a range of new problems and issues with it. When Microsoft decides to finally pull the plug on SQL Server 2008 Support in July 2019, th...

migrating PostgreSQL to Amazon RDS Aurora
Improve PostgreSQL Performance 12X by Migrating to Amazon Aurora with Minimal Downtime
17 May 2018

An online marketplace company managed a 6-terabyte database using an old version of Amazon RDS PostgreSQL version 9.3. With their platform gaining popularity day over day, they needed a way to scale the performance and size of their database near term to 15-terabytes. They also had several performance issues, including a daily batch script that was taking almost 2 hours to complete that was exceeding the maintenance window. Because of this, simple tasks like adding a new column to their largest table would time out. The main challenge for the migration project was that downtime could not exceed 6 hours and test efforts by their DBA team could...

Accelerate Database Migration to AWS
Accelerate Database Migration to AWS with DB Best – Webinar Wrap Up
02 May 2018

Big thank you to everyone who attended our webinar on May 1, 2018 – Accelerate Database Migration to AWS with DB Best! Dmitry Balin and myself talked about how DB Best and Amazon Web Services (AWS) can help you improve performance and reduce costs by migrating your on-premises databases to managed Amazon Relational Database Service (Amazon RDS), to virtual machines using Amazon Elastic Compute Cloud (EC2), or database warehousing solutions such as Amazon Redshift. I also did a couple of demos to show how the AWS Schema Conversion Tool (AWS SCT) helps accelerate the database adoption process by converting the schema of your source databa...

Top 3 reasons for running SQL Server on Linux
10 Apr 2018

With the release of SQL Server 2017, you now have the option to deploy the database engine and just about all of the related services on either Red Hat Enterprise Linux (RHEL) 7.3+, SUSE Linux Enterprise Server (SLES) v12 SP2, Ubuntu 16.04, or the latest Docker image that uses Docker Engine 1.8+ on Ubuntu 16.04 as of April 10, 2018. Microsoft recently published a very slick marketing white paper titled Top six reasons companies make the move that highlights various case studies of making the shift from Windows for running SQL Server on Linux that is well worth checking out. It includes the reasons that you would expect Microsoft to come up wi...

Sybase ASE to SQL Server Database Unification Project
Using Sybase SQL Server application unification to reduce migration risks
14 Mar 2018

A financial service software provider needed to upgrade their customer-facing applications to SQL Server while keeping their Sybase ASE database. Our Sybase SQL Server Application Unification process allowed them to use SQL Server as a new database engine. Using SQL Server allowed our client to meet regulations that required high availability features such as Always On along with Transparent Data Encryption to secure their financial data on AWS EC2 instances. We came up with a way to create an identical version of their existing Sybase ASE database running in SQL Server environment and performed some code unification that allowed the Powe...

AWS Snowball Edge
Using AWS Snowball Edge to transfer multiple terabytes of data into the Amazon cloud
10 Jan 2018

One of the main concerns during large-scale database migrations to the cloud is how long will the data transfer last. When you need to move multiple terabytes of data, the migration process may last for weeks or even months. In addition, the bandwidth of your network connection becomes a limiting factor, and some security concerns may appear. So, the whole migration project becomes unsustainable, and many customers with heavy-weight databases had to abandon their cloud migration initiatives. Amazon came up with a physical solution called AWS Snowball Edge, which allows for fast and secure data transfer of up to 80 TB of data in a matter of d...

AWS Glue ETL service
Loading Amazon Redshift Data Utilizing AWS Glue ETL service
27 Dec 2017

Your CIO has made the decision to move to AWS and now you’re left wondering how to move your Enterprise Data Warehouse (EDW) on Teradata: should you opt for using Teradata Software Tiers on AWS Marketplace with EC2 instances, or consider migrating to Amazon Redshift? The latter option looks interesting, but there’s one big issue: Redshift doesn’t support stored procedures. You’ve got a plenty of procedural code as part of your Extract-Transform-Load (ETL) processes, but it’s not clear how you can move it to Redshift. In this article, we’ll look into how regular data loading jobs can be moved to Redshift using AWS ...

Amazon Redshift Performance Tuning Tips
Using Amazon Redshift performance tuning tips to reduce query times by 800%
14 Dec 2017

Often database administrators experience decreases in query performance with Amazon Redshift as the size of data increases. The problem becomes even more significant when we start talking about regularly executed queries. Design time decisions that were made with the given the statistics at the start of the project may not make sense with the new data and query patterns. So, this means that the Amazon Redshift cluster requires some optimization. See how these Amazon Redshift performance tuning tips can improve query execution times when users start noticing performance issues. Amazon introduced a feature called Redshift Optimization for the...