Author: Scott McCormick

This blog post describes how to enable roll-your-own Disaster Recovery in GCP Cloud SQL. This process is automated and will save money. However, recovery is manual. Introduction One of the benefits of using the cloud is the ability to track…

On October 10 & 11, 2018, Google Next London will be running in full force. Pythian will be attending with a booth and many of our top executives and technical leaders ready to discuss our cloud strategies and offerings. This…

Pythian was recently invited to attend the very successful opening of the new GCP Helsinki Data Center. Based on the number of attendees and their excitement level, Finland is very ready to jump on a local cloud provider with over…

Microsoft just announced the public preview for Azure Soft Delete of Storage Blobs. From the documentation, “When turned on, soft delete enables you to save and recover your data when blobs or blob snapshots are deleted. This protection extends to…

Microsoft has released a new Azure Total Cost Ownership (TCO) Calculator. This calculator allows you to quickly enter in your current on-premises workload and review the expected savings or costs of moving to Azure. Workloads You simply enter in your…

While working with a client recently, we came across a problem while testing data for completeness or errors after running an ETL process to import & manipulate the data. The main issue we ran across was that the overall client…

This blog post covers sharding a SQL Server database using Azure tools and PowerShell script snippets. Sharding, at its core, is breaking up a single, large database into multiple smaller, self-contained ones. This is usually done by companies that need…

As systems come online and new technologies are made available, companies are faced with a decision point: Should we fragment our existing technology stack to attempt to take advantage of these new tools, or continue with our current environment at…

Modern cloud IAAS offerings are sold as a fast and convenient way to setup a server without having to worry about purchasing hardware, networking, and basic installation/configuration work. For the most part, I believe this is true, and they’ve fulfilled…

Microsoft SQL Server 2017: Two Useful New Features This week I discovered two new features in Microsoft SQL Server 2017 that I think will be helpful to both developers and DBAs. These are two small changes, but they solve problems…