SqlServerKudos

Analysis

1
kudos

Kudos

Church stages flower festiva

published 10 days, 5 hours, 19 minutes ago posted by

quick11 19 days, 13 hours, 58 minutes ago

Submit New Story Url: Title: Description:hide preview Tags:(optional, separate by comma for multiple tags) Category: Analysis Community Management News Query Reporting Security Warehousing (more)

category: Analysis | clicked: 1 | comment | | source: sqlserverkudos.com

1
kudos

Kudos

Ozziemedes on SQL Server: Perfect Information vs. Chaos

published 14 days, 5 hours, 34 minutes ago posted by

http://ozziemedessql.blogspot.com/ 23 days, 17 hours, 56 minutes ago

Ozziemedes on SQL Server: Perfect Information vs. Chaos

Buck Woody recently posted an interesting blog item on the perils of expecting "perfect information" for economic modelling. My response follows. Information can theoretically be perfect, but it's existence relies on the assumption of a completely deterministic (rational) universe. I think we'd all agree that human behaviour is often so complex as to describe it as irrational, so all economic models necessarily have some sort of fuzz factor when you apply them to the real world. Asimov spoke a lot ab... (more)

category: Analysis | clicked: 0 | comment | | source: ozziemedessql.blogspot.com

tags: Chaos Theory, Information Entropy, Perfect Information, The World We Live In, Underlying Assumptions

2
kudos

Kudos

Improving cell security performance in SSAS - Some Random Thoughts

published 75 days, 10 hours, 6 minutes ago posted by

jacobsebastian 85 days, 8 hours, 55 minutes ago

Improving cell security performance in SSAS - Some Random Thoughts

Now this one was in the coming for quite some time. All of us who have tried to implement cell security would have had some or the other woes to relate with performance. At least for me, the MDX query which I had beautifully tuned to come out in 2 sec suddenly became an embarrassment in the form of a hideously slow 2 min query the moment I switched over to a security based role. And this blog is a direct result of my quest to understand how SSAS works beneath my mean machine (yeah, my laptop is damn cool!). (more)

category: Analysis | clicked: 0 | comment | | source: beyondrelational.com

2
kudos

Kudos

Creating solution file from a SSAS database - Some Random Thoughts

published 77 days, 10 hours, 16 minutes ago posted by

jacobsebastian 85 days, 8 hours, 57 minutes ago

Creating solution file from a SSAS database - Some Random Thoughts

In many of my projects, I have heard my developers asking each other whether it is actually possible to get the solution file of a SSAS database and I have turned a deaf ear to almost all the cases in spite of knowing the answer. Now before you give me that flabbergasted look, let me try to justify my position. (more)

category: Analysis | clicked: 1 | comment | | source: beyondrelational.com

2
kudos

Kudos

Implementing measure security in SSAS 2008 - Some Random Thoughts

published 83 days, 10 hours, 40 minutes ago posted by

jacobsebastian 93 days, 7 hours, 43 minutes ago

Implementing measure security in SSAS 2008 - Some Random Thoughts

Recently, I was asked to implement security on a set of sensitive measures, such as profit and all calculated measures on top of them as part of the cube development. It looked like a very straight requirement and I never thought I would have so many sleepless nights over it for the next 2 months. My very first way of thinking was using the default Microsoft cell security, where I would define a read-contingent policy for the sensitive measures. If you do not define an explicit read-contingent policy, t... (more)

category: Analysis | clicked: 0 | comment | | source: beyondrelational.com

1
kudos

Kudos

Understanding SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF « ranjithk's blog

published 92 days, 11 hours, 21 minutes ago posted by

ranjithk 99 days, 11 hours, 1 minute ago

Understanding SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF « ranjithk's blog

These are the two widely used SET options in SQL Server. Most developers explicitly set these options while creating Stored Procedures, Triggers and User Defined Functions but many are unclear on why we need explicitly SET them? and Why these two are special compared to other options? (more)

category: Analysis | clicked: 2 | comment | | source: ranjithk.com

1
kudos

Kudos

Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 3

published 312 days, 6 hours, 25 minutes ago posted by

sa 322 days, 1 hour, 54 minutes ago

Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 3

