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...

Does anyone know if DOS style (character mode) apps will run, or can be written for, Windows Core Edition?

I recently left a job I held onto in the healthcare industry for nine years for a new position working in the retail industry. My old job had become too...

What is the compromise; are they installing Core Edition?

Parallel I/O aside, it's worth mentioning that files and file groups can be backed up, restored, detached, attached separately, which can potentially decrease downtime for very large databases when performing...

To start, you want all accounts to be operating under least privilege. Look at what logins have sysadmin, dbo, or db_datareader access. The following script will lust what accounts, domain...

Not only does full disk encryption protect your data in the event of theft, it also renders the device practically unusable or at least the thief now has to invest...