What is a "Collecor"?

Not a question to the author. More a question for the web-site content Moderator and their spell checker.

For the author my comments are nice article....

Bill Talada (10/30/2015)

---

All versions are generally backward compatible (a new server can run an older database). The problem comes into play when you are backing up a newer version...

MonkSup (11/8/2015)

---

Thanks much for all of the feedback!

Part of what I will be doing is automating the upload of data to a set of external sites via XML. In a...

Jeff Moden (10/31/2015)

---

Heh... ok... without naming names.

I suggested to the "Compliance Officer" that they encrypt the SSNs (as well as other PII but at least the SSNs). She said...

Naming absolutely no names, have you ever run into resistance in implementing what you know to be vital security features?

Yes. all the time always and forever (30 years...

Thank you Aaron for a...

Keith Hays (9/28/2015)

---

Well, one of the issues I ran into with OLA's script was related to how partitions are re-indexed. Keep in mind this is from memory, At least until...

kyle.eldridge (9/23/2015)

---

Hi,

Not sure why the where is in there, thought I had removed that already, obviously not!

a CTE would be fine to hold the table names, but this runs just...

kyle.eldridge (9/23/2015)

---

Thanks, this is actually a very old revision which has since been revised.

please see the revised version:)

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

USE [Master];

SELECT mdsd.Name AS 'Database Name'

, dmes.Host_Name...

pietlinden (9/21/2015)

---

Apologies for baiting a troll, but one thing that would scare me about using Access/Jet for any important database is data security. I worked in healthcare for a...

erichansen1836 (9/21/2015)

---

You sound like you are hurt. Did you...

Lynn Pettis (9/21/2015)

---

PHYData DBA (9/21/2015)

---

erichansen1836 (9/21/2015)

---

I have to say Lynn,...

erichansen1836 (9/21/2015)

---

I have to say Lynn, you get the AWARD...

erichansen1836 (9/21/2015)

---

This situation never had anything to do with the OS ever. It is statements like this that make me wonder where you learned what you know and if it...

erichansen1836 (9/17/2015)

---

So now we're saying 32 bit processors can't seek past 4 gigs? Tell me more!

edit: Seriously, I don't write big files, so I haven't had to deal with this,...