Year: 2011

Recently I had to use MDX Studio for some MDX query tuning. 2 quick tips: Latest download link for MDX Studio can be obtained from the support forum at http://ssas-info.com/forum/3-mdx-studio/ The earlier versions of MDX Studio are referenced from Mosha’s website at http://www.mosha.com/msolap/mdxstudio.htm Also very quickly, if you are finding that the Perfmon section in…

I found these links today in response to a customer question around ‘real world’ benchmarks for financial applications running on SQL Server. These benchmarks describe the TEMENOS T24 Core Banking system, which is probably as ‘real world’ as it gets. http://blogs.technet.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-85-48-Files/4617.Benchmark-Results-for-Temenos-T24–with-SQL-Server-2008-R2-on-Intel_2D00_based-NEC-Servers.pdf http://download.microsoft.com/download/B/2/3/B23E0B02-AA00-4921-8A76-B4384B6197DD/sql-temenos-t24.pdf

I’ve recently started learning about SQL Server Parallel Data Warehouse (PDW) appliance. In the course of learning, I came across some links and resources in connection with this appliance, which I will share in this blog post. I will keep it updated as much as possible. Learning resources: Start your learning by looking at the…

My colleague and friend, boB Taylor (the spelling is not a typo – please visit http://www.opsvault.com/meet-our-contributors and see why) has recently released a GUI tool which allows you to configure the XML files required for SQLDiag to capture specific types of events, counters etc.) Download it from http://sdct.codeplex.com Please review, test, blog about it…

A long time ago, I had blogged about the perils of ‘wildcard’ query patterns. As a response to one of the comments in that post, I learnt about a new optimization introduced in SQL 2008 wherein the OPTION (RECOMPILE) hint would help in these kind of cases. Ever since then, I had used this in…

Recently we were struggling with trying to figure out how to suppress the address bar for a popup window opened using JavaScript’s window.open method. Normally, there is an option there which allows you to specify ‘location=no’ and the address bar is expected to be hidden. However, no matter what we tried, this did not work…

My team, Premier Field Engineering (India) recently created a group on LinkedIn (http://www.linkedin.com/groups?gid=3761475&trk=hb_side_g) which we will use to share our experiences, upcoming offerings, career opportunities and more. Membership is open to all, so I welcome you to take this opportunity to connect with us!