.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

SSAS newbie question

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
Hi Guys, I come from a SAP BW background, and i was wondering if i need to learn SSIS and SSRS together with SSAS in order to get a job? A insight into the current job market would also be helpfful. Thanks!

View Complete Post

More Related Resource Links

connection string question from a newbie


when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"

Total newbie question: Calling jQuery in an UpdatePanel?



Please forgive this ignorant question - I've used ASP.NET AJAX a good deal but I'm new to jQuery.  Specifically, is it possible to call or create jQuery events on the fly via an UpdatePanel?  For example, calling a jQuery modal or animating a Label (or <div> contained Literal), etc.

If anyone has any advice or could point me to some easy tutorials on mixing ASP.NET AJAX and jQuery, I'd greatly appreciate it. 



Dynamically adding User Controls -- newbie question!

I am new to ASP.NET (coming from ColdFusion, thank goodness I'm away from that!).  And I am have THE hardest time understanding how to work with forms in ASP.NET.  Here's what I am doing:Dynamically add User Controls to a PlaceHolder based on some int value (which currently is passed in a HiddenField).Fire an event if the WebControls inside of the User Control change, then handle that event in the Main Page (i.e. save the input to DB)When the user clicks the "Next/Continue" button, the next controls for the next page are loaded.And I guess maybe I just can't seem to get how things work in ASP.NET, because I am really struggling with the general idea of how ASP.NET flows.  Should I be dynamically loading the controls in Page_Init, or Page_Load?  Or should I load the controls when the buttonclick event is fired?Do I have to add the axCtrl.OnDataChange += new EventHandler(HandleAxControlDataChange); line on Page_Load?  Or should I put this in When I first load the UserControl, I need to initialize some WebControls within the UserContorl.  Is there a way to know if I have loaded new user controls into my placeholder?  I can't use Page.IsPostback, because after the first page, every page is a postback from the buttonclick.Any help for this confused newbie would be GREATLY appreciated!!Here's what I have: pu

Newbie question about embedding videos, etc.

I know how to use the web part to insert a video which works just fine. What I don't know is how I can configure/design a page which I can display several videos with explanatory texts next to them, much like this page:  http://sharepoint.microsoft.com/en-us/Pages/Videos.aspx I know it's a total newbie question, but I guess I gotta start somewhere!

Newbie question...

Hi Guys i  need to ask a question about dimensions and cubes: Does the cube only consist of the fact table, or does it consist of the dimensions and the fact table? Thanks in advance

Newbie question about adventureworks database


Hi Guys,

I downloaded the Adventurworks2008 database and the AdventureworksDW2008 database for practice with SSIS.  I was wondering what the difference between the two databases is, because in the exercises im following it is stating that i will need to extract data from  the Adventureworks2008 database to the AdventureworksDW2008 database.

Is the the AdventureworksDW2008 an empty database and we are just extracting OLTP data to it? Please any help in clarifying this will be highly appreciated. Thanks!

newbie question: change login name of dbo user


My database has a user "dbo" which is dbo of all database objects. The login name for this user is e.g. "Login1". Now I need to change the login name for user "dbo" from "Login1" to a new login name "Login2".

It is not possible to change the related login name of the user "dbo" in the user's properties dialog. And it is also not possible to change or remove the dbo relation in the login name's properties dialog (because a dbo user can not be removed).

Is there any possibility to change the login name of an dbo user? How can I do it?

Newbie User Import Question re: One way external trust & Security



There is a business initiative to install a Dev Sharepoint 2007 server in our Trusting Domain. My internal corp network will be Corp.COM. The 3rd party network will be 3rd.COM.  Currently 3rd.COM has a Oneway External Trust pointing inward to Corp.com.  Corp.COM Domain and Forest levels are WIndows 2003. 3rd.com Domain level is Windows 2000 Mixed and the Forest is Windows 2000.

The Dev sharepoint server is located in 3rd.Com domain and the consultant is trying to import Corp.com users by pointing the user profile connection to Corp.com active directory. Needless to say this will fail because there is a one way trust in place so 3rd.com users are allowed to read Corp.Com active directory. Not to mention there are no firewall ports open for this anyway. My questions are...

How can we securely allow this sharepoint server to import in 3rd.com to import users from Corp.com?

Ideally we would like to use a service account from Corp.com to import the accounts. We would also like to either

(A) encrypt the sharepoint servers communication to our Corp.com active directory. because there are Two firewalls between the trust ports would be specifically opened from Sharepoint server <-> Corp.com DC

(b) some how use the existing trust to facilitate this procedures. no additional ports opened on the firewalls.

Any ass

Newbie question re: asp.net textbox + jquery change event


Hello guys,

I thought I was coding a change event correctly, yet somehow i'm not getting any result

I made the simplest of examples to accomplish what i want

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script type="text/javascript" src="jquery-1.4.2.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <form id="form1" runat="server">
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

Newbie question: Relationship between an ASP.NET app and WF 4



I'm really interested in implementing WF that will work in/with my ASP.NET/C# Web Forms 4 app to define workflows for a lot of corporate activities -- ranging from user registration to submitting an expense report. I'm trying to understand how the interaction will work.

Am I correct to assume that:


  1. I create an WCF Workflow Service Application project in Visual Studio and define a set of activities and workflows.
  2. In my ASP.NET application logic, I make calls to this WCF Workflow Service app to determine the next step in my corporate activities e.g. once the user registration is completed, send user notification to fill out his/her user profile, etc. In effect, I'm using the ASP.NET app as an UI piece to my WCF logic.
I'd appreciate your feedback in helping me understand how the two will work together.


Thanks, Sam

newbie question on MVC



I have the following code snippet from MvcMusicStore tutorial:

    public class StoreController : Controller
        // GET: /Store/

        public string Index()
            return "Hello from Store.Index()";
        // GET: /Store/Browse
        public string Browse()
            return "Hello from Store.Browse()";
        // GET: /Store/Details
        public string Details()
            return "Hello from Store.Details()";

        public string Details(int id)
            string message = "Store.Details, ID = " + id;
            return Server.HtmlEncode(message);

When I called the action : /store/details/2

I got:

The current request for action 'details' on controller type 'StoreController' is ambiguous between the following action methods:
System.String Details() on type MvcMusicStore.Controllers.StoreController
System.String Details(Int32) on type MvcMusicStore.Controllers.StoreController 

According to tutorial, this should work. I am using MVC2.


Newbie question about SQl code and SSIS


Hi Guys,

Im coming from a SAP Datawarehouse background and i don't know much about sql queries or statements. I was wondering if i need this knowledge to learn SSIS, and if so in what situations?

Thanks in advance

Another newbie question about ObservableCollection and DataGrids


Hi All again,


I have a few questions and problems again... I found that if I want to search in a datagrid I have to define datagridview. Is it right?http://msdn.microsoft.com/en-us/library/ff407126.aspx

I have a generated class called EntityDB which properties are used in my datagrid and which porperties are get via webservice. In my previous topic I get help about how to use the ObservableCollection. If I want to define a datagridview in tha above link I found that I have to define my class as an inherited class from ObsevableCollection. As my class is generated I shouldn't modify it by hand to be an inherited class.

I think I should define a class at client side which will inherite from ObservableCollection and somehow in that class I should handle my original properties from EntityDB. What do you think about it? How would you do this?

An other question about the example in the msdn link above:

In that exam

Newbie Intelligencia.UrlRewriter expression question. (ASP.NET)


Hey guys!

I need help with something that should be relatively simple.

Got the component installed in my project fine and added all of the necessary config entries.

I need to rewrite URLs following two rules (for canonilization/SEO purposes):

1 - all URLs that don't have "www" need to be rewritten to include it. Example: user types in mypage.com/about/, should go to, and show up as www.mypage.com/about/

2 - Redirect any links that look like www.mypage.com/contact/index.aspx to www.mypage.com/contact/

Thanks you very much!

NEWBIE : Network Shortcut question


Hi all,


Crossposting this to SBS and Sharepoint forums ...


First, I'm relatively new to these forums and to MS server technologies in general. I may well use the wrong terminology, so please forgive and feel free to correct me. I'm currently working (sprinting !) towards MCP as a Small Business Specialist and am enrolled on the fantastic SBSC 70-282 series of seminars. We haven't got to Sharepoint yet, but I'm reading ahead ...


SBS2003 includes Windows Sharepoint Services - version 2.0 I think so that's the version I'm working with. I have an old server at home I'm using for test and it's all set up fine, no problems. My question is about working with Sharepoint. When I have a document open in, say, Office 2007 - what's the easiest way to save that document into a Sharepoint folder ? How does it know which document library to put it in and what attributes to give it ? Does it get the metadata from the document itself ?


More specifically, I'm using the bobwired Sharepoint facility to access documents related to my course. Having done that, I now have a "network shortcut" which points me to that extranet resource. I'd like to enable something similar inhouse. So, for example, I create a spreadsheet for my monthly accounts and I want to file it not under a shared directory but under Sharepoint.

Newbie Question about Web Services


Hi I'm learning Sharepoint and doing exercises in a text book (Sahil Malik - Apress).

I have a site  http://spdev/sites/SiteCollection1

I am creating a custom field type which calls a web service which is part of the solution

The web service seems to be created at the root http://spdev/_vti_bin

So my code in the sub site is calling code in a webservice which does the following code


Newbie question on MVVM in WPF


Hi group,
I have a generic question about MVVM in WPF. I downloaded the MVVM toolkit from codeplex and the tutorial is great, but I'm wondering which is the best way of handling more realistic scenarios involving more editing. Say I have a totally fake scenario like this:


Let's assume a Guy class like:

public class Guy {
 public string FirstName {get;set;}
 public string LastName {get;set;}

also, let us add a Team class containing a name, some guys and also a dictionary with key=room number and value=office name for the offices of that team:

public class Team {
 public string Name {get;set;}
 public List<Guy> Guys {get;}
 public Dictionary<int,string> Rooms {get;}


We wrap the Guy in a VM like:

public class GuyViewModel : ViewModelBase {
 private readonly Guy _guy;
 public GuyViewModel(Guy guy) { _guy = guy; }
and we expose its properties using OnPropertyChanged notifications like:

 public string FirstName
  get { return _guy.FirstName; }
  set { _guy.FirstName = value; OnPropertyChanged("FirstName"); }
 This way a WPF-based view can use databinding to link to Guy's data.
 Now for the Team: our VM would require to expose a couple of editab

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend