The year 2014 was amazing and I had a great time learning and sharing knowledge. I must thank you my dear readers for your constant support and motivation. I have been blogging every single day for over 8 years and this is only possible because of your help. Today is the last day of the year and from tomorrow we will start strong and will have a new year. Many will make resolutions and many resolutions will break. Here is what I have learned about resolutions – it is hard to keep them up most of the time. Anyway, I just wanted to thank you for amazing Year 2014.

Here are a five videos from my SQL in Sixty Seconds Series. Let me know which one is your favorite.
We will continue our journey in blogging in the year 2015.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.


5 Comments. Leave new
Pinal,
Your consistency is inspirational…A lot to learn from you. Happy New Year to you!
SQL Server 2014 Live Plan for Query
Thanks Calvin.
Hi All,
when i execute the job for cube refreshment,sometimes it is executing successfully,but sometimes it is getting failed with below error
Started: 4:08:08 AM Error: 2015-01-14 04:55:21.03 Code: 0xC11D0005 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Transaction errors: The lock operation ended unsuccessfully because of deadlock. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:08:08 AM Finished: 4:55:21 AM Elapsed: 2832.18 seconds. The package execution failed. The step failed.
If any find the solution please post on it.
Thanks
Rambabu
Looks like that’s SSAS package. I would suggest to post on MSDN SQL forums.