SQL Server "Dynamic Data Masking" is a perfect example of an IT vendor re-inventing the wheel and branding it, sort of like "Meta Data Services", "Always On Clustering", or "In-Memory...

Your English compiles, but it's schizophrenic nonsense. Are you trying to sell of something here?

As a side note, it appears that SQL Server does take at least some measures to respect the intent of stored procedure compiled using the "with encryption" option, by blocking...

Regarding the Why of all this; if you are an ISV, and you don't want the business logic of the stored procedures to be in clear text, and the method...

Matt Miller (#4) (9/23/2015)

---

Maxer (9/23/2015)

---

Eric M Russell (9/23/2015)

---

Batching DML operations will always be faster than doing it one row at a time. However, keep in mind that a batch is...

AER (9/22/2015)

---

Hi Lowell,

I'm a DBA who administer all the Company databases. By 'intellectual property' I meant the scripts that are written in the databases. The problem is that our Client...

Batching DML operations will always be faster than doing it one row at a time. However, keep in mind that a batch is a single transaction, and splitting up a...

For Heap tables, wasted page space (ie: ghost records) resulting from deletes and updates is not reclaimed, so that's one consideration. Also for Heap tables the file number, page number,...

xsevensinzx (9/23/2015)

---

The last 3 companies I've talked to who are using the Microsoft stack for their applications have told me they are strongly considering NoSQL as an option. While they...

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