SQL On The Edge #3 – Azure elastic database jobs

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…

Read More >

SQL Server: migrations/upgrades – 10 things to think about

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,…

Read More >

Import/export multiple SSIS packages

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…

Read More >

SQL On The Edge #2 – SQL 2016 temporal tables

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…

Read More >

Windows containers: installing SQL server

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…

Read More >

SQL On The Edge #1 – 2016 installer

  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…

Read More >

VMware Debuts SQL server DBaaS platform

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…

Read More >

Amazon RDS migration tool

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.

Read More >

Pillars of PowerShell: SQL Server – Part 2

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…

Read More >

Three hidden Azure SQL database gotchas

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…

Read More >
Page 10 of 22« First Page...89101112...20...Last Page »