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

---

I've listened to some code items while driving, and it's interesting. However, I can't learn. I can only get interested. I need to re-listen later...

Your decision between table variable or temp table should depend on the data access pattern of your query.

Generally speaking, table variables are best applied in OLTP stored procedures where you...

I hate "security questions". If I'm a hacker and want to know your grandfather's first name or your mother's mainden name, I can just go to ancestry.com. If I want...

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