Craig-315134 (8/22/2013)

---

Eric M Russel wrote:

Implementing business logic using a middle tier compenent, web service, or even a stored procedure solves the problem of data validation for applications, but not for...

pdanes (8/22/2013)

---

Doctor Who 2 (8/22/2013)

---

I like what you wrote here, Steve, but I wonder how practical it is. However, it might just be my work environment. Having worked in a...

below86 (8/21/2013)

---

As a developer I have to disagree. 🙁 ...

Andy Warren (8/22/2013)

---

I love abstraction, but I only use it when I get to the place where it's needed to solve the problem. I've seen the view for everything approach...

eccentricDBA (8/21/2013)

---

I find this editorial interesting because over a decade ago I the development team I was working on had this exact discussion.

I was a developer at that time and...

In addition to implementing views as a means of rrestricting user access to columns and rows, I've also used them as a wrapper for tables that contain symmetric key encrypted...

Gary Varga (8/20/2013)

---

Eric M Russell (8/20/2013)

---

Gary Varga (8/20/2013)

---

Of course, some users don't help themselves or the rest of us. There are always a small minority who will claim that the...

Gary Varga (8/20/2013)

---

Of course, some users don't help themselves or the rest of us. There are always a small minority who will claim that the issue they are raising is...

There is perhaps one advantage that you as an employer have when you're paying an employee more than he's worth... you have leverage. The employee can't easily bail and get...

djackson 22568 (8/19/2013)

---

Not a fan of Oracle right now. I understand that they no longer...

When it comes to complaints leveled against Microsoft from the general development community about software...

It must be daunting for a software vendor like Microsoft or Oracle to sort through thousands of bug reports and suggested feature requests. I do think that ISV or shareware...

After reading the entire article, I'm left with the impression that this guy is smart enough and can be personable when he tries, but he sounds like a "Millennial" or...

Rather than inserting into one table, another option would be to create a virtual table using a partitioned view.

create view v_WhatsUp_Assyst

as

SELECT nDeviceID, nDefaultNetworkInterfaceID FROM WhatsUp_Assyst_replicatie.dbo.device

union all

SELECT nDeviceID, nDefaultNetworkInterfaceID FROM WhatsUp_Assyst_replicatie2.dbo.device

union...

I have a job kicks off every 5 minutes and queries active requests and joins session info, t-sql statement, cpu/io/duration, etc. into a table on my local instance. Also, a...