Content Preview: rss
36 days ago
I am preparing a demo for User Group in UK of how F# can used with Business Intelligence. Frankly speaking I don’t know the end result but as I go along I am going to keep blogging about what I am learning in F# with simple examples. The aim is to have a series of blog post on this new language (something like I have done for ADO.NET entity Framework on http://csentities.wordpress.com ) which will serve as a quick start guide and possibly will open up areas of discussion where I will be using F# with BI to add the power of functional programming into Business Intelligence. I will be using VS 2010 (I have a Beta 2 Ultimate as of now but the code should work with VS 2008 and fsi.exe). So Lets go ahead and start a new Blank Solution Now lets go ahead and add a new F# console application. Now Open the program.fs and paste the code given below in it. open System let a = 2 Console.WriteLine(a) Console.Read() Now if you hover over the Console.Read() you ...
60 days ago
I got a email today at 4:00 PM from Microsoft MVP award which read Dear Ashwani Roy, Congratulations! We are pleased to present you with the 2009 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in SQL Server technical communities during the past year I would like to thank UK SQL Server Community , my blog readers my peers and friends and I hope I will keep adding value to community.
60 days ago
[Old post reposted as I was not very happy with the formatting] Have a look at this query 1: WITH 2: MEMBER [Measures].[REFUNDS] AS [Measures].[Internet Sales Amount] – [Measures].[Internet Sales Amount] * .4 3: MEMBER [Measures].[PROFIT] AS [Measures].[Internet Sales Amount] – [Measures].[REFUNDS] 4: MEMBER [Product].[Product].[Top10] AS 5: sum ( 6: TOPCOUNT([Product].[Product].[Product].MEMBERS 7: , 10 8: , [Measures].[Internet Sales Amount] 9: ) 10: , 11: ([Measures].CurrentMember) 12: ) 13: MEMBER [Product].[Product].[Top10PercOfTotal] AS [Product].[Product].[Top10]/[Product].[Product].[ All Products] 14: SELECT 15: { 16: [Measures].[Internet Sales Amount], 17: [Measures].[REFUNDS], 18: [Measures].[PROFIT] 19: } ON COLUMNS, 20: { 21: [Product].[Product].[Top10] 22: ,[Product].[Product].[Top10PercOfTotal] 23: ...
65 days ago
SSAS 2008 has improved Dimension and Aggregation Designer, new Attribute Relationship Designer, Optimize performance with block computations mode and dynamic management views for enhanced resource monitoring.SSRS 2008 reports has the unique data format of Tablix which allows writing reports with combined advantage of Table and Matrix formats. It can integrate with Microsoft Office SharePoint Server 2007 for central delivery and management of business insight. It also enables users to quickly gain insight into complex sets of data by displaying data graphically with enhanced visualization capabilities. Performance has improved drastically for situations where you are generating large reports. SSIS Pipeline is optimized to enable more parallel loading of data. You can write script components in C# now. It comes with improved scalability with thread pooling and enhanced lookup transformations. It also performs more functional and scalable data transfers with the improved SQL Server ...
98 days ago
The evening's agenda includes the following presentations (see Events section for more details): What's new in SQL Server 2008 for BI Presented by Ashwani Roy, MCTS MCITP MCAD MCP We're also pleased to let you know that SQL Server MVP, Simon Sabin will be presenting. Details about this presentation will be made available shortly. Location: Bank Of America 5 Canada Square London E14 5AQ United Kingdom Register @ http://www.sqlpass.org.uk/
