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
SqlServerKudos
atom rss
2
kudos
spam Kudos Remove

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

published 77 days, 14 hours, 44 minutes ago posted by jacobsebastianjacobsebastian 86 days, 14 hours, 22 minutes ago
Thursday, June 24, 2010 12:41:12 PM GMT Tuesday, June 15, 2010 1:03:29 PM GMT
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
spam Kudos Remove

Display Total on top of Stacked Chart - Some Random Thoughts

published 88 days, 15 hours, 35 minutes ago posted by jacobsebastianjacobsebastian 97 days, 21 hours, 2 minutes ago
Sunday, June 13, 2010 11:50:28 AM GMT Friday, June 04, 2010 6:22:44 AM GMT
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
spam Kudos Remove

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

published 91 days, 15 hours, 49 minutes ago posted by jacobsebastianjacobsebastian 100 days, 17 hours, 20 minutes ago
Thursday, June 10, 2010 11:35:38 AM GMT Tuesday, June 01, 2010 10:04:40 AM GMT
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
spam Kudos Remove

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

published 95 days, 16 hours, 6 minutes ago posted by jacobsebastianjacobsebastian 104 days, 19 hours, 35 minutes ago
Sunday, June 06, 2010 11:19:29 AM GMT Friday, May 28, 2010 7:50:04 AM GMT
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
spam Kudos Remove

Creating navigation panel for reports - Some Random Thoughts

published 106 days, 16 hours, 56 minutes ago posted by jacobsebastianjacobsebastian 113 days, 21 hours, 21 minutes ago
Wednesday, May 26, 2010 10:28:52 AM GMT Wednesday, May 19, 2010 6:04:15 AM GMT
This post explains how to create navigation panels for SSRS 2008 reports. (more)
category: Reporting | clicked: 0 | comment | | source: beyondrelational.com
2
kudos
spam Kudos Remove

Creating solution file from a SSAS database - Some Random Thoughts

published 117 days, 17 hours, 44 minutes ago posted by jacobsebastianjacobsebastian 125 days, 16 hours, 25 minutes ago
Saturday, May 15, 2010 9:40:39 AM GMT Friday, May 07, 2010 10:59:58 AM GMT
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
spam Kudos Remove

Improving cell security performance in SSAS - Some Random Thoughts

published 115 days, 17 hours, 35 minutes ago posted by jacobsebastianjacobsebastian 125 days, 16 hours, 23 minutes ago
Monday, May 17, 2010 9:50:33 AM GMT Friday, May 07, 2010 11:01:44 AM GMT
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
spam Kudos Remove

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

published 111 days, 17 hours, 15 minutes ago posted by jacobsebastianjacobsebastian 118 days, 21 hours, 27 minutes ago
Friday, May 21, 2010 10:10:25 AM GMT Friday, May 14, 2010 5:58:25 AM GMT
This post explains how to add a document map to your SSRS report. (more)
category: Reporting | clicked: 0 | comment | | source: beyondrelational.com
4
kudos
spam Kudos Remove

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 jacobsebastianjacobsebastian 140 days, 21 hours, 24 minutes ago
Saturday, May 01, 2010 8:40:08 AM GMT Thursday, April 22, 2010 6:01:31 AM GMT
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
spam Kudos Remove

SELECT INTO is faster than CREATE & INSERT

published 131 days, 18 hours, 45 minutes ago posted by ashishgilhotraashishgilhotra 140 days, 19 hours, 28 minutes ago
Saturday, May 01, 2010 8:40:08 AM GMT Thursday, April 22, 2010 7:57:02 AM GMT
This article explain Why SELECT.. INTO is faster than CREATE and INSERT... (more)
category: Query | clicked: 0 | comment | | source: beyondrelational.com
4
kudos
spam Kudos Remove

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

published 131 days, 18 hours, 45 minutes ago posted by ashishgilhotraashishgilhotra 140 days, 19 hours, 40 minutes ago
Saturday, May 01, 2010 8:40:08 AM GMT Thursday, April 22, 2010 7:44:52 AM GMT
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
spam Kudos Remove

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 ashishgilhotraashishgilhotra 136 days, 12 hours, 45 minutes ago
Thursday, May 06, 2010 9:01:20 AM GMT Monday, April 26, 2010 2:40:30 PM GMT
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
spam Kudos Remove

FOR XML Workshop – Understanding FOR XML RAW

published 130 days, 18 hours, 40 minutes ago posted by ashishgilhotraashishgilhotra 140 days, 16 hours, 39 minutes ago
Sunday, May 02, 2010 8:45:05 AM GMT Thursday, April 22, 2010 10:46:33 AM GMT
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
spam Kudos Remove

Too many indexes, Is it a problem?

published 130 days, 18 hours, 40 minutes ago posted by ashishgilhotraashishgilhotra 140 days, 17 hours, 35 minutes ago
Sunday, May 02, 2010 8:45:05 AM GMT Thursday, April 22, 2010 9:50:28 AM GMT
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
spam Kudos Remove

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

published 123 days, 18 hours, 9 minutes ago posted by jacobsebastianjacobsebastian 133 days, 15 hours, 12 minutes ago
Sunday, May 09, 2010 9:16:12 AM GMT Thursday, April 29, 2010 12:13:00 PM GMT
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
spam Kudos Remove

Implementing measure security in SSAS 2008 - Some Random Thoughts

published 123 days, 18 hours, 9 minutes ago posted by jacobsebastianjacobsebastian 133 days, 15 hours, 11 minutes ago
Sunday, May 09, 2010 9:16:12 AM GMT Thursday, April 29, 2010 12:13:47 PM GMT
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
spam Kudos Remove

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

published 123 days, 18 hours, 9 minutes ago posted by jacobsebastianjacobsebastian 133 days, 15 hours, 11 minutes ago
Sunday, May 09, 2010 9:16:12 AM GMT Thursday, April 29, 2010 12:14:31 PM GMT
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
spam Kudos Remove

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

published 125 days, 18 hours, 19 minutes ago posted by ashishgilhotraashishgilhotra 134 days, 15 hours, 18 minutes ago
Friday, May 07, 2010 9:06:17 AM GMT Wednesday, April 28, 2010 12:06:43 PM GMT
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
spam Kudos Remove

Report selection in parameter toolbar - Some Random Thoughts

published 124 days, 18 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 133 days, 15 hours, 14 minutes ago
Saturday, May 08, 2010 9:11:15 AM GMT Thursday, April 29, 2010 12:11:29 PM GMT
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
spam Kudos Remove

Adding breadcrumbs to your drillthrough reports

published 133 days, 18 hours, 55 minutes ago posted by ashishgilhotraashishgilhotra 140 days, 16 hours, 45 minutes ago
Thursday, April 29, 2010 8:30:15 AM GMT Thursday, April 22, 2010 10:39:40 AM GMT
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
Previous 1 2 Next