(Anil) After such a long time , I would like to post some another blog which might be helpful to the one who works in SQL.

(Wayne Robertson) As part of the SQL Server 2012 release several changes were made to Analysis Services that should alleviate some issues previously seen on large NUMA node machines.

(Deepak Choudhari) To read Environment variables in T-SQL, you can use the xp_cmdshell extended stored procedure in SQL Server.

(Jason Thomas) I am pretty sure that most of you would have heard or read about this at least once in your SSAS career, but how many of you actually do set slices for your partitions? Well, I am also guilty of the charge and seldom did set slices till a recent issue.

(Arshad Ali) It is not uncommon to have stored procedures returning result sets, and although it sounds like a good idea, it becomes a problem when you want to have control of the name of the columns and data type of the columns being returned as part of the result set.

(Siddharth Mehta) Distribution analysis is generally performed on quantitative data, by individually plotting data points on a graph. After plotting these points, visual clusters can be identified, which also helps in outliers analysis. This methodology is generally useful when data points are plott

(Beth Stackpole) Historically, there have been loads of security-related concerns related to running key applications in the cloud, particularly essential systems. And some would-be users of Microsoft’s SQL Azure cloud-based database service are still holding back, but not because of any gaps in SQL

(Nacho Alonso Portillo) The INSTEAD OF INSERT Triggers topic in the documentation describes the following:

(Jason Thomas) Do you know how it feels like to hear an old song and have a whole lot of memories come flooding back to you? Well, something sort of similar happened to me today. I was doing my weekly reading and going through a brilliant post by Microsoft MVP – Greg Galloway (blog).

(Robert Young) The relational model was devised long before computer hardware was able to support an RDBMS that could deliver, without performance deficit, a fully normalized database. Now, with reliable SSDs falling in price, we can reap the benefits, instead of getting distracted by NOSQL with its