MMartin1 (10/4/2016)

---

Are you sure this will never be a many to many relationship, even if it is not one now? A person can appear in more than one photo but...

Very true, Scott. But the original poster was talking about hundreds of tables, not hundreds of databases. There could be a terminology mismatch here between what he said...

I'd go with Grant's original advice: just do the backup. If there's no activity in the database since the last log backup, the amount written to your backup volume...

I would use an individual photo table for each parent with a 1:M relationship. Using a link table adds a layer of complexity for your application developers that isn't...

I am definitely adding "How large is your IT department" for future interviews. I've always had a file of questions to ask at interviews, and the worst jobs that...

The source code of the botnet that compromised IoT devices that knocked Brian Krebs off the internet is now available online, so expect to see more of this in the...

You say "without affecting the original". Make sure you're selecting "Copy-only backup" so you don't mess up your backup log chain, unless this is going to be part of...

The oldest DB book that I have at hand is The Practical SQL Handbook, published in '89 by Sybase/Addison-Wesley, and it shows the column names being defined as part of...

Reading David Poole's story above made me realize that my first real computer job 30 years ago that I was doing ETL. We had a canned time charge billing...

I can do it in a single line of code, so I could put it in a single function or statement vs a table, but seven REVERSE() seems a bit...

kiwood (6/9/2016)

---

Heading over I had noted while reading that the idea of filtering data before storage reaches into some hobbies. In model rocketry for instance, there are inexpensive altimeters that...

A subtle one, and I saw the answer right away. I love it when that happens!

And I haven't had my morning bottle of Starbucks yet, but I did sleep...

There are tons of places where you can download the PDF of the earlier printing, it has been revised and reprinted several times. This particular one apparently can be...

Yeesh, yeah, not easy to do. I started a training class for a bunch of COBOL/mainframe developers who didn't know the first thing about database or SQL Server. ...

In some ways I am an extremely punctual person. While doing film programs (back when it was 16mm film) for science fiction conventions, I committed the blasphemy of all...