I recently wrote two articles on MDX in SQL Server Analysis Services Exploring MDX (Multi Dimensional Expression) in SQL Server Analysis Services Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 2 This is the third and final part of the series and we will explore some additional functions of MDX: 1. IIF functions returns one of the possible two values in a logical test. It can return either a string or numeric value. WITH MEMBER MEASURES.[IIF V... (more)

category: Analysis | clicked: 1 | comment | | source: www.sqlservercurry.com

tags: MDX, SSAS

1
kudos

Kudos

The cost of SSAS metadata management

published 339 days, 6 hours, 28 minutes ago posted by

sa 344 days, 3 hours, 42 minutes ago

This post will explain how we found ourselves in a situation where when processing a partition the metadata checks took 50 times longer than the actual partition and how to identify what time penalty you are incurring for the metadata checks. The system i was investigating had around 80 cubes with around 100 partitions per cube all hosted in one database and we would add 1 partition per cube per day. The partitions in each cube were small but were taking far to long to process and as each da... (more)

category: Analysis | clicked: 1 | comment | | source: sqlblogcasts.com

tags: Analysis Services, Performance, SSAS, Tips

1
kudos

Kudos

Announcing “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services”

published 362 days, 8 hours, 5 minutes ago posted by

sa 370 days, 13 hours, 50 minutes ago

Announcing “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services”

I’m pleased to announce that, after a lot of effort and late nights, the book that Marco Russo, Alberto Ferrari and I have been working on has finally been published! It’s called “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services” and, basically, it’s a book about building cubes with Analysis Services 2008. So no surprises there then… Why should you buy this book? There are a lot of other, rea... (more)

category: Analysis | clicked: 4 | comment | | source: cwebbbi.spaces.live.com

tags: BIDS, Book, Cube, MDX, SSAS

1
kudos

Kudos

Media Business Intelligence - Decentrix and BIAnalytix - Part 1

published 365 days, 7 hours, 45 minutes ago posted by

sa 369 days, 1 hour, 38 minutes ago

Media Business Intelligence - Decentrix and BIAnalytix - Part 1

In this episode, Kirk Evans talks with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcasters, cable operators, and telcos in the US. We talk about why BI matters, how BI is not simply providing reports in a transactional application, and we learn more about Decentrix and their BIAnalytix offering. I learned a lot during this interview about the importance of B... (more)

category: Analysis | clicked: 0 | comment | | source: channel9.msdn.com

tags: BI, Excel, Excel 2007, Excel Services, MOSS, MOSS2007, Office, SharePoint, SQL 2008, SQL Server 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services

1
kudos

Kudos

Move non clustered indexes to a new filegroup « Data Realized – The Blog

published 366 days, 7 hours, 49 minutes ago posted by

http://datarealized.wordpress.com/ 369 days, 4 hours, 21 minutes ago

Move non clustered indexes to a new filegroup « Data Realized – The Blog

So, over the years I have needed to move an index or a set of indexes to a new or different file group. I’ve written scripts for this in the past and lost them along the way and I couldn’t find anything out there on the bing or google interwebs. The concept of multiple files and file groups for a database is beginning to sink in with a lot of developers and dba’s. The rationale for using them is typically sound and in my experience it’s one of wanting to decrease the internal file fragmentation of the d... (more)

category: Analysis | clicked: 9 | comment | | source: datarealized.wordpress.com

tags: file groups, index management, SQL Server 2005

1
kudos

Kudos

The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes

published 366 days, 7 hours, 49 minutes ago posted by

http://datarealized.wordpress.com/ 369 days, 4 hours, 15 minutes ago

The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes

This is one of those topics I planned to blog about a long time ago, but never actually got around to it, and consequently I keep having to hit search engines to find the code I provided in a forums post when I need to use it again. A while back, I helped fellow SQL enthusiast Jeremiah Peschka (@peschkaj) out via twitter with finding plans that included missing index information in them. Then a bit later I used the same code on a Forums Post and then again with Michelle Ufford (@sqlfool) who actually t... (more)

category: Analysis | clicked: 0 | comment | | source: sqlblog.com

tags: analysis, Performance, plan cache, SQL Server 2005, SQL Server 2008

1
kudos

Kudos

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

published 368 days, 7 hours, 51 minutes ago posted by

sa 369 days, 1 hour, 17 minutes ago

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

In this episode, host Kirk Evans talks with Dr. Michael Ludwich, VP of Consulting at Decentrix, where Dr. Ludwich provides a demonstration of the BIAnalytix solution. This quite an interesting demonstration, helping to show the value of BI in a media organization. In Part 1 of this interview, we talked with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcaste... (more)

category: Analysis | clicked: 0 | comment | | source: channel9.msdn.com

tags: BI, Excel, Excel 2007, Excel Services, Office, SharePoint, SQL 2008, SQL Server, SQL Server 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, SSAS, SSIS, SSRS

1
kudos

Kudos

SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure

published 370 days, 4 hours, 26 minutes ago posted by

sa 370 days, 13 hours, 44 minutes ago

SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure

A few weeks ago I did a post introduced the ExecuteSQL .net stored procedure for SSAS. Chris Webb asked if this function can be called from Excel 2007 when it is set this up as a rowset action and I figured that this would make a good topic for a blog post. So the following screen shots show how you would go about setting up such an action. As a quick example I cheated a bit and set up an Rowset action that calls the sp_who2 system stored procedure. This way I did not have a depedancy on any particular d... (more)

category: Analysis | clicked: 1 | comment | | source: geekswithblogs.net

tags: ASSP, Codeplex, SSAS, Stored Procedures

Welcome!

Analysis

Church stages flower festiva

Ozziemedes on SQL Server: Perfect Information vs. Chaos

Improving cell security performance in SSAS - Some Random Thoughts

Creating solution file from a SSAS database - Some Random Thoughts

Implementing measure security in SSAS 2008 - Some Random Thoughts

Understanding SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF « ranjithk's blog

Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 3

The cost of SSAS metadata management

Announcing “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services”

Media Business Intelligence - Decentrix and BIAnalytix - Part 1

Move non clustered indexes to a new filegroup « Data Realized – The Blog

The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure

Open ID Login

Standard Login

Forgot Password?

Sign up