Using the contents of the query plan cache, you can also parse the JOIN conditions of SELECT statement, to infer foreign key relationships. That would compensate for situations where foreign...

The SQL Server DBA should consider letting the application developers use Cassandra or MongoDB for their object persistence storage. Keep it local on the application server and let the application...

Used to be that most database records were manually entered into a terminal by employees who were paid by the hour. Today, the proliferation of the web, applications, devices, and...

If you're a contractor, then you're free to work for other clients, and you invest in yourself by self training and strategically choosing your gigs.

My initial thought is using information_schema views or sys tables to enumerate what table/column combinations constitute primary keys, join to any other tables that contains the same column combination, while...

I don't think you can rank IT developers on a single bell curve the same way you could an assembly line operator. It's more like ranking actors or chefs, where...

WayneS (9/21/2015)

---

pietlinden (9/21/2015)

---

Eric,

I go to the user group meetings the vast majority of the time. Hard to argue with free training where you can ask questions. =)

Maybe my problem is...

Honestly, if this recruiter is approaching you from some website like LinkedIn or Indeed, then I wouldn't even bother responding. You especially don't want to give them anything like source...

Dave62 (9/21/2015)

---

Jack Corbett (9/21/2015)

---

... Even though I'm considered a permanent FTE by HR, I consider myself a contractor with benefits. They can get rid of me...

The database tables are what integrates line of business applications, backend processes, and business intelligence. To change the schema of the tables, you have to get everyone on the same...

erichansen1836 (9/10/2015)

---

...

If you implement a Network database file system of 500 MDB files, each acting as a partial table within the 5 billion row database, each MDB file containing 10...

Regarding feelings of guilt about leaving, it's not necessarily directed toward the company but rather for co-workers who have become friends. As for the company itself, consider that the average...

.. Staying or going isn’t about loyalty, it’s about what is best for you and you can measure that in any way you want – money, vacation, or anything else....

Kristen-173977 (9/17/2015)

---

What about if majority of messages are small enough to fit in-row?...

First, from the client PC with connectivity issue, confirm you can ping server name and IP.