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
trace flag 1254 fixes SQL Server Error Message 3628
How Trace Flag 1254 Fixes SQL Server Error Message 3628 with Queries Using In-Memory Tables
09 Jun 2019

I recently ran into this issue with SQL Server 2019 CTP 2.5 where I was getting the error – Msg 3628, Level 16, State 1, Line 4 The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator. It turned out that this would happen whenever I ran a query that joined In-Memory tables with disk based tables and the result ended up with no rows returned. Here is how trace flag 1254 fixes SQL Server Msg 3628 floating point exceptions. What causes Msg 3628, Level 16, State 1, Line 4 The Database Engine recei...

Backup Restore Azure SQL DBMI
Migrate Azure SQL Database Manage Instances to Azure VMs using Backup and Restore
08 May 2019

I recently needed to migrate an Azure SQL Database Managed Instance to an Azure VM running SQL Server. There were several reasons for this which included: Machine Learning Services was not available for processing R language libraries close to the database. Bulk loading CSV files were slower than expected because Managed Instances only supports the Full Recovery Model. PolyBase was not available for data mining data files located in Azure Data Lake Gen2 storage. The challenge that I faced was that when you create a database on a SQL Server Managed Instance, the database is encrypted with Transparent Data Encryption (TDE). It also uses a servi...

Managed Instance file growth
Beware — Azure SQL Server Database Managed Instance default file growth of 16 MB
02 May 2019

During bulk data loads with an Azure SQL Database Managed Instance, we noticed a significant performance hit as we imported data into staging tables. It turns out a Managed Instance default file growth for data and files is 16 MB! Change your Managed Instance default file growth size now! With the database file growth set so low, SQL Server grinds to a snail’s pace when importing large amounts of data. In our case, I changed the file growth to something reasonable given the batches of data we were loading like this: 123456USE [master] GO ALTER DATABASE [AnalyticsDB] MODIFY FILE ( NAME = N'data_0', FILEGROWTH = 200MB ...

migrate oracle to amazon ec2
Save on Licensing Costs and Migrate Oracle to Amazon EC2
08 Jan 2019

How can a world-leading multimedia content producer migrate Oracle to Amazon EC2 with minimal downtime while also reducing licensing costs? In this blog post, we discuss how we saved our customer 28% in Oracle licensing costs, implemented a reliable HA/DR solution, and migrated their immense environment to the AWS cloud with near-zero downtime using Oracle Data Guard. To better understand the client’s existing infrastructure, requirements, and potential limitations, let’s explore the customer’s environment prior to our successful migration. The Situation Our client had 18 licensed cores running a custom-built multimedia mana...

Validating AWS EC2 SQL Server deployments using benchmark tools
16 Nov 2018

As cloud computing becomes more and more popular and demanded among our customers, quite often we at DB Best need to answer the simple question: “How can I get the best value for running my SQL Server workloads on AWS EC2 instances?”. Issues like mistakenly using older generation EC2 instances or not optimizing your EBS volumes can prove to be costly. Likewise, not all hardware supporting the AWS infrastructure is created equal, despite the fact that they try to keep everything running at peak performance levels. Given the variability that can take place, we are extending AWS database migration service to include an option of vali...

Validating Azure SQL Server Deployments
Validating Azure SQL Server Deployments Using Benchmark Tools
08 Nov 2018

If you have been deploying SQL Server workloads to the Microsoft Azure platform using virtual machines, you may have noticed that not all virtual machines, solid-state drives, and network components are created equal. There might be issues in your deployment templates that could result in SQL Server not performing as well as expected. For example, in a presentation given by André Arko at StrangeLoop 2016, André claims that Netflix benchmarks AWS EC2 instances that they use for production and if it passes, they use it. If the EC2 instance doesn’t pass the benchmark, then they terminate the instance and spin up a replacement. According ...

Azure SQL Database Hyperscale
Top 3 Azure SQL Database Hyperscale Benefits
08 Nov 2018

When customers feel the need for speed and size, Microsoft announced at Ignite a new service called Azure SQL Database Hyperscale. This service offering is now available public preview as of October 1, 2018. Think of this as cloud-based Oracle RAC for SQL Server or Amazon Aurora for SQL Server in terms of the ability to scale SQL Server up to 100 TB! Like Azure Synapse Analytics, Microsoft separated the Compute processing from the Storage so that you can dial up the performance needed. In this blog post, we will introduce you to the top 3 Azure SQL Database Hyperscale benefits. 1. Big size One of the major Azure SQL Database Hyperscale benefi...

A global leader in legal content management services migrates from Sybase to SQL Server
Migrate Sybase Java applications to SQL Server for content services provider
04 Oct 2018

A leading provider of content services for the legal industry looked to DB Best to help them modernize their aging Sybase ASE and IQ solutions that were built on top of an old IBM AIX system. We helped our customer in the past with a Sybase ASE migration. The challenge for this project — migrate Sybase Java applications along with the associated Sybase ASE and IQ database solutions to SQL Server running on AWS EC2. In this video blog post, we’ll discuss the process we used to migrate Sybase Java applications and the Sybase ASE database to SQL Server. (more…)...

Top 5 reasons for migrating to Azure SQL Database Managed Instances now!
02 Oct 2018

Microsoft is doubling down on Azure SQL Database Managed Instances (DMI) this year. There are some amazing Microsoft offers to provide a Platform-as-a-Service for running SQL Server on Azure. More importantly, there is a much higher degree of capability with DMI than what is available with Azure SQL Database DTU and vCore service levels. In this blog post, you will discover the most important reasons for migrating to Azure SQL Database Managed Instances. Also, you will learn how DB Best experts can help you get there within a short period of time. Azure SQL Database Managed Instances is a new deployment model of Azure SQL Database. It provid...

DataOn SQL Server 2017 solutions
Reducing operating costs by upgrading SQL Server 2008 workloads using DataON SQL Server 2017 solutions
24 Sep 2018

What are your options when the end of support for SQL Server 2008 R2 occurs in July 2019, and moving to the cloud is not an immediate option? In a joint benchmarking project between DataON, Western Digital, and DB Best Technologies, we demonstrated how you can reduce your operating costs for upgrading SQL Server 2008 workloads using DataON SQL Server 2017 solutions. DataON S2D-5224w server – 2U 24-bay 2.5″ All-NVMe Hyper-Converged Cluster Appliance DataON SQL Server 2017 solutions feature Windows Server Hyper-Converged Infrastructure (HCI) solutions using Storage Spaces Direct. While this sounds a bit scary and expensive, we sho...