Steve Jones - SSC Editor (2/22/2016)

---

g.britton (2/19/2016)

---

In our case, our VCS is in a different, untrusted domain from production servers. So, while the idea has some merit, we would...

Thanks for the link to TeamCity. I'll check it out later (Flash is blocked for us)

Phil Parkin (2/19/2016)

---

g.britton (2/19/2016)

---

Working in a DW environment, my biggest challenge is coordinating databases, SSIS packages and SQL Agent Jobs. Most integrated VCSes do an admirable job on the...

Working in a DW environment, my biggest challenge is coordinating databases, SSIS packages and SQL Agent Jobs. Most integrated VCSes do an admirable job on the database side, but...

In our case, our VCS is in a different, untrusted domain from production servers. So, while the idea has some merit, we would likely not have any direct way...

SQLNightOwl (2/16/2016)

---

Not all companies have the benefit of having a Data Steward. I've done this for a number of years for both large and small companies. My experience...

SQLNightOwl (2/16/2016)

---

g.britton (2/16/2016)

---

There's an easier way:

1. Set up a date table (aka DimDate) (examples abound: google is your friend)

2. Have a yearly process to update the table with new...

There's an easier way:

1. Set up a date table (aka DimDate) (examples abound: google is your friend)

2. Have a yearly process to update the table with new info (e.g....

lnoland (2/12/2016)

---

Great article. Thanks for sharing.

I have used CTE's on a number of occasions to cure slow-running queries but in my case I believe they worked for entirely different...

lsmith 90637 (1/16/2015)

---

A word of caution regarding CTEs.

I have run into problem with using CTE's against very large tables, especially in the 2008 line of SQL Servers, where the can...

Here come da fuzz!

Your output proves that the question is correct. And the explanations, though using different...

Carlo Romagnano (1/28/2016)

---

I disagree with explanation:

CHECK evaluates only true (accepted) or false (rejected) expression not UNKNOWN (accepted).

From BOL:

CHECK...

You didn't mention the Integration Services Data Profiling task (AFAICS). It does a lot of what you show out of the box, including candidate keys. It also ...

jsaskey (1/25/2016)

---

To the debate on Python vs. PowerShell, I would add the following.

PowerShell is engineered for maintenance of the Windows enterprise. The use of "cmdlets" makes it more of...

I haven't worked up a detailed comparison, but I'll start here:

Python is rightly called "easy to...