Author: Scott McCormick

Top talks to watch for at Google Next London

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…

Read More >

A look at GCP Helsinki Data Center’s opening event

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…

Read More >

SQL Server and Azure soft delete

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…

Read More >

Azure total cost of ownership calculator

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…

Read More >

Building data tests in PowerShell

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…

Read More >

Sharding a SQL Server database

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…

Read More >

Questions to ask when migrating to a new database platform

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…

Read More >

Microsoft Azure IaaS SQL Server best practices

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…

Read More >

Microsoft SQL Server 2017: identity_cache and select into filegroup

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…

Read More >

Implementing fuzzy search in SQL server – part 2: Levenshtein distance

The Levenshtein Distance, as discussed in my last post, is a way to measure how far two strings are located from each other. There are several T-SQL implementations of this functionality, as well as many compiled versions. In addition, the…

Read More >
Page 1 of 212