phonetictalk (7/9/2013)

---

I'm surprised (or I'd be surprised) that there isn't a way to automatically audit Excel sheets for these sorts of mistakes. I know Excel will highlight if a formula...

In addition to formulas not being replicated properly, another problem is when a cell that appears to contain a numeric value is treated as text by Excel, because it contains...

Somewhat related... Oracle has a feature called "Flashback" that leverages the transaction log to query the state of data for any table at a point in time using the "AS...

Where I work, we don't hire entry level developers straight out of university, or at least not on the database side. Every interview I've participated in has been with candidates...

Ed Wagner (6/27/2013)

---

I like the idea of having interviewers conduct interviews of some existing employees. We have to be able to separate a strong candidate who interviews poorly from...

djackson 22568 (6/26/2013)

---

Eric M Russell (6/26/2013)

---

I don't think that Microsoft can be faulted for insecure data. The database, network, and operating system framework that Microsoft has provided us is solid...

I don't think that Microsoft can be faulted for insecure data. The database, network, and operating system framework that Microsoft has provided us is solid when it comes to security....

TBIG (6/23/2013)

---

I need to do an INSERT for a subset of records in a table to the same table. What is the best way to determine the primary key of...

tania 56573 (6/5/2013)

---

Hi there,

My company has several instances of the same app. One app/database per client. Now maintenance has become a nightmare. I want to combine all into one. The...

If this is something like an audit log that's accumulates GB of data and is only occasionally queried, then you want to consider inserting these records into an external file,...

djackson 22568 (6/25/2013)

---

I agree that developers need to get better at using proper techniques.

That said, companies are the real root cause of poor software. The opposition to allowing time...

Gary Varga (6/25/2013)

---

Eric M Russell (6/25/2013)

---

By and large, employees are granted more access to data than they really need to perform their job functions. I'm surprised when people talk about...

By and large, employees are granted more access to data than they really need to perform their job functions. I'm surprised when people talk about a database with dozens or...

However why do we need to go to the maintenance plan's log? SQL Server includes the job history. It includes maintenance plans. Why doesn't the job understand there is a...

Cloud services are to SQL Server what web services are (or were) to application development. It's an interesting...