CK2 (1/28/2014)

---

Just to add to what has already been said.

If you can, do the MS Certifications. I know people rag on them a lot but in cases where you...

The data warehouse is like any other traditional warehouse. But, the data marts have to be rebuilt nightly due to the business needs for reporting. Unfortunately, not every company has...

ps_vbdev (1/8/2014)

---

Both good points well made. first one answers my question on scaleability but also second one explains why the ETL's ive seen before do a drop of the DW...

I never touch the data source if I don't have too. I would make the new fact with a copy of the existing dimensions plus the addition of the new...

I'm developing my first ETL system, so take this with a grain of salt.

The way I planned my ETL system was according to "The Data Warehouse Toolkit" by Ralph Kimball....

kwoznica (1/17/2014)

---

Does anyone know of any bug tracking software the Microsoft produces?

It seems that TFS isn't very conducive for this type of function.

If not, then what bug tracking applications...

You mean that SSRS is blocking you from this attempt?

I shouldn't point the finger at the developer as much. There is also a great deal of pressure from those in management to push out results quicker at the sacrifice...

saifmahatab (1/23/2014)

---

Hi

I am new in SQL server so I need desperate help in doing Unit Testing for bunch of stored procedure that I wrote. So my manager told me to...

Here is one way that I was just working on when I read your post. :w00t:

Remember, INSERT INTO when the table exists. Use SELECT INTO when it does not and...

I just added this to my ETL system for reporting as I was looking to add a new one when you wrote the article. I had a basic one before...

Grant Fritchey (1/22/2014)

---

Depending on your location, I'd suggest finding the nearest user group and the nearest SQL Saturday event. Those two places will enable you to begin to network with...

I simply say, "I turn chaos into smart and beautiful logical solutions."

On that note, this could be why:

Cubes can be very complex objects for users to explore in Microsoft SQL Server 2005 Analysis Services. A single cube can represent the contents...

It's possible the data set I have is a straight duplicate of a OLAP engine. If that's the case, can it go into a data warehouse at that point? Or...