Wednesday, 11 April 2012

A story of a failed exam.

The Microsoft's SQL Server 2012 beta exam 71-464 has failed. Yes, the exam, or rather Prometric, not me.

Yesterday morning I went to an Authorized Prometric Testing Centre ready to sit the beta exam. It was all going well until the actual exam. The time has come, I clicked the 'start' button and an error message popped up.

Tuesday, 10 April 2012

T-SQL Tuesday #029 - Analytic Functions in SQL Server 2012

I took the last few days to review the new features of SQL Server 2012 in preparation for the beta exams  I will sit very soon. About many of them I read before but some still came as a nice surprise (better now than on the exam I suppose).

If I am to choose one useful feature of SQL Server 2012 to write about today it must be the Analytic Functions in T-SQL and improved OVER clasue. The LAG, the LEAD and the OVER which I would call a sapper tools for dealing with time bomb coding techniques, especially the triangular joins. Let me present