I am a Microsoft Data platform MVP

I am so excited and happy to be chosen to receive the Microsoft Data Platform MVP award. This is my...

SQL Server 2016 available today

In case you haven't heard, SQL server 2016 is generally available today! If you haven't try it out, you should...

StorSimple Appliance – Part 1 Overview

Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance...

Cloud backup - MS StorSimple Applicance

In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure,...

End of Support - SQL Server 2005

It finally comes to this date, 12th April 2016, the end of support for SQL server 2005! SQL 2005 is...

Cloud Backup - Directly to Azure

Backup is one of the major task for DBAs, it has many different options and ways for each companies to...

SQL server on Linux

Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...

Installation of SQL Server (Part 2 - Post-installation)

Previously we discussed about the pre-installation consideration, which can be found here. In the second part of this series, we...

Installation of SQL Server (Part 1 - Pre-installation)

I have been wanting to write this for a long time, and finally got time to do it. Which is...

Parallelism setting in SQL Server – reduce CXPACKET waits?

This is one of the hot topic within the DBA community, what should be the best setting for parallelism in your environment? The answer is – it depends! J

Let’s...