SqlServerKudos

http://road-blogs.blogspot.com/

Name:	http://road-blogs.blogspot.com/
Score:	55
Last Seen:	86 days, 13 hours, 4 minutes ago
Member Since:	22 April, 2010

2
kudos

Kudos

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

published 77 days, 14 hours, 44 minutes ago posted by

jacobsebastian 86 days, 14 hours, 22 minutes ago

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

In this post, Jason provides a quick overview of SSAS Dimension Attribute properties and provides a wonderful explanation of each property. (more)

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

tags: analysis, Cube, Data Mining, Data Warehousing, database, Dimension, SQLServer, SSAS

2
kudos

Kudos

Display Total on top of Stacked Chart - Some Random Thoughts

published 88 days, 15 hours, 35 minutes ago posted by

jacobsebastian 97 days, 21 hours, 2 minutes ago

Display Total on top of Stacked Chart - Some Random Thoughts

It is a normal phenomenon that human beings take most of the simple things for granted. Take this case, one of my blog readers sent me a mail asking how to display the total on top of a stacked chart in SSRS. The first time I read it, I was almost going to blurt - just enable some property to display subtotals. But the more I thought about it, the more elusive the property became and that is when I realized there is no such property. So for the benefit of all, I thought about posting the workaround that ... (more)

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

tags: SQLServer, SSRS

2
kudos

Kudos

Auto-update of parameter datasets in SSRS 2008 - Some Random Thoughts

published 91 days, 15 hours, 49 minutes ago posted by

jacobsebastian 100 days, 17 hours, 20 minutes ago

Auto-update of parameter datasets in SSRS 2008 - Some Random Thoughts

The times I have spent with SSRS 2008 can be likened to that of a married couple’s life story. The moment I first laid my eyes on her during the Microsoft seminars and community previews, I knew that she was going to be the one. I secretly started collecting details about her, as much as possible and awaited her arrival. Needless to say, I was one of the very first to have the trial version installed and in the dates that followed, I was just astounded at her potential – she seemed so full and promising.... (more)

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

2
kudos

Kudos

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

published 95 days, 16 hours, 6 minutes ago posted by

jacobsebastian 104 days, 19 hours, 35 minutes ago

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

Many times, it can happen that we end up writing very complex MDX expressions revolving sets. To simplify such expressions or to improve the performance of some queries, we can extract the definitions of some sets into a separate named set expression which are called named sets. A named set can be created either using a CREATE SET statement or a WITH SET statement (For syntax, refer Building Named Sets in MDX). In SQL Server 2005, there was only the Static named sets feature but in SQL Server 2008, both ... (more)

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

tags: MDX, SSAS

2
kudos

Kudos

Creating navigation panel for reports - Some Random Thoughts

published 106 days, 16 hours, 56 minutes ago posted by

jacobsebastian 113 days, 21 hours, 21 minutes ago

Creating navigation panel for reports - Some Random Thoughts

This post explains how to create navigation panels for SSRS 2008 reports. (more)

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

2
kudos

Kudos

Creating solution file from a SSAS database - Some Random Thoughts

published 117 days, 17 hours, 44 minutes ago posted by

jacobsebastian 125 days, 16 hours, 25 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

Improving cell security performance in SSAS - Some Random Thoughts

published 115 days, 17 hours, 35 minutes ago posted by

jacobsebastian 125 days, 16 hours, 23 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

How to add a Document Map to your reports - Some Random Thoughts

published 111 days, 17 hours, 15 minutes ago posted by

jacobsebastian 118 days, 21 hours, 27 minutes ago

How to add a Document Map to your reports - Some Random Thoughts

This post explains how to add a document map to your SSRS report. (more)

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

4
kudos

Kudos

SQL Server 2008 R2 Released (RTM) – Download it or try the Hosted version from PASS! - SQL Server Community Blogs

published 131 days, 18 hours, 45 minutes ago posted by

jacobsebastian 140 days, 21 hours, 24 minutes ago

SQL Server 2008 R2 Released (RTM) – Download it or try the Hosted version from PASS! - SQL Server Community Blogs

SQL Server 2008 R2 is officially released. See this post for a number of resources to help you to get started with SQL Server 2008 R2. (more)

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

tags: sqlserver r2

4
kudos

Kudos

SELECT INTO is faster than CREATE & INSERT

published 131 days, 18 hours, 45 minutes ago posted by

ashishgilhotra 140 days, 19 hours, 28 minutes ago

SELECT INTO is faster than CREATE & INSERT

This article explain Why SELECT.. INTO is faster than CREATE and INSERT... (more)

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

4
kudos

Kudos

SQL Server - Case Sensivity and Accent sensivity determined by a Collation

published 131 days, 18 hours, 45 minutes ago posted by

ashishgilhotra 140 days, 19 hours, 40 minutes ago

SQL Server - Case Sensivity and Accent sensivity determined by a Collation

