DotNetShoutout - User : jacobsebastian

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

jacobsebastian

Name:	jacobsebastian
Score:	4,772.5
Last Seen:	411 days, 6 hours, 57 minutes ago
Member Since:	6 April, 2010

4
Shouts

Shout it

Creating solution file from a SSAS database

posted by

jacobsebastian 1108 days, 22 hours, 4 minutes ago

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: Data | clicked: 1 | comment | | source: beyondrelational.com

3
Shouts

Shout it

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

posted by

jacobsebastian 1108 days, 22 hours, 5 minutes ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

4
Shouts

Shout it

Implementing measure security in SSAS 2008 - Some Random Thoughts

posted by

jacobsebastian 1108 days, 22 hours, 6 minutes ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

2
Shouts

Shout it

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

posted by

jacobsebastian 1108 days, 22 hours, 7 minutes ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

3
Shouts

Shout it

Report selection in parameter toolbar

posted by

jacobsebastian 1108 days, 22 hours, 10 minutes ago

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 :) To give a background of the problem, the user wants to display the list of reports... (more)

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

7
Shouts

Shout it

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

posted by

ashishgilhotra 1118 days, 20 hours, 23 minutes ago

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

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

6
Shouts

Shout it

SSIS 2005 - Sample SSIS Packages - Sudeep's Domain

posted by

http://rajsudeep.blogspot.com/ 1130 days, 3 hours, 48 minutes ago

Some sample packages that you could use. (more)

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

tags: For Each loop, MSBI, Expressions, SSIS

6
Shouts

Shout it

SSIS - Assigning variables in Script Component - Sudeep's Domain

posted by

http://rajsudeep.blogspot.com/ 1130 days, 3 hours, 49 minutes ago

How to assign System variables to user variable in SSIS Script component to be used later. Have a look. (more)

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

tags: MSBI, SSIS, Script Component, Variables

5
Shouts

Shout it

SSIS - Dynamic file connection in SSIS using for each loop - Sudeep's Domain

posted by

http://rajsudeep.blogspot.com/ 1130 days, 3 hours, 51 minutes ago

How do we loop through different files whose path is saved in a SQL Table. Have a look. (more)

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

5
Shouts

Shout it

SSIS - Expressions - Sudeep's Domain

posted by

http://rajsudeep.blogspot.com/ 1130 days, 3 hours, 52 minutes ago

This post shows the use of expressions one of the most useful aspects of SSIS. There are sample expressions as well that you could use. (more)

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

tags: Expressions, casting, SSIS

5
Shouts

Shout it

SSIS - Using DB Mail to send HTML format mail - Sudeep's Domain

posted by

http://rajsudeep.blogspot.com/ 1130 days, 3 hours, 54 minutes ago

This post shows how we can send HTML format mail from SSIS without using any 3rd party tool. (more)

category: Data | clicked: 2 | comment | | source: beyondrelational.com

tags: DB Mail, MSBI, SSIS, Send Mail task

11
Shouts

Shout it

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

published 1122 days, 22 hours, 9 minutes ago posted by

ashishgilhotra 1123 days, 3 hours, 25 minutes ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

4
Shouts

Shout it

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

posted by

ashishgilhotra 1123 days, 4 hours ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

5
Shouts

Shout it

SSRS reports using embedded images

posted by

ashishgilhotra 1123 days, 4 hours, 2 minutes ago

This post demonstrates how to use embedded images on your report based on a condition... (more)

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

4
Shouts

Shout it

SELECT INTO is faster than CREATE & INSERT

posted by

ashishgilhotra 1123 days, 4 hours, 3 minutes ago

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

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

5
Shouts

Shout it

Too many indexes, Is it a problem?

posted by

ashishgilhotra 1123 days, 4 hours, 4 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: Data | clicked: 0 | comment | | source: beyondrelational.com

6
Shouts

Shout it

Adding breadcrumbs to your drillthrough reports

published 1124 days, 22 hours, 20 minutes ago posted by

ashishgilhotra 1126 days, 4 hours, 54 minutes ago

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

category: Data | clicked: 4 | comment | | source: beyondrelational.com

5
Shouts

Shout it

FOR XML Workshop – Understanding FOR XML RAW

published 1124 days, 22 hours, 20 minutes ago posted by

ashishgilhotra 1126 days, 4 hours, 52 minutes ago

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

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

4
Shouts

Shout it

SET NOCOUNT ON

posted by

ashishgilhotra 1126 days, 4 hours, 51 minutes ago

This post explains the advantages of using SET NOCOUNT ON in stored procedures. A must read for SQL Server developers and DBAs (more)

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

5
Shouts

Shout it

Referencing an assembly inside SSIS script task

published 1124 days, 22 hours, 20 minutes ago posted by

ashishgilhotra 1126 days, 4 hours, 45 minutes ago

This post explains how to use a custom assembly inside SSIS script task. (more)

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

DotNetShoutout