Search Results: question

• 
  Interview Questions for MDX (MDX Interviews)

  I have written previous article on interview questions on SSAS . It has covered questions related to SSAS development, architecture and performance aspect except MDX so i am covering MDX interview questions in this post. Here is MDX questions list. I am d

  Author:  sirfnet     Date: 9/3/2011     Section: Blog

  tags : Interview questions on MDX
• 
  SSRS: AutoRefresh Property

  Report Services Auto Refresh Option In one of my Virtual Training classes that I taught, I had a student ask a question that I felt was a great question and would be good to share the answer with the community. T he question was, “How do I get my report t

  Author:  SMcDonald     Date: 6/2/2011     Section: Blog

  tags : Auto Refresh, AutoRefresh, Pragmatic Works, Sql Server Reporting Services, SSRS, Sherri McDonald
• 
  SSAS Interview Questions

  I was looking for some SSAS interview questions and found some very good resources on the web. The links are below. SSAS Interview Questions from Siddharth Mehta's blog Sql Server 2005 Analysis Services Interview Questions Dave Rodabaugh's Analysis Servic

  Author:  indupriya     Date: 1/5/2011     Section: Blog

  tags : SSAS Questions, SSAS interview questions
• 
  Copy and rename a file in SSIS using the File System Task

  "jampa.sb" asked a question about moving files around in SSIS using the File System Task and variables in the SSIS forum. Based on that question, I decided to put together a "Step-By-Step" walk through demonstrating how to do a portion of the issue. From

  Author:  KeithHyer     Date: 1/12/2012     Section: Blog

  tags : Copy and rename, File System Task, variable as expresion
• 
  Interview Questions for SQL Server Analysis Services (SSAS)

  I have received lot of mails from my readers for SSAS interview questions. This gave me idea to list down all the analysis services question here on my blog so everyone can be benefited. This question set is applicable for SQL server analysis service 2005

  Author:  sirfnet     Date: 9/3/2011     Section: Blog
• 
  Ranking Functions: ROW_NUMBER vs RANK vs DENSE_RANK vs NTILE

  *** Edited *** Videos now available with title Ranking Functions: http://www.sqlshare.com/profiles/26681/MarcoFrancisco.aspx In SQL Server there is 4 ranking functions: ROW_NUMBER Returns the rank of rows within the partition of a result set, without any

  Author:  marcoadf     Date: 2/4/2010     Section: Blog

  tags : dense_rank, ntile, rank, row_number, UEFA, ranking functions
• 
  Hierarchy with recursive CTE ( and a little borrowed sorting trickery )

  The Question I misread a question about a table that contains "Parent -> Child" data in the SSRS forums here on BIDN recently and I decided to attempt answering it. I thought it was a question that many of us have no doubt run across before - "how do y

  Author:  KeithHyer     Date: 10/25/2011     Section: Blog

  tags : ranking functions, Recursive CTE, Row_Number(), T-SQL
• 
  MCTS (70-448) and MCITP (70-452)

  In the last September 28th I've passed my 1st microsoft certification. In fact, I've passed 2 microsoft certifications!! Yes, I was able to do both certification exams in the same day. It was my very first experience in certification exams. I've got 1000/

  Author:  marcoadf     Date: 12/26/2011     Section: Blog

  tags : 70-448, 70-452, being, Certification, exams, Marco, marcoadf, MCITP, MCTS, measured, microsoft, skill, study, testking, training
• 
  Microsoft Business Intelligence Certification 70-448, SSIS, SSAS, SSRS

  I just passed the Microsoft BI certification test 70-448 on SSIS, SSAS, and SSRS. It was a tough test and covers all aspects of the Microsoft BI stack. I used a lot of different study materials. Here is my assessment of the study materials I used and whic

  Author:  MikeDavis     Date: 1/30/2010     Section: Blog

  tags : 70-448, Microsoft Business Intelligence, Preperation, SSAS, SSRS, Test, SSIS
