Most of my work could the classified as "refactoring". It's often intended to fix some issue in an existing database system (like performance optimization, auditing, or parallelizing a data load...

Are you more of a craftsman that develops new widgets for your clients to use, or are you the handyman, repairing and improving things that weren't built well enough the...

Steve Jones - SSC Editor (8/23/2012)

---

Eric M Russell (8/23/2012)

---

But unless your job is something like help desk support or hands on hardware, you don't really have to live in the...

But unless your job is something like help desk support or hands on hardware, you don't really have to live in the city to work for an IT department based...

From first hand experience, I can say that databases in the healthcare industry, especially for things like patient records and utilization data, has been very large for quite some time...

Teaching C programming to enginerring students in university is about like teaching medical students Latin. Upon graduating, engineers would benefit more from Java and SQL, and future doctors would benefit...

If I had to teach all college graduates one language, it would be SQL. It's more practical than C. Most all developers these days write at least some SQL, and...

sandeep rawat (8/14/2012)

---

One security concern .

When we connect any database using linked server .

All operation no data base will be operated by one user account( the account used for...

lianvh (8/2/2012)

---

Good Day ,

our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather...

oferhai (7/27/2012)

---

very good script - thank you!

i tested it on 2008 and it works great - the problem is that it is not working on 2012.

for 2012 all groups and...

So, if you're interested in query performance tuning in general,...

ChrisM@Work (7/26/2012)

---

Eric M Russell (7/26/2012)

---

Lynn Pettis (7/25/2012)

---

Eric M Russell (7/25/2012)

---

I'm not a beer connoisseur and don't care for the small batch gourmet stuff. When I drink beer, I'm either drinking...

Lynn Pettis (7/25/2012)

---

Or? ...

You can index a computed column that has the PERSISTED keyword.

http://msdn.microsoft.com/en-us/library/ms191250(v=sql.105).aspx

Mark R1 (7/23/2012)

---

This is a poorly done saas implementation that another company is hosting, I have been locking down individual logins, but that does no good unless I can restrict...