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...
2016-07-04
472 reads
I am so excited and happy to be chosen to receive the Microsoft Data Platform MVP award. This is my...
2016-07-04
472 reads
In case you haven't heard, SQL server 2016 is generally available today! If you haven't try it out, you should...
2016-06-02
833 reads
Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance...
2016-05-27 (first published: 2016-05-19)
1,518 reads
In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure,...
2016-04-15 (first published: 2016-04-11)
2,189 reads
It finally comes to this date, 12th April 2016, the end of support for SQL server 2005! SQL 2005 is...
2016-04-12
644 reads
Backup is one of the major task for DBAs, it has many different options and ways for each companies to...
2016-04-07
1,624 reads
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,246 reads
Previously we discussed about the pre-installation consideration, which can be found here. In the second part of this series, we...
2016-03-01
1,447 reads
I have been wanting to write this for a long time, and finally got time to do it. Which is...
2016-02-29 (first published: 2016-02-23)
2,580 reads
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...
2016-01-13
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Ed Elliott
In my previous blog post I talked about how to read from an XML...
I have a DAG between On prem and Azure. We have a maintenance window...
How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...
Is there any way to do that? I need to list that kind of...