It sounds like you're describing some specific implementation of unit testing within SSDT or Visual Studio.

Unit Testing a stored procedure, generally speaking, is when you execute a stored procedure using...

Michelle-138172 (8/23/2016)

---

I have a db that has huge data but simple tables. I want to set up a job to back up the db structure only without the data. What's...

I havn't used eBay in years, but I recall from the past that it was possible to simply drill down on another user's ID and see a history of auctions...

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