Author: Chris Presley

Key Considerations for Moving a Database to the Public Cloud

Chris Presley, Solutions Architect at Pythian, covers considerations you should take before starting your cloud migration project.

Read More >

To apply or not to apply that Cumulative Update (CU)

Chris Presley, Solutions Architect at Pythian, discusses the pros and cons of applying Cumulative Updates on SQL Server.

Read More >

Converting Hortonworks Sandbox to run on Hyper-V

Chris Presley, Solutions Architect at Pythian, details how to convert Hortonworks Sandbox to run on Hyper-V.

Read More >

SQL Server on Linux – No April fools

Chris Presley, Solutions Architect at Pythian, discusses Microsoft’s announcement of SQL server on Linux.

Read More >

2013 in Review — SQL Server

It’s that time of year. When I take some time away from work, hide out, and reflect on the past year. 2013 was a big year for Microsoft, particularly SQL Server, Windows Azure, and HDInsight. While I’d love to recap…

Read More >

The death of the MCM Program

In case you’re unaware, Microsoft sent a late night email on Friday August 30th announcing it would kill off the MCM, MCSM and MCA certifications as of October 1, 2013. These are top level certifications, requiring candidates to do more…

Read More >

Update on Home Learning Lab – Hyper-V

This is an update on my “Setting up a home learning lab” post. I have recently decided to upgrade the host OS on my desktop to Windows 8 Professional so I could check out Hyper-V as a virtualization platform and…

Read More >

Setting Up a Home Learning Lab

Thanks to virtualization and cheap, powerful hardware there are a lot of cost effective options available today for setting up a learning environment on your own. In this blog post I will make suggestions on how you can cheaply build yourself an IT Playground, I’ll also talk about some mistakes I made along the way to hopefully save you from adding a few grey hairs.

Read More >

SQL 2012: Let’s Make a Date with DATEFROMPARTS and TRY_PARSE!

Continuing on from my last post, I felt like cleaning up some more data and using more SQL Server 2012 features. I happened on DATEFROMPARTS on MSDN and felt like playing with it.

Read More >

SQL 2012: Path to Easier Data Cleanup with Try_Convert

A new feature in SQL 2012 that I am very excited about is TRY_CONVERT which makes data conversion much easier. When you pair TRY_CONVERT with some Case statements, you can easily pipe the inconvertible data to other columns, which can then be reviewed and (hopefully) fixed prior to cutting over your data. I’ve mocked up a quick demo so you can see how powerful this new feature is.

Read More >
Page 1 of 212