Hello and welcome to episode number three of SQL On the Edge! In this episode we’re going to cover Azure SQL elastic database jobs. In the last few months, Microsoft has put a lot of effort in augmenting the elastic…

Here at Pythian we have planned and implemented dozens of migrations and upgrades for our customers. In this blog post I am trying to summarize the 10 most important things to consider when migrating or upgrading a SQL Server environment,…

While I was working on a migration project recently, I had the task of importing and then exporting multiple packages – about 120~ on to a new server. Usually, if there are less numbers of packages we can do this task manually…

Hello and welcome to our second episode of SQL On The Edge! On this episode we’re going to focus on a new feature of SQL Server 2016 called Temporal Tables. What’s a Temporal table? Temporal tables allow us to go…

This blog post is a quick introduction to Containers in the Windows world, and a walk-through on installing SQL Server in a Windows Container. Introduction As many of you have heard, Microsoft is jumping into containers with native support for…

  Hello and welcome to my new video blog (Vlog) series SQL On The Edge! My goal with these videos is to provide short, concise demonstrations of the latest and greatest features regarding SQL Server, Azure SQL Database and other…

Yesterday at VMworld, VMware announced its entry into the managed database platform market with the introduction of vCloud Air SQL. This new service is an on-demand, managed service offering of Microsoft SQL Server. It’s meant to further the adoption of…

Amazon has just released their RDS Migration Tool, and Pythian has recently undertaken training to use for our clients. I wanted to share my initial thoughts on the tool, give some background on its internals, and provide a walk-through on the functionality it will be most commonly used for.

Introduction This is the seventh and final post in the series on the Pillars of PowerShell. The previous posts in the series are: Interacting Commanding Debugging Profiling Windows OS SQL Server – Part 1 In this final post I am going to…

Azure SQL Database is Microsoft’s Database as a Service (DBaaS) platform offering. It allows end users to leverage the power of SQL Server in the cloud without the expense and complexity of building a private infrastructure. Additionally, this offering simplifies…