Guess how many 360 K floppies it would take to backup a 1 TB database. Also try to guess how much time it would take if you had one guy...

Fortunately nowhere near the number required to backup the database.

What was originally coined "NoSQL" should really have been NoACID, since they have since discovered that in order for their database platform to be marketable outside the realms of academia...

Jeff Moden (7/12/2016)

---

HappyGeek (7/11/2016)

---

quentin.harris (7/8/2016)

---

True. It is a difficult place to be as a developer not sitting within the DBA/BI team but interfacing with their DW.

It seems to be...

It could be that the sessions performing updates on this table as part of a larger batch transaction. Often times programming will begin a transaction, update, and then do some...

What you're dealing with is probably blocking of some time. To get to the bottom of this issue, during these occasions where query latency is extremely long, you need to...

djackson 22568 (7/11/2016)

---

Japie Botma (7/11/2016)

---

djackson 22568 (7/11/2016)

---

What could possibly be embarrassing about...

quentin.harris (7/8/2016)

---

Awesome. Though i will be seeing flying pigs before i think i will be allowed to do this as it seems it can show sensitive information such as passwords....

David.Poole (7/11/2016)

---

Japie Botma (7/11/2016)

---

What about POPI laws? (Protection of Personal Information Act). If your data is in the cloud and the whereabouts of the actual server can change with...

I have a hanful of suggestion for making smart phones more secure.

First, I understand why Apple and Samsung manufactore their phones in cheap overseas sweatshops; it's all about economics. However,...

It's funny how, just within the past few years, 2 billion regular folks around the globe are burdened with the responsibility of being an accidental system administrator for a tiny...

SQL!$@w$0ME (7/7/2016)

---

Hello Folks,

Is it a good practice to create clustered index on non-primary key columns since the primary key column is not queried at all. Please share your thoughts or...

The Need for Developers Who Are Literate About Relational Database Design

TheFault (7/7/2016)

---

Iwas Bornready (7/7/2016)

---

Over forty years ago one of my advanced math classes had a problem about how to aim a moving sub's torpedo at a moving ship and hit...

The SoundEx fuzzy matching algorithm for comparing names dates back to Franklin Roosevelt era paper and microfilm records archiving.

https://www.census.gov/history/www/genealogy/decennial_census_records/soundex_1.html