• 
  Identity value in child tables

  Hi, Please advice how I can resolve my issue. I have this scenario: Migrating rows from development to staging. Same project will be used to move from staging to production. OC (Online Courses) (3 rows) (OnlineCourseId -- auto increment) OC - Modules (3 *

  Author:  wasay     Date: 9/5/2012     Section: Forum

  tags : autonumber, identity, module, onlinecourse, questions, quiz
• 
  Watch the BIDN.com Twitter Feed

  We're moving fast at the BI Developer Network (BIDN.com). In an effort to make sure you get your BI questions answered, we've installed a new twitter interface that if your question in our forums doesn't go answered after 2 days, it will escallated in a n

  Author:  BrianKnight     Date: 12/17/2009     Section: Blog

  tags : bidn, twitter
• 
  SSRS: Use single transaction when processing the queries

  September’s SSRS Classroom Question Today in our Day 1 SSRS class, a question was posed when we were setting up the Data Source. Question: “What is the Use single transaction when processing the queries?” Answer: You would use it to redu

  Author:  SMcDonald     Date: 9/20/2011     Section: Blog

  tags : Single Transaction when processing queries
• 
  Microsoft Integration Stack

  Note: This blog post has moved to : http://markgstacey.net/2013/02/12/microsoft-integration-stack/ Microsoft Integration Stack I am often asked the question about WHICH Microsoft technology to use when integrating systems, and it’s a very relevant q

  Author:  MarkGStacey     Date: 7/17/2010     Section: Blog

  tags : Integration, Service Broker, ssis, StreamInsight, Sync Framework, WCF
• 
  Creating Excel Worksheets Dynamically in SSIS

  Edit: This is not new content. I am reposting with corrected image links. "Studio72" asked a question in the SSIS forum that peaked my curiosity. In essence: Could a fixed data format with a variable number of rows be exported to Excel with one worksheet

  Author:  KeithHyer     Date: 2/7/2012     Section: Blog

  tags : Excel 2007, script component source
• 
  SSIS Data Types

  For all of its life, there have always been a lot of questions circulating around about data types in SSIS. What does an int in SQL map to in SSIS? What about a varchar? nvarchar? The questions could just go on and on. But, finally, we have an answer. In

  Author:  ChrisSchmidt     Date: 12/27/2012     Section: Blog

  tags : data types, ssis, SSIS 2012, ssis data types
• 
  how to use parameter label as database named in dataset

  As far as I understand from your problem, you have 2 databases and you want to select data from one table wich has the same name in both databases. Question: Can you select data from both tables when connected to the default database? Can this be a soluti

  Author:  marcoadf     Date: 1/15/2012     Section: Forum

  tags : database, Dataset, from, if, multiple, parameter, select, sp, Stored Procedure, table
• 
  SSISDB Reporting

  Thanks again to everyone who attended my session today on SSIS DB Reporting: Now What? At the end of the presentation there were several questions that came up that we didn’t have time to answer. Below is the Q&A from the session, I hope this an

  Author:  ChrisSchmidt     Date: 1/16/2013     Section: Blog

  tags : data flow performance, data taps, integration services catalog, SSIS 2012, ssis performance
• 
  The many facets of BI

  I recently had a client ask me to explain the different types of BI in SQL Server 2012, and explain what each tool could be used for and who the ideal target audience would be. I thought this would be a great blog post, as I’ve heard this question p

  Author:  ChrisSchmidt     Date: 11/28/2012     Section: Blog

  tags : BI, Corporate BI, PerformancePoint, Power View, PowerPivot, SSAS Multidimensional, SSRS, Team BI
• 
  Analysis Services Webinar Recording and Q&A

  I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013. If you weren’t you can now download the recording here . Because I covered new material all the way to the end of the webinar i thought I'd also an

  Author:  DevinKnight     Date: 4/2/2013     Section: Blog

  tags : Analysis Services, Multidimensional, PowerPivot, Tabular
• 
  A folder of PDFs as a data source

  This is an answer to a forum post, but since it was a bit lengthy, I thought it best to make a Blog post. The question The original question is here if you'd like to read up on it: http://www.bidn.com/forums/microsoft-business-intelligence/integration-ser

  Author:  KeithHyer     Date: 10/21/2011     Section: Blog

  tags : execute process, For Each Loop, image column, import column
• 
  Excel Data Load Truncation Error

  This article gives an explanation of and a solution to a truncation failure that can occur when loading from an excel data source. The engine that brings in the data will be examined and solutions will be laid out. There is a demonstration section that ca

  Author:  DanMatisis     Date: 7/18/2010     Section: Article

  tags : Data Load, Registry Keys, Truncation Error, TypeGuessRows, Excel Source
• 
  Sample Interview Questions for SSIS jobs

  I don't know about you, but for some reason, one of the most terrifying experiences for me is interviewing for a new job. There are a few things that you can do to prepare yourself for an upcoming interview and make it slightly less terrifying. You can wo

  Author:  kylewalker     Date: 4/6/2010     Section: Blog

  tags : Interview, SSIS
• 
  Load balancing SSAS Cube

  Have you tuned your attribute relationships before going this route? Do you use a lot of hierarchies in your cube? Sorry for the many questions but I'm curious as to what leads you down this path, I'm not disagreeing with you, obviously because I don't ha

  Author:  m3crast     Date: 5/4/2011     Section: Forum

  tags : load balancing, performance, ssas, tuning, ASLB
• 
  How to Fix the Economy, or How One Company is Helping People Look Forward

  Terry Brown How to Fix the Economy or, How One Company is Helping People Look Forward Well, how do we do it? If there were a simple answer to that question, then depressions would be an obsolete phenomenon. Unfortunately, there is not even a consensus as

  Author:  TJ.Brown     Date: 10/25/2011     Section: Blog

  tags : community, Economy, microsoft, Reporting Services 2008, T-SQL
• 
  Stored Proc: xp_cmdshell to exec dtexec utility

  Update: Sql Agent Job runs a T-Sql query that executes via xp_cmdshell, the SSIS package then imports data into the table. That's the theory, tested doesn't work. Question: can Sql Agent Job execute xp_cmdshell? Eliminations: -- Tested SSIS package with d

  Author:  JohnG     Date: 7/29/2010     Section: Forum

  tags : SQL Agent Job, Stored Procedure, sql agent job