Search Results: Data Warehousing

• 
  Crescent IT Solutions Offers Online Training & Placement on all Software related Business Courses

  Crescent IT Solutions which is a high profiled Training Institute offers you SAP(All Modules), Oracle Applications, People Soft, MS.NET, JAVA, QA Testing, QTP, TIBCO, SQL Server, Data warehousing, Business Analyst, PHP, Online Training for the students wh

  Author:  crescentitsolutions     Date: 2/24/2012     Section: Blog

  tags : Data Warehousing Online Training, Oracle Online Training
• 
  Introduction to Parallel Data Warehousing

  What are we talking about? Recently Microsoft released a new version of SQL Server 2008 R2 called Parallel Data Warehouse Edition. there has been a lot of buzz about this new architecture because it is Microsoft’s entry into the Massive Parallel Processin

  Author:  AdamJorgensen     Date: 7/29/2010     Section: Blog

  tags : Parallel Data Warehousing, PDW
• 
  HIVE on HDInsight: First Glance

  Hive Introduction Within the Hadoop ecosystem, you can use HDFS to load and store data and MapReduce to do both simple and hardcore processing. One of the missing pieces to the puzzle that is familiar to data warehousing professionals is the ability to in

  Author:  cprice1979     Date: 4/7/2013     Section: Blog

  tags : Hadoop, HDInsight, Hive
• 
  Upcoming Free Education from Pragmatic Works

  It's been a great month of free education from Pragmatic Works. The recordings from the previous ones are now posted and I have one on Tuesday on SQL Server Data Warehousing Fast Tracks. Check out all the information below: June 22, 2010 View Recording Po

  Author:  BrianKnight     Date: 6/27/2010     Section: Blog

  tags : performance point, powershell, sharepoint, sql server fast track, ssis, webinar
• 
  SQL Server Parallel Data Warehouse (Madison) Introduction

  This article covers the basics of the PDW (Parallel Data Warehouse Architecture) and dives into why it is a good fit for some organizations. Adam also jumps in and discusses creating some new object types in this new type of environment.

  Author:  AdamJorgensen     Date: 8/7/2010     Section: Article

  tags : Madison, Parallel Data Warehouse, SQL Server Data Warehousing, PDW
• 
  Free videos on Learn Microsoft BI

  I stumbled across this site today that contains very useful videos on Microsoft BI tools. There are 39 videos of which I have listed the top five from their site here The first video is a twelve minute introduction entitled "What is Business Intelligence?

  Author:  indupriya     Date: 11/25/2010     Section: Blog

  tags : Business Intelligence videos, Microsoft BI vidoes
• 
  When Pigs Fly: An apache pig introduction

  In previous posts, we have looked at what it takes to get started with with Hadoop on Windows using HDInsight. We also looked at Hive, which is the data warehousing framework built on top of Hadoop. In this post, we will dig a little deeper into the Hadoo

  Author:  cprice1979     Date: 4/15/2013     Section: Blog

  tags : Hadoop, HDInsight, Pig
• 
  Building a Record of History From SAP Source For Your SQL Server Data Warehouse

  If you have ever worked with SAP as a SQL Server developer, you understand that it can be challenging. Recently I was working on a data warehousing project that featured SAP as the data source for our data warehouse. We needed to be able to create a recor

  Author:  DustinRyan     Date: 3/4/2011     Section: Blog

  tags : CTE, data warehouse source query from SAP, SAP source
• 
  Splitting Raw Files to Fill in Missing Date Ranges

  Actually solved it myself: Cursors. A little unexpected, but it works great. Went through 21K part numbers in a little over 5 minutes. So to do the entire Inventory table will be an hour. If anyone has other ideas of how to do this quickly is SSIS, I'm st

  Author:  aabundez     Date: 8/26/2011     Section: Forum

  tags : Cursors, Data Warehousing
• 
  Basic Design Question For Data Warehouse

  I just watched the training last week about starting with Cubes and Data Warehousing of the data. I develop medical software and I need clarification between a Dimension and Fact tables. When developing the warehouse for the purpose of creating cubes, I h

  Author:  owhite     Date: 8/24/2010     Section: Forum
• 
  24 hours PASS in September 2010

  The 2nd instalment of 24 hours of PASS is in September and below are the details. Join an exceptional lineup of SQL Server and BI experts from around the world as they present a sneak peek of PASS Summit 2010 in 24 free live webcasts September 15-16. This

  Author:  indupriya     Date: 8/11/2010     Section: Blog

  tags : SQL PASS, PASS
• 
  SSIS Denali Resolve References

  One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z) is the new resolve reference functionality that was brought into the product from the Parallel Data Warehousing team. Resolve references is solvin

  Author:  DevinKnight     Date: 11/15/2010     Section: Blog

  tags : Denali, SSIS
