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

My understanding is that you have a Names table, and then you have an Address table. Actually you have multiple Names tables for some reason, but we'll put that aside....

It seems that most public software engineering discussions revolve around the paradigm of either eCommerce shopping carts or social media. But that's just not applicable to most database applications. They...

cyanes (4/1/2015)

---

I have a basic load proc (loading a staging area.) that truncates a target table just before inserting fresh data in said table, all wrapped in a distributed transaction....