A quick Google search for (+"SQL SERVER" +SSDT +PowerShell + Automation) did not turn up anything useful except for answered inquiries in Microsoft forums stating that it's not supported at...

The data comparison feature you're using in Visual Studio; is that the same thing as the SQL Server Data Tools plugin? I've found an MSDN article which seems to suggest...

ZZartin (12/17/2015)

---

Eric M Russell (12/17/2015)

---

Sean Redmond (12/17/2015)

---

It is the over-compartmentalisation that does it. I was a year into a job as a DBA and I had gotten a grip on...

Back in the late 1980's, I worked for a retailer that would require the customer to show their drivers license whenever they presented a credit card or check. If the...

Sean Redmond (12/17/2015)

---

It is the over-compartmentalisation that does it. I was a year into a job as a DBA and I had gotten a grip on what was to be...

Using a technique similar to what I've done below, you can exit the main procedure should the elapsed runtime of a sub-procedure call exceed a specific duration. You'll want the...

You can check the application's .config file, but to know for sure what database servers are accessed by the application, you can query the Default Trace on each instance, filtering...

Also, confirm if SSIS / SSRS / SSAS or something like an AntiVirus service may be running on the box alongside SQL Server. Except for a high volume OLTP database,...

Beatrix Kiddo (12/16/2015)

---

Yet Another DBA (12/15/2015)

---

Unfortunately too many companies see frequent job changes as detrimental. I cant remember which of the forums veterans it was who made the comment that...

What you're currently doing uses a fixed set of comparison values with dynamic SQL. But what you really need is a fixed SQL statement supporting a dynamic set of values....

Don't stop/restart the SQL Server service or you will lose cached diagnostic metrics which is essential for diagnosing this type of issue using DMV queries.

This step is optional, but if...

Jeff Moden (12/15/2015)

---

larskandersen (12/15/2015)

---

Just to expand on Jeff’s “upsert“ comment for future reference.

This pattern can be replaced with a single “Upsert” on the source and destination table. I find...

jeffrey yao (12/15/2015)

---

Steve Jones - SSC Editor (12/15/2015)

---

Yet Another DBA (12/15/2015)

---

Unfortunately too many companies see frequent job changes as detrimental. I cant remember which of the forums veterans it was...

Kimball recommends that facts of different grain, like event level facts rolled up to month level, should be contained in a separate fact table. But it seems this month rollup...

The best tool for identifying and protecting PHI is a comprehensive and accurate Data Dictionary. For example, both an automated tool and a developer can easily overlook the fact that...