Sql server 2005/2008 support Unicode characters so you can present your data in any language so for example if your Database collation is (a Latin) and you want to store Arabic language words ,you need to define Unicode data type columns like(nchar,nvarchar,ntext) to stored your data properly and to avoid the question marks problem (???) except if your database collation is Arabic and in this case it does not need to define your columns as a Unicode type because you can use the type like(char,varchar,tex... (more)

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

4
kudos

Kudos

TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database

published 126 days, 18 hours, 24 minutes ago posted by

ashishgilhotra 136 days, 12 hours, 45 minutes ago

TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database

The challenge is to write a query that returns the articles to be displayed in the home page of the website. (more)

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

3
kudos

Kudos

FOR XML Workshop – Understanding FOR XML RAW

published 130 days, 18 hours, 40 minutes ago posted by

ashishgilhotra 140 days, 16 hours, 39 minutes ago

FOR XML Workshop – Understanding FOR XML RAW

This post explains how to generate XML documents using FOR XML RAW from TSQL (SQL Server) (more)

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

3
kudos

Kudos

Too many indexes, Is it a problem?

published 130 days, 18 hours, 40 minutes ago posted by

ashishgilhotra 140 days, 17 hours, 35 minutes ago

We discussed in previous posts, how important to create index on your tables or views. However, next question will come to you what is number of indexes that you can create or will the be a performance decrease on number of indexes you create? In all... (more)

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

2
kudos

Kudos

Scope of temporary tables across procedures - Madhivanan's TSQL Blog

published 123 days, 18 hours, 9 minutes ago posted by

jacobsebastian 133 days, 15 hours, 12 minutes ago

Scope of temporary tables across procedures - Madhivanan's TSQL Blog

Can we use the temporary table created in one procedure from another procedure? The answer depends on how you call the procedure Take this example Create a temporary table in a procedure (more)

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

2
kudos

Kudos

Implementing measure security in SSAS 2008 - Some Random Thoughts

published 123 days, 18 hours, 9 minutes ago posted by

jacobsebastian 133 days, 15 hours, 11 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

2
kudos

Kudos

If you don’t know any thing of Indexes of your databases… - Dinesh Asanka

published 123 days, 18 hours, 9 minutes ago posted by

jacobsebastian 133 days, 15 hours, 11 minutes ago

If you don’t know any thing of Indexes of your databases… - Dinesh Asanka

Having discuss indexes in some what details, this post will give some queries to get the index information of you databases. Ok, if you are a DBA, most of the time you need to manage some others databases. In my carrier, it is only few occasions where I was given task to design fresh database. All the other occasions, it is managing heritage databases, which you can’t avoid. (more)

category: Management | clicked: 5 | comment | | source: beyondrelational.com

3
kudos

Kudos

DotNetShoutout - SQL Server – Issues with generating XML using string operations

published 125 days, 18 hours, 19 minutes ago posted by

ashishgilhotra 134 days, 15 hours, 18 minutes ago

DotNetShoutout - SQL Server – Issues with generating XML using string operations

Building XML documents using string functions – concatenating XML tags and embedding values between them using string operations – is not a recommended method. This post tries to look into some of the problems this approach can bring in.. (more)

category: Query | clicked: 1 | comment | | source: dotnetshoutout.com

2
kudos

Kudos

Report selection in parameter toolbar - Some Random Thoughts

published 124 days, 18 hours, 14 minutes ago posted by

jacobsebastian 133 days, 15 hours, 14 minutes ago

Report selection in parameter toolbar - Some Random Thoughts

The MSDN forum has been the inspiration for most of my blogs, but in all those cases, I was sure that I could attain the end result and my blogs were usually a graphical step by step depiction of what needs to be done, so that I could post it as an answer to the question. But this blog is quite different, I almost wrote a no saying that it is not possible. And that was when I decided to give it a try before replying No :) (more)

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

tags: SQLServer, SSRS

3
kudos

Kudos

Adding breadcrumbs to your drillthrough reports

published 133 days, 18 hours, 55 minutes ago posted by

ashishgilhotra 140 days, 16 hours, 45 minutes ago

Adding breadcrumbs to your drillthrough reports

This post shows a trick that helps you to build breadcrumbs in SSRS drill through reports. (more)

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

Welcome!

http://road-blogs.blogspot.com/

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

Display Total on top of Stacked Chart - Some Random Thoughts

Auto-update of parameter datasets in SSRS 2008 - Some Random Thoughts

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

Creating navigation panel for reports - Some Random Thoughts

Creating solution file from a SSAS database - Some Random Thoughts

Improving cell security performance in SSAS - Some Random Thoughts

How to add a Document Map to your reports - Some Random Thoughts

SQL Server 2008 R2 Released (RTM) – Download it or try the Hosted version from PASS! - SQL Server Community Blogs

SELECT INTO is faster than CREATE & INSERT

SQL Server - Case Sensivity and Accent sensivity determined by a Collation

TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database

FOR XML Workshop – Understanding FOR XML RAW

Too many indexes, Is it a problem?

Scope of temporary tables across procedures - Madhivanan's TSQL Blog

Implementing measure security in SSAS 2008 - Some Random Thoughts

If you don’t know any thing of Indexes of your databases… - Dinesh Asanka

DotNetShoutout - SQL Server – Issues with generating XML using string operations

Report selection in parameter toolbar - Some Random Thoughts

Adding breadcrumbs to your drillthrough reports

Open ID Login

Standard Login

Forgot Password?

Sign up