The value of a developer's time is relative to whatever else they could be working on at that very moment in time. For example, if you have an active data...

Microsoft SQL Server Data Tools (SSDT) is a free download, and it has features for schema comparison, data comparison, and scripting DDL/DML for the differences.

Today, you shouldn't communicate anything in an email that you wouldn't want posted publicly on Facebook. Plausible deniability is why a lot of confidential conversations take place on the golf...

In recent years, the underlying tools (BIDS, SSDT, VS, etc.) provided by Microsoft to support BI development are more stable than Microsoft's overall BI development game plan. Standing alone, they...

Jeff Moden (1/8/2016)

---

Alvin Ramard (1/8/2016)

---

Jeff Moden (1/8/2016)

---

I especially hate it when a Developer that doesn't know, creates tables using Visual Studio or has VS auto-magically create the tables from objects...

If you routinely encounter source data feeds containing dates formatted as strings (ie: MMDDYYY), then you may want to consider implementing a calendar reference table containing multiple variations of key...

Go to YouTube and search on Wise Owl Tutorials; they have a lot of great step-by-step video series for SSIS, SSRS, and SSAS and then even more subscription based material...

Yes, "an untidy collection of things piled up haphazardly" described a heap table. By definition, a heap...

First, confirm if the query plans used by individual statements in fact differ in a significant way from the plans used when contained within a stored procedure. As for root...

Hugo Kornelis (1/11/2016)

---

Eric M Russell (1/11/2016)

---

This smells like healthcare claims data. If so, then "userpolicyid" is something like PayerID + SubscriberID + DependentID, and the format is not coded consistently...

Alvin Ramard (1/11/2016)

---

Eric M Russell (1/11/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to...

That's not a T-SQL question.

Phil Parkin (1/11/2016)

---

ROWVERSION (aka TIMESTAMP) is not ANSI standard, so it's implemented differently on each RDMS, but each has a similar concept. For...

You probably already know this, and you didn't specifically mention SCD or if this is a MERGE versus straight INSERT into Destination, but avoid using the SSIS Slowly Changing Dimension...

Once you gain experience with one .NET language, learn the framework and GUI, it's earier to learn another .NET language. For example, a C# developer probably could ramp up on...