Rowan-283474 (8/22/2016)

---

Eric M Russell (8/22/2016)

---

Rowan-283474 (8/22/2016)

---

Unfortunately delta operations aren't possible as the source is line of business type transactional records and there is no way to link up rows from...

There are a lot of good books on PowerShell. Some of them are domain specific like programming for SQL Server, Azure, or Active Directory.

robert.sterbal 56890 (8/22/2016)

---

I drive at least 40 minutes in each direction (33 miles each way) to work. Typically I'm listening to NPR or audiobooks. This morning I was listening to...

Rowan-283474 (8/22/2016)

---

Unfortunately delta operations aren't possible as the source is line of business type transactional records and there is no way to link up rows from my table back to...

Do you mean like while drive a car down the highway?

PowerShell is impressive in terms of it's use as a system integration tool; it can hook into almost any operating system function and is easily extensible.

However, when it comes...

I do agree with the previous David that the complexity and risks associated with deployment rollbacks can be mitigated by performing incremental releases, rather than bigger "bet the farm" deployments.

It's...

My understanding is that "adaptive data modeling" is basically the opposite of normalization. It's where you are not modeling entities upfront using fixed attributes, but rather have a data model...

I have a few thoughts:

1. Why truncate the table daily? Consider instead an incremental insert / update process.

2. If your queries share even one common predicate, then a...

I'm not sure that PowerShell standing alone will become popular amoung Linux and Mac users for their daily scripting needs, but what this will do is expand the portability and...

My 12 year old daughter will probably be posting the same question here a decade from now.

Steve Jones - SSC Editor (8/19/2016)

---

Eric M Russell (8/19/2016)

---

So, in a smoke test what you should really be looking for is not functionality... but smoke.

- If deploying a DDL...

A lot of us here became DBAs back when there weren't a lot of books on the topic. I'd start by looking at the eBooks published by Redgate and Brent...

So, in a smoke test what you should really be looking for is not functionality... but smoke.

- If deploying a DDL script, scroll through the output window and look...

My understanding is that, at least by default, when given a VARCHAR(MAX) column, SQL Server will only store the data offrow, if the total data size for a row doesn't...