• 
  PASS Data Warehousing/Business Intelligence Virtual Chapter Presents:SSRS R2: The New Stuff

  I will be presenting at The Pass Virtual conference, check it out. http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=480

  Author:  MikeDavis     Date: 9/16/2010     Section: Blog

  tags : PASS, SSRS
• 
  SAS vs Microsoft (data warehouse)

  Hi, I have an opportunity to move toward the data warehousing. I also have a choice of SAS or Microsoft. Which would you pick and why? Also do you think it is wise to move from Software Development to data warehousing? thanks.

  Author:  rv7a99cv     Date: 11/29/2010     Section: Forum
• 
  Data Warehousing, BI Stack and Columnstore Indexes Oh My!

  Today we delved into my favorite parts of the SQL DBMS world which is data warehousing and the Business Intelligence stack. It was a stellar day and I learned much more than what is in the book we have sitting in front of us next to our laptops because ou

  Author:  nreed     Date: 9/20/2012     Section: Blog
• 
  SQL Server 2008 R2 - Free ebook

  Microsoft has released an ebook named -- " Introducing Microsoft SQL Server 2008 R2 , by Ross Mistry and Stacia Misner!" The book contains 10 chapters and 216 pages, like so: PART I Database Administration CHAPTER 1 SQL Server 2008 R2 Editions and Enhance

  Author:  indupriya     Date: 5/6/2010     Section: Blog

  tags : learning, sqlserver 2008 R2 ebook
• 
  My SQL PASS PreConference

  I'm getting very excited about PASS in November. I started to work on my pre-conference session ETL and SSIS BootCamp and got especially jazzed this week. We got permission to use some pretty amazing data to really show some real-world scalability tricks

  Author:  BrianKnight     Date: 9/14/2010     Section: Blog

  tags : events, SQL PASS
• 
  SSAS - Preserve Measure Null Values

  Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in measure data of a fact table. You may have unknown foreign keys from your dimension data but even those unknown foreign keys relate

  Author:  DevinKnight     Date: 2/28/2011     Section: Blog

  tags : SSAS
• 
  SQL Saturday Pensacola

  If you happen to be in the area of Pensacola this weekend, say Saturday, then you should hop on over to Pensacol State College, Main Campus, 1000 College Blvd, Pensacola, FL 32503. That just happens to be the location of SQL Saturday that will be held thi

  Author:  BradSchacht     Date: 6/1/2011     Section: Blog

  tags : SQL Saturday
• 
  Be the Master of your Data Warehouse Universe at SQLRally!

  Do you have a data warehouse initiative in your current organization and looking for a way to learn how to properly build and support it? Would you like to learn how to do this straight from the Masters of the BIverse themselves? Well you're in luck! Next

  Author:  sqlchicken     Date: 4/14/2011     Section: Blog

  tags : business intelligence, conference, data wareho, data warehousing, event, pre-con, training, sqlrally
• 
  PASS Data Warehousing/Business Intelligence Virtual Chapter Live Meeting Sessions

  Quick hit mid-week folks! Make sure not to miss the BI Virtual Chapter’s Presentation of Data Mining with PowerPivot with Mark Tabladillo. http://bi.sqlpass.org/ The Summary of his talk is: “Excel provides a compelling and ubiquitous interface for Microso

  Author:  AdamJorgensen     Date: 9/6/2010     Section: Blog

  tags : PASS BI Virtual Chapter
• 
  Day 3 - Pragmatic Works Webinar Series

  Hey Guys and Gals ! If you missed the webinars today, you missed a great show! Brian took us through the fundamentals of SSIS and getting started with this exciting product. SSIS is such a powerful tool, not just for ETL and data warehousing, but for envi

  Author:  AdamJorgensen     Date: 2/24/2010     Section: Blog

  tags : Webinars
• 
  Road Trip with MDX Series (Intro to MDX Structures)

  In this intro to MDX we will cover Dimensions, grains, measures and tuples

  Author:  MikeMollenhour     Date: 12/30/2009     Section: Article
• 
  Great Post from Jamie Thompson

  Hey there Gang ! Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting since Jamie is always a great source for SSIS and BI info. I wanted to share a post of his that provides a script method for clearing you

  Author:  AdamJorgensen     Date: 11/23/2009     Section: Blog

  tags : Data Warehousing, SSIS, Bloggers
• 
  SAS vs Microsoft (data warehouse)

  I do work on data warehousing and I actually train other on how to do it as well using the Microsoft stack. http://www.pragmaticworks.com/services/training/Default.aspx

  Author:  DevinKnight     Date: 11/30/2010     Section: Forum