Search Results: Quest

• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  Hierarchies in SSAS Multidimensional: What’s really happening up (or down) in there?

  A few days ago I got an interesting question. The question was “When you build an hierarchy in SSAS, what’s actually happening to it on disk?” As in, how does the file system actually place it in files so it can easily identify the hiera

  Author:  ChrisSchmidt     Date: 3/5/2013     Section: Blog

  tags : hierarchies, natural hierarchy, unnatural hierarchy
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  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
• 
  SSIS Merge with Duplicate Rows

  The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The question arises, what about duplicate records. These duplicates do not get eliminated. Here are two tables with the ID 5 and the name Br

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

  tags : Duplicate, isSorted, Merge, Rows, Sort, Sorted, SortKey, SSIS
• 
  Can’t Access Report Manager

  I want to thank one of my more recent students for giving me blog topic. I am not going to mention names, so thank you……… Hopefully, you are reading this and know who you are. After his question, I thought to myself, SELF I should share this with the WOOO

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

  tags : Pragmatic Works, Report Manager, SSRS, Sherri McDonald
• 
  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