Leveraging something like a botnet or backdoor trojan, a hacker doesn't even need physical access to the laptop to get at your files. The type of security threats that keep...

Consider setting up an audit event, DDL trigger, or profiler trace to keep track of when exactly a truncate operation is performed on this table. The simplist explanation is that...

Sigerson (4/9/2015)

---

ZZartin (4/3/2015)

---

In my last job I managed...

I hear that Bruce Willis is making a 6th 'Die Hard' movie about an aging night shift security guard at Windows Azure data center that gets held hostage by a...

Wayne, I guess what you're saying is that you don't trust your Cloud provider's ISP, because your own local ISP can't be trusted. However, one advantage to geo-location, aside from...

RonKyle (4/7/2015)

---

How does it end up being a type 3? ...

Maddave (4/7/2015)

---

Thanks. I agree there are definitely some improvements that could be made with this design.

Unfortunately, I cannot implement the delete by hour, well not yet anyway. The machines...

I hate delete operations. I always feel deletes, especially bulk deletes, indicate something is wrong with the database model or ETL design. What I mean by that is: why insert...

If you have some slush money left over in your disaster recovery planning budget, you can play off the fear of executive management by blocking off an entire day to...

Geo-replication and geo-backups are two different things. Every cloud data vendor should have daily or weekly off-site backups that include even the lowest tier customers who arn't paying for geo-replicatation.

tomsharp85 (4/3/2015)

---

Create Table for CompanyAddress1

...

I don't think an insert into the names is relevant here.Also I thought of splitting the address tables into 3 as in total there are more...

As a side note, without a constraint on this VarChar "date" column it will be a constant struggle to get users to enter data consistently and any conversion functions you...

tomsharp85 (4/3/2015)

---

OK, the names table was a generic way of listing for brevity, the tables are different industry sectors. Yes all of those tables are exactly the same. will your...

Somewhere in the bowls of every large corporation and government agency, there is at least one gray haired person dedicated to doing this....

The total number of pages on a report a user wants to scan through hasn't changed in five years. However, there are scenarios where an oranization prints 1,000 page reports...