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

Deleting rows in chunks is the way to go, but you also need to perform a checkpoint and transaction log backup between each iteration. That will insure that the inactive...

Revenant (6/11/2013)

---

Steve Jones - SSC Editor (6/11/2013)

---

. . . I could see all kinds of quick analysis stuff moving because it's easier or quicker to throw something up in a...

Gary Varga (6/11/2013)

---

chrisn-585491 (6/11/2013)

---

I can see a scenario where organizations turn to cloud based services to host their e-commerce database or quickly spin up some one-off analytical solution requested by...